cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Patron
Post Patron

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

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,

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Post Patron
Post Patron

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

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,

View solution in original post

3 REPLIES 3
Highlighted
MVP

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

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

Sandy
@SandyU



Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!


Highlighted
Post Patron
Post Patron

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

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,

View solution in original post

Highlighted
Resident Rockstar
Resident Rockstar

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

@ck25415 

 

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

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Upcoming Events

Experience what’s next for Power Automate

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors
Users online (6,754)