Insert rows from excel sheet (not table) to SQL server table

(0) Share

Report

Posted on by city_80

Hello folks,

I am newbie in Power Automate Flows and I created a flow that runs every time when a file is created or modified on SharePoint.

This is how it looks and it works fine (picture below), but now I would like to INSERT data from the excel sheet directly to SQL table without "Delay" and "Execute stored procedures" steps.

So, my new solution I started as:

But I am not able to find a "table name".

If I put it manually, "Sheet1" as my data is stored in Sheet1, I am getting an error

So, what would be a solution to insert data from the excel file (Sheet1) to SQL server table? Data in the excel file looks like:

Sr_No	Country Code	TEST
8873506171	AT	AAA
8873509309	AT	AAA
8873509312	AT	AAA
8874304362	AT	AAA
9991907827	AT	AAA
9991908038	AT	AAA
9992007941	AT	AAA
9992007973	AT	AAA
9992007975	AT	AAA
9992408796	AT	AAA
9992408801	AT	AAA
9992509863	AT	AAA
9992509876	AT	AAA
9992803822	AT	AAA

Thank you in advance.

All responses (2)

Answers (0)

city_80 2 on at

Like (0)

Report

Re: Insert rows from excel sheet (not table) to SQL server table

@v-xiaochen-msft Let me try your solution and I will get back with feedback. Thanks for hints.
v-xiaochen-msft on at

Like (0)

Report

Re: Insert rows from excel sheet (not table) to SQL server table

Hi @city_80 ,

Firstly, have you created table in excel sheet?

The action can only recognize the data in the excel sheet table instead of the data in the excel sheet.

Secondly, if you have created a table in excel ,you could find the table name here.

Finally, you could invoke id parameter from 'create file' action.

Best Regards,

Wearsky