Skip to main content

Notifications

Microsoft Dynamics 365 | Integration, Dataverse...
Unanswered

Recurring imports

Posted on by 3,962

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.

 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans