Share
Report
2Hi,
I have "Compose" action output in Power Automate as follows:
Column1,Column2,Column3
123456,1002,West
245634,7890,West
.
.
.
444456,1456,West
Similar rows of around 40000 records
I want to load all 40000 data (without headers Column1,Column2,Column3) onto a following Azure Sql table which has got following columns:
UniqueKey | Column1 | Column2 | Column3 | Column4 | Column5 | Column6 |
1 | 123456 | 1002 | West |
|
|
|
2 | 245634 | 7890 | West |
|
|
|
.
.
.
40000 | 444456 | 1456 | West |
|
|
|
UniqueKey is primary key auto-increment column defined at database level itself.
This is Scheduled trigger to run Weekly once, Compose action output can be different every time based on source data. Compose action output is dynamic.
Any help is much appreciated.
Categories:
I have the same question (0)
All responses (
Answers (
