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

Like (0) Share

Report

Posted on 8 Nov 2024 19:38:08 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:

Business Process Flows

All responses (2)

Answers (0)

PP-08111920-0 4 on 11 Nov 2024 at 15:43:11

Like (0)

Report

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

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.
CFernandes 8,285 Most Valuable Professional on 09 Nov 2024 at 17:14:23

Like (0)

Report

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

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.