cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Marco_h
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
v-xida-msft
Community Support
Community Support

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
Marco_h
Regular Visitor

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:-/
v-xida-msft
Community Support
Community Support

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

Marco_h
Regular Visitor

Thank you. This resolves the problem.
Anonymous
Not applicable

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

 

Is there any option (or) connector available?

Hi Kris,

 

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

schlaufuchs
New Member

AO
juresti
Responsive Resident
Responsive Resident

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

 

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.

Excel "Get Rows" action is not longer available.

Use "List Rows Present in a Table" instead.

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Users online (94,027)