cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Regular Visitor

CSV -> Flow -> MS SQL

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:-/
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: CSV -> Flow -> MS SQL

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:10.JPG

 

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

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

9 REPLIES 9
Highlighted
Regular Visitor

Re: CSV -> Flow -> MS SQL

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:-/
Highlighted
Community Support
Community Support

Re: CSV -> Flow -> MS SQL

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:10.JPG

 

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

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
Regular Visitor

Re: CSV -> Flow -> MS SQL

Thank you. This resolves the problem.
Highlighted
Advocate I
Advocate I

Re: CSV -> Flow -> MS SQL

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

 

Is there any option (or) connector available?

Highlighted
New Member

Re: CSV -> Flow -> MS SQL

Hi Kris,

 

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

Highlighted
New Member

Re: CSV -> Flow -> MS SQL

AO
Highlighted
Responsive Resident
Responsive Resident

Re: CSV -> Flow -> MS SQL

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/24645...

 

Highlighted
Helper V
Helper V

Re: CSV -> Flow -> MS SQL

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.

Highlighted
Advocate II
Advocate II

Re: CSV -> Flow -> MS SQL

Excel "Get Rows" action is not longer available.

Use "List Rows Present in a Table" instead.

Helpful resources

Announcements
firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

Join the new Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Users online (12,119)