Answered

CSV_Table line break

(0) Share

Report

Posted on by DC-17061215-0

Hi Everyone,

I'm trying to create an CSV file from my excel file.

All process works fine , I just have that CSV file header is broken as header contains quotation marks and line break.

If I'm using automatic all works fine (CSV file spot on), however I don't need all columns from the file. Once I'm doing custom it does have \n on each header line

My Flow:

How I can remove a new lines from header ?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

Pstork1 69,397 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Since Automatic works for you try using a Data Select to isolate just the columns you want in an array and then use the output of that to create the CSV.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No
DC-17061215-0 6 on at

Like (0)

Report
Copy link

Link copied!

Hi @Pstork1,

Thank you for your answer.

I have tried to isolate needed columns, however CVS still has brake line in the header.

On the select filter it does return with new line indicator for some reason.

Was this reply helpful? Yes No
Pstork1 69,397 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

If its returning with the new line on a Data Select then it must be a new bug that has developed in Power Automate. Based on your screenshot you aren't adding one in the title column of the data select. I would try two things.

1) Try switching back to the legacy editor. This kind of bug is often something that appears only in the new designer. If you go back to the legacy designer and add the Data Select there that may solve the problem.

2) If that doesn't fix the problem then you need to do a Replace() on the first record of the array that comes out of the data select. Here's a blog that discusses how to Replace a linefeed. How to replace new line ('n') in a Power Automate expression

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No
DC-17061215-0 6 on at

Like (0)

Report
Copy link

Link copied!

@Pstork1

Thank you so much for your assistance on this issues.

Switching back to the legacy editor it didn't help.

However, I did go back to "Select" filter and notice that it have "Switch to text mode" that I wasn't aware off.

By switching to text mode I manually modified my mapping by deleting /n from each header line.

And it did resolve the issues.

Was this reply helpful? Yes No