You’re offline. This is a read only version of the page.
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.
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!
Share
Report
All responses (
Answers (
