Mehdi El Amri

[Model-driven apps – Virtual Tables] How to resolve the AAD User’s lookup issue in MDA forms before Microsoft’s fix?

Microsoft has recently introduced a virtual table called AAD User. This table allows to retrieve any user in an organization’s Azure Active Directory. This feature is available on all environments, no action is required to use it. One possibility is to create lookup columns of type AAD User. This will allow to create relationships between … Continue reading [Model-driven apps – Virtual Tables] How to resolve the AAD User’s lookup issue in MDA forms before Microsoft’s fix?

Mehdi El Amri

[Model-driven app – Custom Pages] How to fix the UserNotLoggedIn error when loading a custom page on the iOS native player?

As you know, Model-driven apps can be used on different clients, like Android smartphones and tablets or iOS iPads and iPhones. Recently, I had the opportunity to test Custom pages with the Native player from Microsoft on Android and iOS. This worked perfectly on Android, but not on iOS. Indeed, an error message is displayed … Continue reading [Model-driven app – Custom Pages] How to fix the UserNotLoggedIn error when loading a custom page on the iOS native player?

Mehdi El Amri

[Model-driven apps – In-App notifications] Only System Administrators can view notifications, What about the other users ?

In-app notifications for model-driven apps is a feature that has historically been highly requested by the Dynamics 365 community for the past few years. To meet this long awaited need, Microsoft has introduced this feature for Dynamics 365 CE but not only, also for model driven applications, a Power Apps license is enough to take … Continue reading [Model-driven apps – In-App notifications] Only System Administrators can view notifications, What about the other users ?

Mehdi El Amri

[Model-driven apps – Power Fx] How to open multiple rows in new tabs using Power Fx commands ?

According to the roadmap published by Microsoft, Power Fx commands for model-driven apps will go into general availability from May 2022. This blog will discuss an example using modern commands, and I hope it will encourage you to adopt this new way to customize the command bar and buttons. As mentioned in the blog title, … Continue reading [Model-driven apps – Power Fx] How to open multiple rows in new tabs using Power Fx commands ?

Mehdi El Amri

[Power Automate – Dataverse] How to execute a fetchXml query that includes options not supported by the List rows action?

Dataverse list rows connector allows to retrieve rows from a Dataverse table. This connector can filter rows using OData expressions or fetchXml queries. Unfortunately, the connector does not support all fetchXml requests. This blog will discuss an approach to execute this kind of unsupported queries. Let's look at what the documentation says:The distinct operator and aggregation … Continue reading [Power Automate – Dataverse] How to execute a fetchXml query that includes options not supported by the List rows action?

Mehdi El Amri

[Canvas Apps – Dataverse] How to get distinct values from datasource ?

Power Apps Canvas Apps offers the Distinct function that returns unique values from a table or data source. Unfortunately, this function may not work as expected if the data source contains a large data set. Let's look at this with an example by reproducing the issue: Let's take the Dataverse table 'Contact' and its column … Continue reading [Canvas Apps – Dataverse] How to get distinct values from datasource ?

Mehdi El Amri

[Model-driven apps – Client Scripting] How to avoid calling the same function twice when creating a new record ?

Model-driven apps offer a client API that allows us to implement some business logic in JavaScript. The client API accepts to attach functions to events such as form loading, data changing and more. Generally, we have two possibilities to register a function for a given event. Either in a static way, using configuration. Or dynamically, … Continue reading [Model-driven apps – Client Scripting] How to avoid calling the same function twice when creating a new record ?

Mehdi El Amri

Optimistic Concurrency in Model-Driven Apps Forms

This blog will discuss a proposed implementation of Optimized Concurrency for Model-Driven Apps forms. My implementation is executed on the model-driven app only, using the client API and the new Asynchronous capabilities that the API offers. I won't go into the details of my analysis that led to this implementation proposal. However, I was strongly … Continue reading Optimistic Concurrency in Model-Driven Apps Forms

Mehdi El Amri

Dynamics 365 CRM [Dataverse] – How to cancel the merge cascade for a given relationship ?

In the previous blog, we saw the possibility to force the merge of two accounts if the subordinate account is attached to an active offer. Today we will see how to cancel the merge cascade for a given relationship. Before going further, we will see the standard behavior of the merge. Indeed, after the merge, … Continue reading Dynamics 365 CRM [Dataverse] – How to cancel the merge cascade for a given relationship ?