Free · runs entirely in your browser

D365 FetchXML builder

FetchXML is Dataverse’s own query language, the same one Advanced Find uses behind the scenes. Enter the table’s logical name, the columns you want and your conditions, and copy a query you can use in a flow, a report or Advanced Find.

D365 FetchXML Builder

Dataverse’s own query language: the syntax Advanced Find uses, not an OData translation.


      
      
    

Use this in a “List rows” action’s Fetch XML Query field, a custom report, or the FetchXML tab of Advanced Find. Field operators here cover the common cases, FetchXML supports more (like-x, between, on-x) that you may still need to add by hand.

How to use it

  1. Enter the table’s logical name, for example incident for Cases.
  2. List the columns to return, add your filter conditions, and set a sort order or row limit if you need one.
  3. Paste the FetchXML into a “List rows” action’s Fetch Xml Query field, a report, or the FetchXML view in Advanced Find.
A Dataverse List rows action in Power Automate with the Add new parameters list open, showing Select columns, Filter rows, Sort By, Expand Query, Fetch Xml Query, Row count, Skip token and Partition ID.
In a Dataverse List rows action, open Add new parameters and choose Fetch Xml Query, then paste the tool’s query into it. Screenshot: Microsoft Learn, CC BY 4.0.

Nothing you type here is sent anywhere. The tool runs entirely in your browser.

More free tools