cancel
Showing results for 
Search instead for 
Did you mean: 

Changing the delimiter in Create CSV

Option to modify the delimiter while creating a CSV file

Status: New
Comments
Advocate II

This is needed.

Frequent Visitor

How is this not a feature yet? How does it only have 8 votes? Is there another Idea I'm not finding?

I've seen lots of threads around asking for this, and another batch of multiple threads just trying to come up with a workaround (mostly unsuccessfully).

 

Please, get this somewhere, this should've been in the Create CSV on launch day.

Advocate II

@nihkel - This is how I worked around it.  It's a bit of hackery using replace functions.
https://powerusers.microsoft.com/t5/Building-Flows/Entire-JSON-Object-to-Single-Cell-in-CSV/m-p/6032...

Frequent Visitor

@rcdf Thanks for the suggestion!

I was thinking o a similar way in order to use ';' as delimiter, but I'll make sure to give your approach a try.

I appreciate the help 🙂

 

New Member

If you intend to do this with the data contained in a SharePoint List, you could :
1) Get your elements with the SP connector;

2) Initialize a string variable with the columns names you would like, e.g. "name;surname;email" and by hitting enter to add a carriage return;

3) Use "Apply to each" on the value element returned by the SP Get elements block;

4) In the apply to each loop, use an "Add to string variable", where the content would be the dynamic fields extracted from SP, separated with ";" and with a carriage return at the end of the line (hit enter)

 

Then you can add your string variable as the content of an attachment for instance.

Hope this helps !

Frequent Visitor

Hi there,

just for future reference in case someone needs it.

 

This was my final approach to this, and it does serve my original purpose of picking the separator I want for the CSV output.

https://powerusers.microsoft.com/t5/Building-Flows/Change-the-delimiter-when-creating-a-CSV-file/m-p...

 

Thank you all for the help and suggestions, you rock!