Urgent Help! Export Gallery data into Excel CSV flow Issue!

[cryptosun1]

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.

here is the screenshot how data is being shown in excel file.

and here is the flow i created

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.

[dvo_]

Have you check if the regional settings are ok? I mean, if for any reason you change the regional settings of excel to other country you can face some issue due to the separator can be different.

[cryptosun1]

i did not change anything.

[dvo_]

Hi, try this:

1. Open your csv document with the notepad

2. Write, before your data*--> sep=,

*I think you are using , as the separator item.

3. Open your csv with excel and check if it is ok.

If it works, I think the issue is related with a different regional settings between Power Automate and excel. I had the same issue. 

[cryptosun1]

So after i changed it to the notepad view, i can see the data like this

so as per you i should put sep=, ? i did this and saved it and then changed the file format to excel to check and it shows like this

which is not correct 😞