Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Unanswered

How to parse CSV table output?

(0) ShareShare
ReportReport
Posted on by

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"

 

Whole FlowWhole FlowExpanded Flow 1Expanded Flow 1Expanded Flow 2Expanded Flow 2Expanded Apply to EachExpanded Apply to Each

  • anton-khrit Profile Picture
    197 on at
    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.

  • Community Power Platform Member Profile Picture
    on at
    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.

  • v-zhos-msft Profile Picture
    on at
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,695 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,015 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow