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