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

export to csv data seperator

Hi all, 

 

I want to create a csv file based on the operator "Create a csv". 

 

Heres a Picture of my flow:

ittruck_0-1637833575209.png

 

My problem is, that the data in the csv is seperated by "," but my excel needs ";" to seperate the data into columns.

I guess this problem appears because of my regional settings.

 

Is there a solution or workarround for me?

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Expiscornovus
Super User
Super User

Hi @Anonymous,

 

I have seen a workaround with a replace function. The , delimiter is first replaced by a unique character which isn't used in the content of the csv file. That new character is replaced by a ; character. 

 

That approach can be found in this thread:

https://powerusers.microsoft.com/t5/Building-Flows/Entire-JSON-Object-to-Single-Cell-in-CSV/m-p/603274#M79677

 



Happy to help out! 🙂

Interested in more #PowerAutomate #SharePointOnline or #PowerVirtualAgents content?
Visit my blog, Subscribe to my YouTube channel or Follow me on Twitter


View solution in original post

2 REPLIES 2
Expiscornovus
Super User
Super User

Hi @Anonymous,

 

I have seen a workaround with a replace function. The , delimiter is first replaced by a unique character which isn't used in the content of the csv file. That new character is replaced by a ; character. 

 

That approach can be found in this thread:

https://powerusers.microsoft.com/t5/Building-Flows/Entire-JSON-Object-to-Single-Cell-in-CSV/m-p/603274#M79677

 



Happy to help out! 🙂

Interested in more #PowerAutomate #SharePointOnline or #PowerVirtualAgents content?
Visit my blog, Subscribe to my YouTube channel or Follow me on Twitter


Anonymous
Not applicable

Thanks @Expiscornovus, this really helped me finding a solution

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (1,617)