Text saved to String variable split into multiple lines and columns when saved to csv format

(0) Share

Report

Posted on by ck25415

294

Hello,

I have a variable(string) that is appended with data from a sharepoint columns and other variables that collect id and different columns information. The output variable is saved to csv and I am having issues when viewing the text from multipline text columns in the csv file. If there is a line space in the text in multiline column the text is split into two rows with an empty row in between and if there is a comma, text followed by it is saved to the next column in csv file. How can avoid this and save the text in a single cell.

I am not using the create csv file action as I need the csv in a certain format I have created the output variable with headers and append the data into it through other variables.

Thnks,

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

SandyU 225 on at

Like (0)

Report
Copy link

Link copied!

Hi @ck25415,

To help in reproducing the issue, would you be able to provide a screenshot of your flow, or at least the part of it that is saving the data to a csv file?

Thanks!

Sandy

Was this reply helpful? Yes No
Verified answer

ck25415 294 on at

Like (1)

Report
Copy link

Link copied!

Hello @SandyU,

Thanks for the reply, I was able to resolve the issue. I used double quotes arround the variable that saves the text so that csv ignore commas and copies the text in a single cell.

Thanks,

Was this reply helpful? Yes No
martinav 3,347 on at

Like (0)

Report
Copy link

Link copied!

@ck25415

I'm curious if you wouldnt mind showing what you did? It might help others to actually see it. Thanks!

Was this reply helpful? Yes No