cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
McMonty
Resolver I
Resolver I

Recurring imports

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.

 

0 REPLIES 0

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power Apps Community Call Jan. 2022 768x460.png

Power Apps Community Call

Please join us on Wednesday, January 19th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Kudoed Authors
Users online (1,459)