News and Announcements icon

Power Platform CommunityForums Power Automate - Building Flows Parsing CSV with new l...

Power Automate - Building Flows

Unanswered

Parsing CSV with new line as entry

(0) Share

Report

Report

Posted on by gabegap

88

Hi all,

I'm working on a project that processes surveys from our dept from a CSV file we get weekly. I followed this guide to the T How To Parse any CSV to JSON Array - DamoBird365 and it works very well except for one thing, returns.

Some people like to have a return in their comments such as

"This person was great.

Thanks Company!"

this breaks the script and locates things in places where they shouldn't be.

The thing I could use as a "delimiter" of some sort is the double quotes because those are there but I am just a bit confused on how I would go about doing that.

What are your thoughts.

All responses Img

All responses (1)

Answers Img

Answers (0)

grantjenkins 11,059 Super User 2025 Season 1 on at

Like (0)

Report

Re: Parsing CSV with new line as entry

Have a look at my solution using the link below were you can use Office Scripts to extract the JSON data from a CSV file. I'm pretty sure it will handle this scenario.

https://powerusers.microsoft.com/t5/Building-Flows/CSV-file-to-SharePoint-List-Best-Way-to-Do-This/m-p/2498567/highlight/true#M279382

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 497 Super User 2025 Season 1

#2

David_MA 436 Super User 2025 Season 1

#3

Riyaz_riz11 244 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans