cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
rct224
Level: Powered On

Use MS Flow to save CSV file to one master Excel file

We have a customer inquery website that generates a CSV file with each interaction. I'd like to automattically take each CSV file and combine them into one master Excel file. Each CSV file has a header row and a data row. I'd like to take the data row and move it into the Excel file. Is it possible to automate this process with MS Flow? Each CSV file will be save independently into a central folder on OneDrive for Buisness.

2 REPLIES 2
Community Support Team
Community Support Team

Re: Use MS Flow to save CSV file to one master Excel file

Hi @ rct224,

 

I am afraid there is no way to analyze CSV file in Microsoft Flow currently.

There is a similar idea would like to get rows from a text file (CSV) submitted as link below:

https://powerusers.microsoft.com/t5/Flow-Ideas/Text-CSV-file-get-rows/idi-p/19494

 

You could consider convert all your CSV file to Excel file manually, and then get data with “Get rows” action of Excel connector .

 

 

Regards,
Alice Zhang

gadgetman4u
Level: Powered On

Re: Use MS Flow to save CSV file to one master Excel file

Is there a way to save the CSV file?  I have a CSV generated from Create CSV table and I want to save to a CSV file to be stored in Azure Data Lake Store.  Can it be done?

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020.

thirdimage

Flow 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 Flow Community Video Gallery!

Users Online
Currently online: 496 members 4,320 guests
Please welcome our newest community members: