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.
