[Power Apps] Feature capability comparison between Modern Power Apps Maker Portal vs Classic Solution Explorer
Jan04

[Power Apps] Feature capability comparison between Modern Power Apps Maker Portal vs Classic Solution Explorer

As some of you may aware, there is a place called Power Apps maker portal (not to be confused with Power Apps portals) where you can customise the entities, forms, views, etc. instead of customising in the Classic solution explorer. There are only a couple of instances where it is mentioned as “Power Apps maker portal” in Microsoft documentation and most of the time, only the phrase “Sign in… Continue Reading...

Read More
[Power Apps] New improvements in Embedded Canvas Apps which are undocumented / unannounced
Dec28

[Power Apps] New improvements in Embedded Canvas Apps which are undocumented / unannounced

Since the announcement of the general availability of embedded canvas apps in model-driven forms, we have not heard any update on the Embedded Canvas Apps space, no mention of it in the Power Platform: 2019 release wave 2 plan either. However, despite not hearing anything from Microsoft for any new features/improvements on the Embedded Canvas Apps, the product team has been busy working on it… Continue Reading...

Read More
[Power Apps] Using Common Data Service's Lookup Data Type Field in Canvas App
Dec23

[Power Apps] Using Common Data Service's Lookup Data Type Field in Canvas App

If you come from the Dynamics 365 CE/CRM developer background, you would know that the value of the lookup field (or attribute, whatever you prefer to call it) comprises of 3 basic components: ID (the GUID of the related record)Name (the Primary Field value of the related record which is used as the Display value of the lookup field in the model-driven app)Entity Type (the logical name of the… Continue Reading...

Read More
Lookups Showing Same Custom View in Unified Interface because of Same viewId in addCustomView JavaScript
Dec23

Lookups Showing Same Custom View in Unified Interface because of Same viewId in addCustomView JavaScript

Recently in one of my Dynamics 365 projects, I had to filter the lookup using JavaScript because of the nature of the filter which cannot be achieved using OOB filter.I just simply write the following code to filter and set the viewId by generating some random GUID as set a static value. var viewId = “c83ee442-91d4-4b47-bb1b-92523c80e06b”; // Random GUIDvar entityName = “contact”; var… Continue Reading...

Read More
Pass Parameters to Quick Create Form in Dynamics 365 using formContext.data.attributes
Dec23

Pass Parameters to Quick Create Form in Dynamics 365 using formContext.data.attributes

With the deprecation of Xrm.Page.context.getQueryStringParameters, Microsoft Docs article suggested using formContext.data.attributes API to make retrieval of non-entity bound data consistent across entity forms.But some of the sample codes that I found online are all using the deprecated Xrm.Page.context.getQueryStringParameters and some are using… Continue Reading noreply@blogger.com (Linn Zaw Win)’s Article on...

Read More
[Power Automate] New Action "Executes a changeset request" in Microsoft Flow Common Data Service (current environment) connector
Dec23

[Power Automate] New Action "Executes a changeset request" in Microsoft Flow Common Data Service (current environment) connector

Today, I found one Action in Common Data Service (current environment) connector while I am creating an action step in Microsoft Flow.The action name is “Executes a changeset request” and I quickly check Microsoft Docs site for more info only to find the following one. (That’s very helpful, Microsoft… Thanks for the information) Maybe it is the preview feature or maybe it is still in progress…...

Read More
Intellisense Issue with Experimental Enhanced Formula Bar in canvas app for Power Apps
Dec23

Intellisense Issue with Experimental Enhanced Formula Bar in canvas app for Power Apps

I have been using Experimental formula bar in Power Apps Studio for a week and so far, I really like it. I can use Enter for a new linebring up suggestions on-demand using pressing CTRL+ Space (which does not show all the time)navigate around the formula bar with Up and Down arrow keys without getting into suggestionsexpand the formula bar with one click without dragging down all the timelook… Continue Reading...

Read More
Getting the Lookup Attribute of the Parent Record in Power Apps Canvas App Development with Common Data Service (CDS)
Dec23

Getting the Lookup Attribute of the Parent Record in Power Apps Canvas App Development with Common Data Service (CDS)

When you collect the CDS data source into the collection, you can add the fields from the related (lookup) entity using AddColumns function. That can be achieved because the lookup values from CDS data source are returned as a record in Power Apps comparing to Dynamics 365 SDK/API which only returns an Entity Reference with GUID and Entity Type.But adding the fields from the… Continue Reading noreply@blogger.com...

Read More
[Power Automate] How to Set Lookup Field Value in Common Data Service (current environment) Flow Connector
Dec23

[Power Automate] How to Set Lookup Field Value in Common Data Service (current environment) Flow Connector

If you’re using Common Data Service (current environment) connector in your flow and getting the following errors, that means you are either setting the GUID value directly ornot providing a correct plural version of entity schema name. Empty segment encountered in request URL. Please make sure that a valid request URL is specified. Resource not found for the segment xxxxx In (classic) Common… Continue Reading...

Read More
[Power Automate] List Records – Use Expand Query to Retrieve Related Data in flow
Dec12

[Power Automate] List Records – Use Expand Query to Retrieve Related Data in flow

Last week, Sara Lagerquist showed us How to Avoid the “Get Record” Action to Retrieve Related Data in Power Automate using the FetchXML in her blog post. Her post reminded me of another way that we can retrieve related data using the Expand query parameter of List records CDS action as I mentioned in one of the Power Automate Ideas.In this blog post, I will describe how you can use the… Continue Reading noreply@blogger.com...

Read More
[Error] code 2147748619 or 0x80040b0b when Email or Appointment is Saved with certain Contact, Account in Dynamics 365 / CDS
Nov30

[Error] code 2147748619 or 0x80040b0b when Email or Appointment is Saved with certain Contact, Account in Dynamics 365 / CDS

TL;DR version: The user cannot save the Email/Appointment if one of the Recipient/Attendee has an invalid email address. SYMPTOM When the user tried to save the Email or Appointment with certain Contact/Account record in Email Recipient/Attendee, the system shows an error messages as below with error message 2147748619 or generic error message and Error code: 0x80040b0b. Once the error message… Continue Reading...

Read More
[Bug] Using the ClearCollect() Function in PowerApps does not Pull any Lookup Columns from Common Data Service (CDS) Data Source
Oct07

[Bug] Using the ClearCollect() Function in PowerApps does not Pull any Lookup Columns from Common Data Service (CDS) Data Source

When I Collect from CDS Data Source into Collection in canvas app designer, the lookup fields are not being populated even though I can see the lookup values when I bind the data source to the data table.This is the sample formula that I used ClearCollect(ContactCollection, ShowColumns(Contacts, “fullname”, “createdby”)) And this is the output collection without any data in the lookup column. <a…...

Read More
Exporting Mobile Offline Profile as a Solution Automatically Add Dependent Components
Aug29

Exporting Mobile Offline Profile as a Solution Automatically Add Dependent Components

SYMPTOM When a solution containing a Mobile Offline Profile is exported, the system automatically adds the dependent components of the entities (from the Mobile Offline Profile) into the solution without any confirmation.It can be a problem when the deployment is done for selected components and not all of the changes are going to the target environment (not going to be completely in-sync). It… Continue Reading...

Read More
[Bug] setDefaultView is not working in the Unified Interface
Jul10

[Bug] setDefaultView is not working in the Unified Interface

Recently, there is an issue in Unified Interface where setDefaultView Client API in JavaScript is not working even though the same script is working for the same form in the legacy web client.formContext.getControl(“parentaccountid”).setDefaultView(“{00000000-0000-0000-00AA-000010001031}”); // GUID of Inactive Accounts viewAfter raising a ticket with Microsoft, the issue had been concluded as…...

Read More
Not Able to Fetch Data with Dynamics 365 Report Authoring Extension during SSRS Development
Jun20

Not Able to Fetch Data with Dynamics 365 Report Authoring Extension during SSRS Development

When I first set up the report project in Visual Studio 2015 with Dynamics 365 Report Authoring Extension 9.0 to develop the SSRS report for Dynamics 365, I got the following error while trying to fetch the data using FetchXML and I could not find any solution by having a quick web search. After contacting Microsoft Support, I was given the resolution below and I hope it helps for those who… Continue Reading noreply@blogger.com...

Read More
CRM Import Data Wizard of Team Failed with "Could not retrieve salesperson role" Error Message
Jun02

CRM Import Data Wizard of Team Failed with "Could not retrieve salesperson role" Error Message

Today, a colleague of mine tried to import the team data exported from Development environment into the UAT environment using CRM out of the box Import Data Wizard. The import was failed with the following error message “Could not retrieve salesperson role” even though there was no salesperson role assigned to those roles in Development environment. Actually, those unused OOTB security… Continue Reading noreply@blogger.com (Linn...

Read More
SQL Server Management Studio (SSMS) 18.0 Shows Splash Screen then Closes
May20

SQL Server Management Studio (SSMS) 18.0 Shows Splash Screen then Closes

IssueOpening SQL Server Management Studio (SSMS) 18.0 shows splash screen but the actual application is not loaded and the application closes without any error log.SolutionCopy the Microsoft.VisualStudio.Shell.Interop.8.0.dll from “C:Program Files (x86)Microsoft SQL Server Management Studio 18Common7IDEPrivateAssembliesInterop” folder and overwrite the one in “C:Program Files… Continue Reading...

Read More
Issue After Renaming SQL Server for CRM 2015 (Standalone Instance)
Nov20

Issue After Renaming SQL Server for CRM 2015 (Standalone Instance)

This morning, I was trying to rename the Computer Name of the VM that I copied from my colleague since the computer name was given with his initials. (so that I was trying to rename it to more generic one)The VM was installed with SQL Server 2014 and MS CRM 2015 all in one machine.After I’ve changed the computer name and restarted, I tried to open the Deployment Manager in order to update the… Continue Reading...

Read More
Async Workflows and System Jobs Stop Working and Stuck with Status Reason "Waiting for Resources"
Oct07

Async Workflows and System Jobs Stop Working and Stuck with Status Reason "Waiting for Resources"

Today, I encountered one issue at the client site where none of the asynchronous workflows are working any more. Any new workflow triggered on-demand or automatically by the event just go straight into the “Waiting for Resources” status.I tried practically everything that I’ve heard about the solution for the async workflow issues.Restarted the Microsoft Dynamics CRM Asynchronous Processing… Continue...

Read More
Save & Publish Button for Forms and WebResources for CRM 2015
Sep16

Save & Publish Button for Forms and WebResources for CRM 2015

Development for my previous projects, I’ve been using Save and Publish button by Jonas Rapp for customization of the forms. When I started the new project in CRM 2015, I cannot import the same solution anymore since CRM 2011 solutions are not allowed to import in CRM 2015 anymore.So, I just copied all the items from CRM 2011 solution and create a new managed solution for CRM 2015. You can… Continue Reading...

Read More
Fix for CRM 2013 SP1 UR3 The product key is not compatible with the installed version of Microsoft Dynamics CRM
Aug26

Fix for CRM 2013 SP1 UR3 The product key is not compatible with the installed version of Microsoft Dynamics CRM

Today, when I setup the secondary front end server of the existing CRM 2013 system with SP1 UR3, I encounter the following error message.The product key is not compatible with the installed version of Microsoft Dynamics CRM.When I searched around the web with the error message, this is the first article in the results and the issue is quite similar to mine.<br… Continue Reading noreply@blogger.com (Linn Zaw Win)’s...

Read More
Microsoft Dynamics CRM 2013 Notebook
Aug26

Microsoft Dynamics CRM 2013 Notebook

In this post, I am going to note down all the useful add-ons, information, tips and tools regarding with MS CRM 2013.Add-ons Advanced Find on record forms (CodePlex)CRM Chart Map (CodePlex)Custom Ribbon Button to get the Guid of the recordDynamics CRM Custom Email – Email Templates for Custom Entities (CodePlex)Duplicate Detection (CodePlex)EasyNavigate SiteMap (CodePlex)Form Message Web…...

Read More
Microsoft Dynamics CRM 2011 Notebook
Dec04

Microsoft Dynamics CRM 2011 Notebook

In this post, I am going to note down all the useful add-ons, information, tips and tools regarding with MS CRM 2011.Add-ons Activity SummaryAdvanced Validation (Regular Expressions)Appender for log4net (CodePlex)Auto Number [GapConsulting] Auto Number [jaimieji] Adding ImageTools to the CRM Attachment Image (CodePlex)Bulk Creating Testing Data (CodePlex)Controlling which Browsers Your… Continue Reading noreply@blogger.com...

Read More
Attachment File Data Truncated with QueryExpression.Distinct
Aug06

Attachment File Data Truncated with QueryExpression.Distinct

Today, I am experiencing one strange issue regarding with the attachment file from CRM being corrupted upon downloading through the external web site.That external web site is consuming the interface web service layer that CRM team implemented to perform CRUD and other specific data transactions.But the problem is that the attachment files bigger than 2KB are always corrupted downloaded… Continue Reading noreply@blogger.com...

Read More
Different Behaviours of IOrganizationService.Create Method Triggered Synchronously and Asynchronously
Aug06

Different Behaviours of IOrganizationService.Create Method Triggered Synchronously and Asynchronously

When I have to create a duplicate records with common attribute values, I usually just write a Create line of code in the loop without re-initialising the object. Entity testRecord = new Entity(“new_testentity”); testRecord[“new_parentrecordid”] = new EntityReference(“new_testparententity”, parentEntityId); for (int i = 0; i < itemCount; i++) { testRecord[“new_serialno”] = i + 1;...

Read More