Following is the requirement:User has to upload an excel workbook from his local system documents on Powerapps.Once he clicks the upload button, a pow

You’re offline. This is a read only version of the page.

Power Platform CommunityForums Power Automate - General Discussion Upload Excel Data and ...

Power Automate - General Discussion

Unanswered

Upload Excel Data and Update SQL Table in SQL Server with the Uploaded Excel Records using Power Automate

Like (0) Share

Report

Posted on 18 Oct 2021 11:16:22 by drax_2106

Following is the requirement:

User has to upload an excel workbook from his local system documents on Powerapps.
Once he clicks the upload button, a power automate flow is triggered that will update the sql table in the server with the excel table records.
Once completed, the user is notified.

I need help with building the power automate flow for this scenario. Whatever threads I have referred, they are about inserting a the excel in a sql table. Need help with bulk upload and updation.

Categories:

Process Advisor

All responses (1)

Answers (0)

takolota1 4,898 Moderator on 29 Aug 2022 at 16:07:28

Like (0)

Report

Re: Upload Excel Data and Update SQL Table in SQL Server with the Uploaded Excel Records using Power Automate

If you know all the column names for the Excel files & SQL table, then you should be able to use this batch SQL template:

https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/SQL-Batch-Create-Read-Update-and-Delete/td-p/1715338