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 ?
This blog will discuss how to calculate the size of a media file in a canvas app. This can be useful if needed to do some validation on the size of the media that will be uploaded by a user. The demo below shows the scenario where the app displays the size of an image … Continue reading How to calculate media file size in a PowerApps CanvasApp ?
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
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 ?
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?
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
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 ?
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?
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!