cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
JayWinks
Level: Power Up

Import CSV not Excel?

Hello, I know this has got to be the n00b question of all time but for the life of me I can not figure it out and see no one else talking about it. How can I get CSV data into a flow. Not Excel, just good ol' CSV. I know you can get it out, how do I get it in.

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Import CSV not Excel?

Hi!

 

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.

View solution in original post

4 REPLIES 4
Community Support Team
Community Support Team

Re: Import CSV not Excel?

Hi @JayWinks,

 

I am afraid currently get data from CSV file is not avaiable under Microsoft Flow.

There is an idea submitted on this already:

Text (CSV) file - get rows

To generate CSV table is possible:

Try out this template to see this example of how it works. ( Copy SharePoint list items into a CSV each week)

 

Regards,

Michael

 

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
JayWinks
Level: Power Up

Re: Import CSV not Excel?

If there were a "Mark as Answer" I guess I could stomach that, but (and no offense to you, @v-micsh-msft) but I can't "Accept as Solution". This is absurd. How can Flow have been around this long, purport to be able to compete with IFTTT and not be able to extract data from a well-formed CSV file? I have seen other's suggestions and I have even seen responses of "yes, we know people are asking for it but we don't have any plan to do it." Wow.

 

The template you cite is not useful, it is CSV *output* which is something in which I am not interested. Customer has an AS/400 that can drop a CSV or an Excel file, and they *want* to touch the file before putting it in OneDrive but they don't want to have to create a table and then make sure they name it correctly. We're aiming for lowest amount of human interaction here.

ch2017
Level: Powered On

Re: Import CSV not Excel?

there is only this  workaround for now:

 

convert your file to xlsx and insert a table into the sheet you want to get values from; use the Excel action in MS Flow to get the rows

 

Super User
Super User

Re: Import CSV not Excel?

Hi!

 

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.

View solution in original post

Helpful resources

Announcements
firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

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!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Users online (5,065)