How to remove new line when creating a CSV table from a SharePoint List

(0) Share

Report

Posted on by PP-08111920-0

I need help to remove new lines as I am new to power automate.

I am copying a SharePoint List into a CSV table which is then placed into SharePoint folder.

When I open the CSV file, a cell that has return/new lines in the original data, the data is being broken across multiple rows.

This is my workflow that generates the table. I can't find a solution to remove the newlines prior to the CSV file creation. Does anyone have a solution?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

CFernandes 8,402 Most Valuable Professional on at

Like (0)

Report

Hey, You can try the solution/Expression below..

join(split(item()?['Title'], decodeUriComponent('%0D%0A')), ' ')

This function decodes the URI-encoded string %0D%0A, which represents a carriage return and line feed (\r\n). This is typically how line breaks are encoded in URLs or certain contexts. decodeUriComponent('%0D%0A') returns the actual line break characters.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

Was this reply helpful? Yes No
PP-08111920-0 4 on at

Like (0)

Report

I tried your solution join(split(item()?['Title'], decodeUriComponent('%0D%0A')), ' '). The flow is continuing to run when other the branches have completed. I'm not sure why this is happening.

Was this reply helpful? Yes No