Simple MS Flow to create excel file in SharePoint = always corrupted file
I have created a very simple flow to query SharePoint list and then populate the results into the excel file. I'm easily able to do it with .csv file but my customer doesn't like it because he needs to expand all columns manually 🙂 So I wanted to do the same but create an .xlsx file, but whatever file content I put into the property, I'm never able to open it in Excel online or desktop app.
Any help would be greatly appreciated.
The main steps of the flow are:
Multiple SharePoint 'Get Items' queries to get list items.
'Create CSV table' for each query to format the results.
Create .csv file (works!) and .xlsx file (no luck) populated with the query results.