Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
Check out the New Agent Creator Community
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Building Flows / Text saved to String v...
Power Automate - Building Flows
Answered

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

(0) ShareShare
ReportReport
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,

  • martinav Profile Picture
    martinav 3,340 on at
    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!

  • Verified answer
    ck25415 Profile Picture
    ck25415 294 on at
    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,

  • SandyU Profile Picture
    SandyU 225 on at
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities
Check out the New Agent Creator Community

Quick Links

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans