Skip to main content

Notifications

Power Automate - Using Connectors
Answered

CSV -> Flow -> MS SQL

(0) ShareShare
ReportReport
Posted on by 8
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:-/
  • takolota1 Profile Picture
    takolota1 4,779 on at
    Re: CSV -> Flow -> MS SQL

    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

  • Hairy_Drumroll Profile Picture
    Hairy_Drumroll 246 on at
    Re: CSV -> Flow -> MS SQL

    Excel "Get Rows" action is not longer available.

    Use "List Rows Present in a Table" instead.

  • anton-khrit Profile Picture
    anton-khrit 197 on at
    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.

  • juresti Profile Picture
    juresti 319 on at
    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/246459#M160

     

  • schlaufuchs Profile Picture
    schlaufuchs 8 on at
    Re: CSV -> Flow -> MS SQL
    AO
  • harsh_sharma Profile Picture
    harsh_sharma 4 on at
    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?

  • 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?

  • Marco_h Profile Picture
    Marco_h 8 on at
    Re: CSV -> Flow -> MS SQL
    Thank you. This resolves the problem.
  • Verified answer
    v-xida-msft Profile Picture
    v-xida-msft on at
    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

  • Marco_h Profile Picture
    Marco_h 8 on at
    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:-/

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,434

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,722

Leaderboard

Featured topics