Hey Everyone,
I've been researching solutions for different problems in Dynamics 365, and I really think Flow is going to be a great tool in the toolbelt. But I've run into an issue that I can't seem to find any information on. When you do a List Records Action for Dynamics 365, by default it says the Max Get Count is 512. When I try and set it higher, it seems to ignore it and only get 512, then Page the results just like if you were using Fetch or Query Expression. I guess that in itself isn't a huge deal, but I don't see anywhere how to make sure that it continues through all the pages so I can do what I need to when I loop through all the records.
Anybody have any experience with it or thoughts?
Thanks!
Hi Nellefsen,
I think the max get count cannot be increase in flow now. You could post this idea in the Flow Ideas forum, so it might be considered for future releases.
https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas
Regards,
Mona Li
I have the same problem, did you find any solution?
This is due to one of the in-built functionality of MS Flow to list only 512 records by default. You can configure this by editing the settings on the "list record" action in your flow and turning the Pagination "On" and setting the limit manually - 6000 in your case @Anonymous. @Er_Dago
Refer this article for more reference : https://powerusers.microsoft.com/t5/Flow-Ideas/SQL-server-connection-Row-limit/idi-p/17666
Check out new user group experience and if you are a leader please create your group
See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.
User | Count |
---|---|
30 | |
11 | |
10 | |
7 | |
5 |
User | Count |
---|---|
45 | |
22 | |
13 | |
13 | |
10 |