One thing that drove me crazy on a regular basis was getting more than 5000 records from Dataverse in Power Automate. It felt like sometimes it was working while in other cases it was not. Microsoft’s documentation clearly states that it SHOULD be working when you are using Pagination 👍 A quick test on the Contact entity without any filters says this is true, first done without pagination returns exactly 5000 records....
Recently I had a few cases in working with Power Automate and Dataverse Plugins where I had do stuff like sums and other things related to many records. Until I mostly gone the probably “most simple” way: Fetching all relevant records and iterate through them and do the calculation that was needed. Works okay but always felt a bit cumbersome 🤔 This time I wanted to try something new I always was there but until now had never tried: FetchXML aggregates....
Here we are 🥳 I’ve been meaning to start this blog for quite some time, but only now got to it. Might be the developer in me, very stereotypical I focused first on building a blogging site instead of using something pre-made 🙄 But with that being done -> let the content creating start! 🚀 My main goal for this blog is to be a repository for all the things I try and build....