I have a table in Dataverse that I want to query on a weekly basis. Depending on the outcome of the query, I want to upload some of that data to a table in Dynamics 365. Previously I would do this manually by exporting the data to Excel and then import the data using the import wizard in Dynamics 365.
I'm thinking that the best way to do this would be to use Power Automate to query the data and put it into a list, loop through the list and add the data to Dynamics 365. Most weeks will see < 50 records to add, but it could sometimes be > 10,000 records. My worry is timeouts, throttling etc.
If anyone has experience or thoughts on the best way to achieve the above, please let me know.