Notifications
Announcements
Hi All,
I was creating automation where I have data files in xlsx on SharePoint Library and update on Dataverse table (Basically overwriting the entire table). Do we have any workaround to automate this using power automation.
Thank you
Depending on what exactly you're trying to do, yes, you can update a Dataverse table with info from a table in an xlsx file using the Excel connector in Power Automate. For specific questions on how to construct this flow I recommend posting your questions on the Power Automate Community forum for the best responses, but we can help here too.
Bryan
Hi @Hit_23 ,
Based on your business case, I would look at utilizing a dataflow, please see the following: https://learn.microsoft.com/en-us/power-query/dataflows/sync-excel-cds-dataflow
Using Power Automate may be the right approach. You can use trigger for SharePoint - file created to invoke the flow and then based on some unique identifier, you can create or update respective records in Dataverse table.
Recently i used the same approach for one of my project and it worked very well.
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.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 721 Most Valuable Professional
Michael E. Gernaey 320 Super User 2025 Season 2
Power Platform 1919 268