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)

Sort by

Verified answer

DJ_Jamba 2,837 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
lbendlin 8,701 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
ronaldwalcott 3,866 Moderator on at

Like (0)

Report
Copy link

Link copied!

Does this happen in all locales?

Was this reply helpful? Yes No
Loris_Chab 17 on at

Like (0)

Report
Copy link

Link copied!

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,691 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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
Copy link

Link copied!

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 Moderator on at

Like (0)

Report
Copy link

Link copied!

@Loris_Chab

Would you mind marking my answer as verified?

Thanks

d(-_-)b

Was this reply helpful? Yes No