cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
R4ymondJ
New Member

Problem with line break when creating csv table

I am new to Power Automate and I have a problem that I have not been able to solve.

 

When getting data to create a csv table, one of the data is a paragraph, if the paragraph has a line break an additional line is created in the csv file. I need is that the whole paragraph is in the same line.

 

How can I prepare the data so that this line break is not created?

 

Captura.PNG

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

With the first answer I didn't have a solution. So I had to combine the first suggestion with the second. Many thanks to users for their help.

View solution in original post

6 REPLIES 6
Amanthaper
Responsive Resident
Responsive Resident

Hello @R4ymondJ 

Try using the the "HTML to text" action. It translates escape sequence to plain text (using http).

Example.

PAUG_escapesequencetotext.png

The variable in my example is optional. You can directly reference the H2T action's output in your flow.

PS, use the H2T action in default HTML view (not code view).

Give this a shot - hope it helps,

Aman

------------------------------------------------------------------------------------------------------
If my post helps you with your problem or answers your question, please mark it Solved or Answered. This helps anyone with similar challenges. If you like my response, please give it a Thumbs Up.
------------------------------------------------------------------------------------------------------

Paulie78
Super User
Super User

You could simply replace the \r\n with nothing using compose step before the create CSV step which would remove the line breaks completely. But it depends if you need to retain the record of them in the resulting CSV. 

 

What is the destination for the CSV? Excel?

v-alzhan-msft
Community Support
Community Support

Hi @R4ymondJ ,

 

Have your issue been solved according to @Amanthaper  'solution?

If yes, please go ahead and mark the post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!

 

Best Regards,

Alice

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

With the first answer I didn't have a solution. So I had to combine the first suggestion with the second. Many thanks to users for their help.

I actually found another much cleaner way of doing it since then, based off another question someone else asked today.

which way?

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Top Solution Authors
Top Kudoed Authors
Users online (1,180)