cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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
v-yuazh-msft
Community Support
Community Support

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

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
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (2,307)