Insert in SQL Server from CSV File in Power Automate

Question

Javier Guzman 81

Hi Group

As we all know the "insert rows" (SQL SERVER) object is insert line by line and is so slow. I created CSV table already with all the data.

The next step would be to separate each field to map it to insert .
But I have a problem separating the fields of the CSV creation

Thanks so much for your help.

Answer 1

Bruno Lucas 4,216 MVP

If you add this logic:

You can proceed to use the json parse when it succeeds

When the Parse Json succeed, the fields will be already split by the json parser task

Follow Up after comment:

Looking on your flow, where is the 'OutPutArray' we see in #3 coming from? #1 or #2?

You may have those values easier to access back in the flow.

But Considering the Array "OutPutArray" passed to "Create CSV table" has the same values as the generated CSV
you can pick the filters like this:

variables('OutputArray')[0]['FieldName']

Can you share what is in the script you are passing to the SQL action? the error means it is not a applicable sintax for that operation

Javier Guzman 81 Reputation points

2022-11-03T19:42:28.387+00:00

@Bruno Lucas Yes, when is completed Create CSV Table my idea is insert all records in SQL Server
Javier Guzman 81 Reputation points

2022-11-03T21:33:14.403+00:00

@Bruno Lucas I need create CSV table and I would like to insert in SQL server.

I try to separate the field in CSV and include like parameter in Execute SQL
Bruno Lucas 4,216 Reputation points MVP

2022-11-04T00:13:36.61+00:00

Hi @Javier Guzman

I've added more to my answer but look like there is a temporary problem with the qna forum displaying images.
summary is to consider using the array to grab the fields : variables('OutputArray')[0]['FieldName']

0 additional answers