Retrieving Over 5000 Records in Dynamics 365 and Dataverse with Power Automate
Вставка
- Опубліковано 5 вер 2024
- Efficiently retrieve over 5000 records in Dynamics 365 and Dataverse using Power Automate.
In this video, I'll share tips on retrieving more than 5000 records in Microsoft Power Automate, including using XrmToolBox to obtain the fetchXML and oData query. I'll guide you through the process and provide solutions to any XrmToolBox issues. Stay tuned for the next video on running parallel "Apply to each" actions to optimize updating time in Dynamics 365.
There are different options to retrieve more than five thousands records,
like using paging cookies.
But in this video I will show you how to retrieve more than five thousand records in Power Automate by using XrmToolBox to get the fetchXML and oData query and then used it in Power automate.
If you don’t have XRMToolbox get the latest XrmToolBox. XrmToolBox is a free software.
1) Get the latest XrmToolBox from, www.xrmtoolbox..., download the latest version. Create a new folder on you local drive and called it for example XrmToolBox and unzip the file into that folder.
2) Than open the folder and click on the file XrmToolBox.exe to start the application
3) Once in XrmToolBox create a new connection to your environment
3) Now add the FetchXML Builder to your XmlToolBox and use it
If you have issues with XrmToolBox or want to know more about FetchXML Builder, please comment and if needed I will create a new video about that.
Irrelevant content, it doesn't work that way and it's not tested in the video. please do not share any more false information.
It is 100 % percent correct and tested information that I am giving. FetchXM in Power Automate by default returns only the first page, which is maximum 5000 records. If you want to get more than five thousand records, than you need to get that either via the approach “pagination with cache” or using the oData query approach that I have explained in the video.