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

Simple MS Flow to create excel file in SharePoint = always corrupted file

Hi everyone,

 

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:

  1. Multiple SharePoint 'Get Items' queries to get list items.
  2. 'Create CSV table' for each query to format the results.
  3. Create .csv file (works!) and .xlsx file (no luck) populated with the query results.Step1.png

     

    Step2.png

     

1 ACCEPTED SOLUTION

Accepted Solutions
RezaDorrani
Dual Super User II
Dual Super User II

hI @Anonymous 

 

Check this thread

 

https://powerusers.microsoft.com/t5/General-Flow-Discussion/How-to-convert-a-CSV-file-to-Excel/td-p/190817

 

Regards,

Reza Dorrani

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

View solution in original post

1 REPLY 1
RezaDorrani
Dual Super User II
Dual Super User II

hI @Anonymous 

 

Check this thread

 

https://powerusers.microsoft.com/t5/General-Flow-Discussion/How-to-convert-a-CSV-file-to-Excel/td-p/190817

 

Regards,

Reza Dorrani

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

View solution in original post

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

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.

Users online (1,991)