Dataverse – Page 32 – Nishant Rana's Weblog

Get RequiredAttendee (Required) from the Meeting (appointment) table – Power Automate / Dataverse

Below is the sample flow we can use to retrieve the Required (requiredattendees) field’s value from the Meeting table (on the update of the record).

Here we are triggering the flow, if there is an update in the subject field of the meeting record.

Then using the List rows action we are fetching the Activity Parties record associated using the Appointment’s unique identifier and participation mask as 5.

Advertisements

Filter rows using contains, startswith and endwith Power Automate – Dataverse

Recently in one of our projects, we were using the Microsoft Bookings App for the users to book an appointment(outlook) and then were syncing this appointment back to Dynamics 365 through the category “Tracked to Dynamics 365” (Server Side Synchronization)

Get more details on it here – https://nishantrana.me/2022/03/22/how-to-synchronize-appointments-between-dynamics-365-and-outlook-using-server-side-synchronization/

Here if the users were canceling the tracked appointment in Outlook, it will update the subject of the appointment record with the prefix – Canceled but will not cancel the record i.e. update the status of the record.

This would happen if the user canceling the appointment is not the organizer.

https://learn.microsoft.com/en-us/power-platform/admin/sync-logic#syncing-canceled-and-deleted-appointments-from-exchange-to-dynamics-365

So here we were implementing a flow to check for updates in the Subject column with the word canceled and then updating the status of the appointment as canceled.

Here we can specify our select columns and filter conditions as follows – contains

Or startswith

https://learn.microsoft.com/en-us/power-apps/developer/data-platform/webapi/query-data-web-api#standard-query-functions

Hope it helps..

Advertisements

Using existing Web Resources (image) and Icons for button/ command – Dynamics 365 / Model-driven apps

In case of a new command that is added through Command Designer, we can specify an existing Icon using the Use Icon option.

We can also search and specify an existing Web Resource

Similarly, we can use Icon Gallery (XrmToolBox Plugin) to search for the existing web resource image and icons.

We can then use Copy Name option to get the full path of the web resource

msdyncrm_/KnowledgeManagement/_imgs/KnowledgeSearchProvider.svg

use it to specify Modern Image for our buttons

Hope it helps..

Advertisements

Error with Global Choice / Optionset with the same display name and In operator – Power Apps / Dataverse

Recently while trying to filter the Combo box Items using the value of the Global Multi-choice field, we were getting issues in the formula.

It was because the optionset / choice field in the table and the global optionset / choice, it was referring to, both were having the same display name.

Issue –

To get it working we renamed the display name of the Global Choice column.

After which we were able to get our formula working.

Same is the case for the single choice field which is referring to global choice.

Gender is the display name of the field in Lead and Global Gender is the display name of the global choice field.

LocalOptionset

Hope it helps..

Advertisements

Applying filter on Multi Choices / Multi-Select OptionSet – Power Apps / Dataverse

Say for e.g. we have 2 multi-select choice columns in our leads table, one is local (My Local Multi Choice Field) and the other field ((My Local Global Multi Choice Field) refers to the global option set field

In our Canvas App, to filter on ‘My Local Multi Choice Field’ by value Local Choice 2 and Local Choice 3, we can apply the below formula.

Similarly, for the Global option set to apply a filter on the Global Choice 2 value, we can compare the field in the lead with the values in the Global Option set.

As we are using “in” operator, we’d get the delegation warning. And for it to work in the case of combo box we would have to set “Allow Searching” to “Off“

Hope it helps..

Advertisements

Fixed – Invalid data from the network error in the custom page – Power Apps / Dataverse

Recently in one of our custom pages, we were getting the below error

“Invalid data from the network”

We had this setting “Formula-level error management” as On, switching it off was hiding this error on the page.

To fix it we tried removing the fields one by one to figure out the issue. Eventually, we saw the error was going away if we remove one of the option set fields from the gallery or comment it’s formula. Later when we removed and added the field back in the gallery and the error got fixed for us.