Unanswered

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

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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.

Categories:

Using connectors

I have the same question (0)

All responses (2)

Answers (0)

v-yuazh-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
gadgetman4u 31 on at

Like (2)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No