Answered

CSV -> Flow -> MS SQL

(0) Share

Report

Posted on by Marco_h

Hi guys, ich hope you can help me.

The generally question is: can flow import csv files to ms sql ?

I have build a power app which receives its data from an ms sql database. At the moment I receive every morning a csv file by email which will be imported by powershell bulkImport on an virtual system.

I do not want to use the virtual windows instance and try to figure out if it is possible to realize the Bild import with Microsoft Flow.

Maybe anyone did this before ? Any code snippets or things that will help me ? Or is this not possible ?

Thank you community, my Google an forum searches are not wävery successfully:-/

Categories:

Using connectors

I have the same question (0)

All responses (10)

Answers (1)

Marco_h 8 on at

Like (0)

Report
Copy link

Link copied!

Without autocorrect;-)

##################

Hi guys, ich hope you can help me.

The generally question is: can flow import csv files to ms sql ?

I have build a power app which receives its data from an ms sql database. At the moment I receive every morning a csv file by email which will be imported by powershell bulkImport on an virtual system.

I do not want to use the virtual windows instance and try to figure out if it is possible to realize the Bulk import with Microsoft Flow.

Maybe anyone did this before ? Any code snippets or things that will help me ? Or is this not possible ?

Thank you community, my Google and forum searches are not very successfully:-/

Was this reply helpful? Yes No
Verified answer

v-xida-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @Marco_h,

Do you want to insert the data of CSV files into a SQL Table?

There is no way to analyze the data of a CSV file in Microsoft Flow currently, you could consider convert CSV files into Excel files manually and then we could insert the data of Excel files into a SQL table in Microsoft Flow.

If you have converted CSV files into Excel files, please take a try to insert data into a SQL Table with the following workaround:

If you would like this feature to be added in Microsoft Flow, please submit an idea to Flow Ideas Forum:
https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

Best regards,

Kris

Was this reply helpful? Yes No
Marco_h 8 on at

Like (0)

Report
Copy link

Link copied!

Thank you. This resolves the problem.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Can you please explain, How to convert CSV files into Excel files Automatically..

Is there any option (or) connector available?

Was this reply helpful? Yes No
harsh_sharma 4 on at

Like (1)

Report
Copy link

Link copied!

Hi Kris,

Is there any limit on Number of Rows that can be inserted in to the table at a time?

Was this reply helpful? Yes No
schlaufuchs 8 on at

Like (0)

Report
Copy link

Link copied!

AO

Was this reply helpful? Yes No
juresti 319 on at

Like (0)

Report
Copy link

Link copied!

Hello, I think I can help you with this issue.

If you use a tab delimited file instead you can try this.

https://powerusers.microsoft.com/t5/Flow-Cookbook/Read-tab-delimited-CSV-and-write-records/m-p/246459#M160

Was this reply helpful? Yes No
anton-khrit 197 on at

Like (0)

Report
Copy link

Link copied!

You can use Parse CSV action from Plumsail Documents connector. It allows you to convert CSV into an array and variables for each column. Please read this article demonstrating how it works.

Once you parsed CSV you can iterate through result array and use this data to insert into SQL table.

Was this reply helpful? Yes No
Hairy_Drumroll 251 on at

Like (0)

Report
Copy link

Link copied!

Excel "Get Rows" action is not longer available.
Use "List Rows Present in a Table" instead.

Was this reply helpful? Yes No
takolota1 4,978 Moderator on at

Like (0)

Report
Copy link

Link copied!

If anyone wants a comma delimited CSV reader / parser using only the standard actions in Power Automate that can also handle larger files, in-data commas, and in-data line-breaks, then try this template flow:
https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/CSV-to-Dataset/td-p/1508191

Was this reply helpful? Yes No