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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Parsing Outputs of a L...
Power Automate
Unanswered

Parsing Outputs of a List Rows

(0) ShareShare
ReportReport
Posted on by 41

Good Day. Thank you for your interest.

 

So the background of the flow is that when an Invoice is created directly based on a Quote and it's associated Quote Product, The Invoice and Invoice Product sub-grid auto populates based on the Products selected during the Quote. The flow is intended to Bypass the Order entity step. We have a custom 'Quote' lookup field on Invoice which also populates the Quote details and products from 'Quote Product' to 'Invoice Product' Subgrid. 

 

Now we want to be able to parse through JSON of the previously configured steps, and send out an email with the Invoice details, and a List of the related Invoice Products. 


The challenge I am running into is that the Invoice Products entity which is being queried by the Parse JSON will have varying number of records depending the number and quantity of products being invoiced. How do I dynamically retrieve the List of products associated with that particular. For example one Invoice may have Two products so that's 2 Invoice Product records, another may have Three products so that's 3 Invoice Products. I'm sure a For loop would somehow be necessary but can't seem to solve the logic. 

 

End Goal: After a new invoice is created and it's products added to the Subgrid, email out a the invoice details (invoice number, date, total amount, etc...) And the List of Products  associated for that Invoice. 

 

Thank You again and Humble Regards,

Sunny

 

Step 1 Invoice.PNGStep 2 Invoice.PNGStep 3 Invoice.PNGStep 4 Invoice.PNGStep 6 Invoice.PNG

Categories:
I have the same question (0)

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 538 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 405 Moderator

#3
abm abm Profile Picture

abm abm 252 Most Valuable Professional

Last 30 days Overall leaderboard