web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Urgent Help! Export Ga...
Power Automate
Unanswered

Urgent Help! Export Gallery data to Excel Flow Format Issue! Please help

(0) ShareShare
ReportReport
Posted on by 50

Dear Community,

 

its been a week i am trying to resolve this issue and without any luck. I have a power automate flow, which i am using to export gallery data into CSV file it works fine. file is being downloaded. the only problem is there are multiple columns eg; col1, col2, col3 the issue is when the file is being downloaded instead of being should in seperate columns they are being shown in one single column seperated by a comma like this col1,col2,col3 and same goes for their relevant values. I followed this toturial - https://www.youtube.com/watch?v=WboI7-8vonk in the video the guy does not have the same issue.

 

i have watched the video more than 10 times, and even did the flow again from scratch but still the same issue. in the Select action, in from section i used this expression - json(outputs('Data')) and in the map i used the sharepoint columnname and in the key i used this expression item()?['sharepointcolumnname']?['Value'] I would appericiate if someone could help me as its very important to fix it today.

Categories:
I have the same question (0)
  • SudeepGhatakNZ Profile Picture
    14,394 Most Valuable Professional on at
    Re: Urgent Help! Export Gallery data to Excel Flow Format Issue! Please help

    @cryptosun1 ,

     

    It is common that downloading a CSV file often results in formatting issues. I recommend an alternative approach: instead of downloading the Excel data as a CSV, you can insert the data into a SharePoint list.

    With a SharePoint list, you have the ability to download the list data in Excel format. I hope that helps!

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 462 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 456 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard