How to – Set Default value for the combo box in Canvas Apps (Dataverse)

Suppose we have the following Combo Box named Status bind to one of the choice fields of Dataverse.

Items = Asset Status option set field of table Product.

Now if we want Available to be the default selected value for it, we can use the DefaultSelectedItems property of the combo box.

DefaultSelectedItems = Filter(Choices(Products[@’Asset Status’]), Value = ‘Asset Status’.Available)

Also if we want to set the value of the Villages combo box based on the value selected in the Region combo box. The region is a lookup field in the Villages table.

We can update the Items property of the Villages combo box from

Villages (Data Source)


If(IsBlank(comboRegion.Selected),Villages, Filter(Villages, Region.Region = comboRegion.Selected.Region))

Hope it helps..


Enable Sound Notifications in Omnichannel (Voice and other channels) – Dynamics 365 for Customer Service

By default, this is how the notification appears for the agent when he is logged in to the app and is available.

There is no sound notification.

However, we enable sound notification here. This can be helpful in case the app is in the background and/or the agents are working on something else.

Navigate to Agent Experience >> Workspaces >> Notification Templates (Manage) in Customer Service Admin Center.

Let us enable sound notifications.

We can specify the following – Play sound, Sound to be played, whether the notification should keep on playing till the agent responds and the volume of the notification as shown below.

Here we also need to enable the Sound settings in the browser.

For the app, select Site Settings

Specify Allow for Notifications and Sound

Let us now call again, this time the agent hears the sound notifications, until he Accepts the call and that works even if the app/ the browser is minimized.

Hope it helps..


Understanding Overflow handling – Work item limit exceeds in Voice Channel – Omnichannel (Dynamics 365 Customer Service)

  1. Say for one the Advanced Queue of type Voice we have the following Overflow handling defined (the queue has only 1 user assigned to it).


Condition = Work item limit exceeds 1

Action = Voicemail

And it also has an Out of operation hours condition defined.

Now, if the customer calls during working hours and if the user’s presence is Available, the agent will receive the notification and the first conversation will have the Status as Active. If we make a second call its status will be open and it won’t go to Voicemail. Now if we make a 3rd call to that number it will go to Voicemail.

This is because we have set the Work item limit exceeds as 1, so it will keep one conversation in the open status, and any subsequent calls after that will go to the Voicemail.

Now here if the user is either in DND, Away, Offline, or not logged into CRM during work hours (if a customer calls outside work hours it will directly go to the Voicemail as we have the Out of operation hours condition defined), the first conversation will have the status as open and then any subsequent calls will go to the Voicemail.

In short,

More detail – Queue Overflow

Hope it helps..


Calculated Column inside Plugin? – Dataverse / Dynamics 365

Recently while working on a plugin, we realized that for a particular column, we were not getting value in the context (on Post Create), the same was the case for Post Update and Post Image.

Also using Retrieve and RetrieveMultipleto fetch its value inside the Plugin didn’t work

Eventually, we realized it was a calculated column, which doesn’t give value inside the Plugin.

If we do RetrieveMultiple and RetrieveMultiple from a console app, outside Plugin, we get the value for that field.

Hope it helps..



Unable to install the Profiler. Unhandled Exception: System.InvalidCastException: Unable to cast object of type ‘Microsoft.Xrm.Sdk.Entity’ to type ‘CrmSdk.PluginType’ in Dynamics 365 / Dataverse

We might get the below error while trying to install the profiler in the Plugin Registration Tool.

“Unable to Install the profiler”

“Unhandled Exception: System.InvalidCastException: Unable to cast object of type ‘Microsoft.Xrm.Sdk.Entity’ to type ‘CrmSdk.PluginType’. at Microsoft.Crm.Tools.Libraries.OrganizationHelper.InstallProfiler(CrmOrganization org, String prtPath) at Microsoft.Crm.Tools.PluginRegistration.OrganizationControlViewModel.<>c__DisplayClass302_0.<InstallProfiler_Clicked>b__2(Object o, DoWorkEventArgs e)”

On closing the window we will get the below message “Profiler install failed”

Well we can ignore this error, just click on Refresh

After the refresh is completed,

we can see that the profiler has got installed successfully, even though we got the error.

Hope it helps..



How to – Handle single quote/apostrophe in Filter Rows in Power Automate (Dataverse)

Say for e.g. we have the below flow, which finds the lead having subject as “My Test’s Value”

On running it we get the below error

To make it work we can make use of replace function here.


= to espace

= special character


Please refer to the helpful post-

This time it works successfully.

ChatGPT – quick to correct and give the right answer.

Hope it helps..


%d bloggers like this: