cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

How to parse CSV table output?

Here is my Flow. After generating the CSV table. I would want to parse it and use its fields as variables on my "Apply to each"

 

flow of to csv table.pngWhole Flowto csv table 1.pngExpanded Flow 1to csv table 2.pngExpanded Flow 2csv table apply to each.pngExpanded Apply to Each

3 REPLIES 3
v-zhos-msft
Level 10

Re: How to parse CSV table output?

Hi @Anonymous ,

As the pic shown, the csv data is come from 'user' of the 'Parse items'.

So you can use the body of 'Parse items' as source in the apply to each, then you can get the dynamic content of 'user'.

Best Regards,

Community Support Team _ Zhongys

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous
Not applicable

Re: How to parse CSV table output?

Hi @v-zhos-msft,

 

My current process is already getting the parsed items from the body.

My goal was to have the csv table as source so the API will get data on the csv table source instead of getting data from the parsed items. Is that possible? Thank you.

Super User
Super User

Re: How to parse CSV table output?

You can use Parse CSV action from Plumsail Documents connector. It allows you to convert CSV into an array and variables for each column. Please read this article demonstrating how it works.

 

Then you can iterate through the result array and read all values as you need.

Helpful resources

Announcements
firstImage

Power Platform Online Conference

Speakers, submit your sessions now! Call for speakers ends Feb. 10!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (2,992)