Hi,
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,253 Super User 2024 Season 2
Martin Dráb 230,188 Most Valuable Professional
nmaenpaa 101,156