Answered

Is Power Automate pagination not supported when fetchxml is used to query data in List Rows?

(0) Share

Report

Posted on by Jitendra_FT

Hi,

I'm building a flow which queries a Dataverse table to fetch results using List rows action. I'm querying table using Fetchxml and turned on the pagination on the action to increase the default item limit to 10000 but I always get 5000 items.

I know pagination works with when I set Odata filters but never tried with Fetchxml. if anyone faced the similar challenge and found some work, please share.

flow screenshots attached for additional information.

Regards,

Jitendra

Categories:

Building flows

flow1.png

flow2.png

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

abouchaalaBAIT 932 Moderator on at

Like (1)

Report

I confirm because I already had this case. with fetchxml we can not get more than 5000 items

Right before updating a solution in production I had the great idea to update all List rows using OData to fetchXml. Everything works fine in dev until testing in production with large data.

The only solution that I found is to restore ListRows with OData queries.

Hope this helps

----------------------------------------------------------
If I have answered your question, please mark your post as Solved. 🆗✔️
If you like my response, please give it a Thumbs Up. 👍
You can accept more than one post as a solution.

Was this reply helpful? Yes No
Jitendra_FT 72 on at

Like (1)

Report

Hi @abouchaalaBAIT - Thanks for confirming.

Spent a considerable amount of time to make my solution dynamic using fetchxml directly from saved queries, now need to go back to original solution.

Was this reply helpful? Yes No