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

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

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?

How to display a Power Apps | Canvas app in full screen without the title bar?

Recently, I was asked to open a PowerApps | Canvas app without the title bar at the top of the screen. After some research, I found an answer from matthew devaney that proposed to add the "&hidenavbar=true" parameters to the URL of the application. This works perfectly and allows us to hide the title bar. … Continue reading How to display a Power Apps | Canvas app in full screen without the title bar?