In the fast-evolving world of digital business solutions, customization and efficiency are key. For users of the Microsoft Power Platform, especially those working with Microsoft Dataverse, grids are essential for displaying and interacting with data. However, the out-of-the-box (OOB) grids within Microsoft Dataverse, including dashboard grids, entity main list grids, form grids, associated grids, advanced find grids, and lookup window grids, often lack the flexibility that users need for a truly personalized experience. [Read More]

CASE 1 FROM QUESTION 01 TO 08

Question 01 Question 02 Question 03 Question 04 Question 05 Question 06 Question 07 Question 08

CASE 2 FROM QUESTION 09 TO 17

Question 09 Question 10 Question 11 Question 12 Question 13 Question 14 Question 15 Question 16 Question 17

YES/NO QUESTION FROM QUESTION 18 TO 31

Question 18 Question 19 Question 20 Question 21 Question 22 Question 23 Question 24 Question 25 Question 26 Question 27 Question 28 Question 29 Question 30 Question 31

SQL QUESTION FROM QUESTION 32 TO 43

Question 32 Question 33 Question 34 Question 35 Question 36 Question 37 Question 38 Question 39 Question 40 Question 41 Question 42 Question 43

OTHERS

Question 44 Question 45 Question 46 Question 47 Question 48 Question 49 Question 50 Question 51 Question 52 Question 53 Question 54 Question 55 Question 56 Question 57 Question 58 Question 59 Question 60 Question 61 Question 62 Question 63 Question 64 Question 65 Question 66 Question 67 Question 68 Question 69 Question 70 Question 71 Question 72 Question 73 Question 74 Question 75 Question 76 Question 77 Question 78 Question 79 Question 80 Question 81 Question 82 Question 83 Question 84 Question 85 Question 86 Question 87 Question 88 Question 89 Question 90 Question 91 Question 92 Question 93 Question 94 Question 95 Question 96 Question 97 Question 98 Question 99 Question 100 Question 101 Question 102 Question 103 Question 104 Question 105 Question 106 Question 107 Question 108 Question 109 Question 110 Question 111 Question 112 Question 113 Question 114 Question 115 Question 116 Question 117 Question 118 Question 119 Question 120

Process dialogs are deprecated and will be removed by December 1, 2020. Until that day. Did your company have replacement options? Replace dialogs Power Apps component framework Development of custom Html/JS Webresources with help of modern frameworks … With some keywords on Google: dynamics crm 365 cds dialog you found: The first post: Custom Dialog Boxes - Part 1 of Bob Guidinger. He wrote on: July 22, 2018 Then on July 29, 2018 he wrote second post: Custom Dialog Boxes - Part 2 [Read More]

You are a Dynamics 365/CDS developer. How you build your FetchXML string in JavaScript/C# code? Are you use the function: Download Fetch XML in the Advanced Find window? Wow, look like you have a lot of tasks :cold_sweat: after you Download Fetch XML Open the xml file with the text editor Find " and Replace with ’ Edit, join to make a correct string, also with a dynamic parameter ….. Instead click the button Download Fetch XML in the Advanced Find window, you can click the button View FetchXML near it by install the solution View-FetchXML [Read More]

Server-to-Server (S2S) authentication (only support Dynamics 365 online) was great, it use ClientId/SecretKey to authentication (instead use UserName/Password) and it use without Dynamics 365 license. But everybody have problem when use CllientId/SecretKey, the main problem is HTTP Error 401 - Unauthorized: Access is denied I headache this problem more than 3 days, and now, I succeed authentication with ClientId/SecretKey. This post I will fully explain you how I can achieve it. [Read More]

When building hyperlinks to CRM in SSRS reports, please don’t hard code Wrong: hard coding your CRM URL. Do not set your URL to “https://crmserver/….” If you do this use the hyperlink will only work in one environment and will have to be rewritten to work in another environment. Right: Use the CRM_URL parameter in your report. This makes your links will work in all environments, even when offline. Parameters!CRM_URL Wrong: Using OTC (ObjectTypeCode) in your hyperlink expression. [Read More]

Sometime, your business logic need access direct SQL Server, and you want to know the ConnectionString of CRM Database. This code will help you get Sql ConnectionString from CRM Plugin/Custom Action/Custom Workflow (before that I saved the ConnectionString to the custom Options entity) public void Execute(IServiceProvider serviceProvider) { var context = (IPluginExecutionContext)serviceProvider.GetService(typeof(IPluginExecutionContext)); var platformContext = context.GetType().InvokeMember("PlatformContext", BindingFlags.GetProperty, null, context, null); var transaction = (SqlTransaction)platformContext.GetType().InvokeMember("SqlTransaction", BindingFlags.GetProperty, null, platformContext, null); throw new InvalidPluginExecutionException(transaction. [Read More]

I have a requirement in my current project that hide Next Stage, Set Active and Back button in the Business Process Flows To do that, I used an UnSupported code code below function hideBPFButton() { hideBPFButtons(); window.addEventListener("resize", hideBPFButtons); Xrm.Page.data.process.addOnStageSelected(hideBPFButtons); } function hideBPFButtons() { var dom = (Xrm == undefined || Xrm.Internal == undefined || Xrm.Internal.isTurboForm() == undefined || Xrm.Internal.isTurboForm() == false) ? document : parent.document; $("#stageSetActiveActionContainer", dom).remove(); $("#stageBackActionContainer", dom).remove(); $("#stageNavigateActionContainer", dom). [Read More]

Sometime, your business requirement need add some buttons in the form sub-grid like picture below (Account form, sub-grid Contacts). How I can do that 1. Prepare 2 web-resource png image 16x16 file. 1 for normal button 1 for hover button 2. Copy function below to your main js web-resource file. function createButton(grid, buttonName, buttonTooltip, buttonImage, buttonImageHover, callback) { if (grid == null || grid.length == 0) return; if (buttonName == null || buttonName. [Read More]

Sometime you need to get size of all tables in database. This SQL code will help you. DECLARE @tmpTable TABLE ( [RowCount] INT , [TableName] NVARCHAR(MAX) ) DECLARE @ResultTable TABLE ( [Name] NVARCHAR(MAX) , [Rows] INT , [Reserverd] NVARCHAR(MAX) , [Data] NVARCHAR(MAX) , [IndexSize] NVARCHAR(MAX) , [Unused] NVARCHAR(MAX) ) INSERT INTO @tmpTable ( [RowCount] , [TableName] ) SELECT [RowCount] = MAX(si.rows) , [TableName] = so.name FROM sysobjects so , sysindexes si WHERE so. [Read More]