Forum Discussion

HamidBee's avatar
HamidBee
Icon for Power Participant rankPower Participant
2 years ago

Utilizing Dataflows for Recurring Excel File Updates in OneDrive and Upsert Operations in Dataverse

I am currently investigating the use of Power Automate and Dataflows for handling a scenario in which Excel files are regularly uploaded to a OneDrive folder, with each file containing a table that n...
General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

1. yes

2. none if you use the API

3. As long as you keep the dataflow nimble (no fancy transforms or attempts at merges) performance  should "measure up"  - whatever that means in your environment. It sure outperforms Excel.

4. I'm pretty sure you can specify dynamic content in that dialog.  It will become hairy, however, when these tables have different structure.