How to copy data from Excel to Azure SQL in Power Automate

We'll learn the techniques

1. :
   • Use the Excel action in Power Automate to upload an Excel file to OneDrive for Business (EXCEL, UPLOAD, ONEDRIVE FOR BUSINESS).

2. Prepare worksheet for Power

   Automate flow:
   • In Excel Online, insert a table (INSERT TABLE) and organize the data according to the need of the Power Automate flow.
Query the data storage table
3. :
   • Use Azure Data Studio or another SQL tool to query the data storage table in SQL Server (SELECT, COLUMN DATA TYPE).

4. Create Manual Run Flow:

   • In Power Automate, create a manual run flow (POWER AUTOMATE, INSTANT CLOUD FLOW, TRIGGER) that will be triggered manually.
Step to Read Excel File in OneDrive for Business
5. :
   • Add a step to read the data from the Excel file in OneDrive for Business (LIST ROWS PRESENT IN A TABLE).

Step to Delete records from table
6. :
   • Use the SQL Server action in Power Automate to delete records from the table (SQL SERVER, EXECUTE QUERY).

7. Step to Insert Records

   into the table:
   • Use the SQL Server action in Power Automate to insert new records into the table (SQL SERVER, INSERT ROW).

8. Important tip for Dynamic content:

   • Use the dynamic content feature (ADD DYNAMIC CONTENT, EXPRESSION) to make the flow more flexible and adaptable to different situations.

9. Run Power Automate Flow:

   • Test and run the Power Automate flow (TEST, RUN FLOW) to verify integration and proper functioning.
Query the Table records in the
10. Azure database:
    • Use a SQL tool to query the records in the Azure database table (SELECT, ROWS).