Showing results for 
Search instead for 
Did you mean: 
Helper V
Helper V

How to do DataVerse Upserts using Power Automate?

Hello All,


I had done proof of concepts using One Drive (Excel Files)  and Data Flows to Upsert Data into DataVerse tables.  It was all working great  but then the clients came back and told us that they  don't have one drive and that they can give us a shared network folder. We are basically trying to 'upsert'  the Dataverse tables with "daily differential" data from other systems within the organization, which would get dumped as Excel files onto this network share. 


Since I can't use Data Flows, because I honestly don't know how to use Data Flows with Excel files if we don't have an One Drive, my only other option I guess is to use Power Automate flows. I am struggling to find even one article that covers  how to Upsert data in Dataverse tables with Excel file as the source.


Any pointers would be of great help.




Helpful resources

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Top Solution Authors
Users online (1,961)