Update a .csv file to a xls(x) file

[frixel2]

I want to create a flow to update a .xls (x) file.

I have a .csv file that is updated daily with new rules under the existing rules from the day before.

I want this data to also be in a .xls (x) file if an update of the .csv has taken place.

This one will not work, after the update excel can`t open the .xlsx file.

[manuelstgomes · Accepted solution]

HI @frixel2 

That won't work. You're replacing the contents of the file and not the actual values in the Excel file.

You have here a nice explanation in how to deal with CSV files:

https://dynamicscitizendeveloper.com/2019/06/06/microsoft-flow-csv-integration-with-dynamics-365/

Then you just need to do a "For Each" and insert the data in Excel like this:

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
​
Cheers
Manuel

[v-alzhan-msft · Accepted solution]

Hi @frixel2 ,

Please take a try with @manuelstgomes 's suggestion and let me know if your problem could be solved.

Best regards,

Alice       

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.