Loading...

[Power Automate – Dataverse] How to execute a fetchXml query that includes options not supported by the List rows action?

[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 … Continue reading [Power Automate – Dataverse] How to execute a fetchXml query that includes options not supported by the List rows action?

Published on:

Learn more
XRM Tricks (Power Platform & Dynamics CRM )
XRM Tricks (Power Platform & Dynamics CRM )

Power Platform & Dynamics CRM

Share post:

Related posts

Introduction to Managing a WordPress blog using Power Automate – Part 1

My WordPress blog SharePains.com has been running on WordPress for a very long time now, and with so many posts it is a real challenge to make...

7 hours ago

Power Automate: mod function

Power Automate’s “mod” function helps you find the remainder after dividing one number by another. While it might not be the...

2 days ago

Update Business Process Flow Stage using Excel Import with Power Automate – Dataverse / Dynamics 365

In some business scenarios, we might need to update the Business Process Flow (BPF) stage of a record during an Excel import — especially duri...

4 days ago

Debunking: Dynamics CRM Destination – How Text Lookup Works

When we want to push data to Dataverse/Dynamics CRM using SSIS – KingswaySoft, usually there are relationships (lookup) that we need to ...

5 days ago

Understanding Activity Party Types in Dynamics 365 CE

Dynamics 365 Customer Engagement features 11 unique activity party types, identified by specific integer values in the ActivityParty.Participa...

5 days ago

When an Item is Deleted trigger is not triggering in Power Automate

Today Connor and I found that a flow with the When an Item is deleted, was not being triggered. Why could this possibly happen?

8 days ago

Power Automate – Information regarding disablement of the ‘How often do you want to look for new items?’ setting

On March 31, 2025, we temporarily disabled the ‘How often do you want to check for new items?’ setting in Power Automate. We plan ...

8 days ago

Power Automate: dateDifference function

The “dateDifference” function is a powerful tool for when you need to calculate the difference between two dates. It gives you a reliabl...

9 days ago

How to use the Azure AI Foundry connector in Power Automate

Today I had a look into the Azure AI Foundry connector in Power Automate. My findings on this connector are in the post below.

9 days ago

How to Programmatically Add Option Set Values in Dynamics 365 with Power Automate

In every Dynamics 365 or Power Apps implementation, it’s common to require fields where users select values from predefined lists—such as Job ...

9 days ago
Stay up to date with latest Microsoft Dynamics 365 and Power Platform news!
* Yes, I agree to the privacy policy