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!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Kudoed Authors
Users online (2,090)