[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 ?

[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 ?

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

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 ?

Dynamics 365 For Sales: How to merge Accounts if the subordinate record is associated with one or more active quotes?

Merging records on Dynamics 365 CRM is a very powerful feature that prevents duplicate records. I was asked to study this feature for a client who wanted to clean up his customer records, and we reached a point where we had to merge accounts that were related to active quotes. If you didn't know it, … Continue reading Dynamics 365 For Sales: How to merge Accounts if the subordinate record is associated with one or more active quotes?

Transform your Model-driven app to a multi-session app using settings solution component

This blog will discuss new component added to Power Apps. It is about the "Settings" component. Indeed, this component allows adding a configuration layer for a model-driven application. This allows to easily activate or deactivate a feature for a model-driven app. For more information on this component, I invite you to read this excellent blog … Continue reading Transform your Model-driven app to a multi-session app using settings solution component

Unpack Canvas App Error PA3005: Connection ‘XXX’ does not have a corresponding data source… How to get around this issue ?

This blog will discuss a workaround to solve the "PA3005" error that occurs when attempting to unpack a Canvas App. Indeed, this error occurs when validating the *.msapp source file of some CanvasApps. Below is the output of the command when I tried to unpack my "mySuperCanvasApp.msapp": The tool returns the validation error: Connection 'UsersList_1' … Continue reading Unpack Canvas App Error PA3005: Connection ‘XXX’ does not have a corresponding data source… How to get around this issue ?

How to pass an object from a model app driven app to a custom page?

According to the current documentation, we can pass a dataverse record as a parameter. This is still very beneficial for some scenarios. But what if we want to pass a set of parameters without using an existing record. After several attempts, I managed to pass an object containing some properties from the model driven app … Continue reading How to pass an object from a model app driven app to a custom page?

Tired of creating a new console application to connect to Dynamics 365 CRM/Dataverse? Use a template!

Sometimes we are asked to create console applications that interact with Dynamics CRM/ Dataverse, and like every new developer, we create a new project and look for a piece of code on the internet to start, or we copy existing code from an old project. I used this approach during all my projects, today I … Continue reading Tired of creating a new console application to connect to Dynamics 365 CRM/Dataverse? Use a template!