Follow

Follow

XrmToolBox | FetchXML Builder

How to convert FetchXML to OData Filter

Frédérick Grobost's photo
Frédérick Grobost
·Sep 28, 2022·

1 min read

Play this article

Why change from FetchXML to OData Filter

Imagine the scenario (quite common in fact)

You have to retrieve in a Dataverse List Rows action the list of activities (activity pointers)

image.png

You know you have a looooooot of rows, so you activate the Pagination.

image.png

So far so good

image.png

You run it and 😱 WHY IS THERE ONLY 5000 ROWS RETRIEVED ?

Well yes, pagination does not support FetchXML !

So what to do ?

Well, you have to convert your FetchXML to OData filters

How to convert your FetchXML to OData filters

To convert your FetchXML to OData filters, you can use XrmToolBoxand its fantastic FetchXML Builder.

  • Copy-paste your FetchXML in the tool
  • Select View -> Power Automate Parameters or Ctrl + Alt + P
  • Copy back the generated OData Filters to your List Rows action

image.png

image.png

image.png

Now it works !

image.png

 
Share this