
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'
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.
@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.