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
firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

Join the new Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (7,123)