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

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