web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Take output of Filter ...
Power Automate
Answered

Take output of Filter array to Create an approval

(0) ShareShare
ReportReport
Posted on by 2

Hi,

 

I am a beginner but keen learner at Power Automate and software development in general.

 

I have created a PowerAutomate flow that looks at a data set of 'submitted expenses' and

1. extracts all the 'Staff Names' in the data

2. composes all the distinct 'Staff Name' so each occurs once only

3. Filters the data on each distinct 'Staff Name'

 

Screenshot 2022-08-22 at 19.07.19.png

All is good till here and I can create HTML tables for each 'Staff Name' showing each 'submitted expense' but that is not the requirement here.

 

I want to create an approval for each 'Staff Name'. Currently I can send this from Power Automate but the email appears in HTML. How can I take the output (from the filter) and compose the approval? I understand its Markdown but I need assistance in creating this Markdown from the array output.

 

Thank you.

Categories:
I have the same question (0)
  • Verified answer
    vish3027 Profile Picture
    434 on at

    @DeepDiver After filter array action.Use ParseJSON action and pass output of filter as input to Parse JSON.

    Then You will get each individual value and then you can assign that value in approvals.

     

    You can use Select action after ParseJSON if required.

     

     

    Please accept as a solution if it helps.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 250 Super User 2026 Season 1

#2
Expiscornovus Profile Picture

Expiscornovus 222 Most Valuable Professional

#3
Haque Profile Picture

Haque 174

Last 30 days Overall leaderboard