Answered

CSV Header contains quotation marks and line breaks

(2) Share

Report

Posted on by Loris_Chab

Hello,

I need your help to understand why the header of my CSV file is broken.
It contains quotation marks and line breaks, which makes it unreadable.
This isn't the first time I've used this function in Power Automate, but it's the first time I've gotten a result like this.

Below is the step in question and the result it produces.

Thank you for your help,
Loris

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (2)

Verified answer

DJ_Jamba 2,837 Super User 2025 Season 2 on at

Like (0)

Report

As a test, switch the designer to the classic interface and run the flow again

Was this reply helpful? Yes No
lbendlin 8,479 Super User 2025 Season 2 on at

Like (0)

Report

yeap, A @DJ_Jamba mentioned. Known bug in the new designer. Switch to the old designer.

Was this reply helpful? Yes No
ronaldwalcott 3,847 Super User 2025 Season 2 on at

Like (0)

Report

Does this happen in all locales?

Was this reply helpful? Yes No
Loris_Chab 17 on at

Like (0)

Report

Hi,

@lbendlin @DJ_Jamba Thanks for the suggestion, tried it but same result with the classic designer :/

@ronaldwalcott Haven't test it yet in an other locales, i'll try it, thank you.

Was this reply helpful? Yes No
Verified answer

Chriddle 8,443 Super User 2025 Season 2 on at

Like (0)

Report

This happen because you input data already contains line breaks:

Remove them before creating the CSV.

Was this reply helpful? Yes No
Loris_Chab 17 on at

Like (0)

Report

Hi @Chriddle,

Thanks for your feedback, but no, they don't. What you're highlighting here is the header of my columns, which I manually define in the step. They don’t contain any spaces or line breaks.

So yes, it’s strange that Power Automate’s code view detects some — I don’t see how I could remove them.

Was this reply helpful? Yes No
Suggested answer

Loris_Chab 17 on at

Like (0)

Report

My bad, you were all right.
Thanks to the classic designer, I managed to remove the line breaks it had added automatically, even though it wasn’t showing them

Thanks you all

Was this reply helpful? Yes No
DJ_Jamba 2,837 Super User 2025 Season 2 on at

Like (0)

Report

@Loris_Chab

Would you mind marking my answer as verified?

Thanks

d(-_-)b

Was this reply helpful? Yes No