Notifications
Announcements
No record found.
Hi there,
we have a contact subgrid on opportunity form and we need to retrieve the data in the subgrid in a microsoft flow. is there a way to get the data saved in the subgrid?
Please suggest.
Thanks,
Venu
Yes, you should be able to, assuming this is a standard 1:N from Opportunity to Contact.
You'd need to create a query within a List Records action to pull that data back. So:
(1) Perhaps trigger the flow on a button push on the Opportunity subgrid? (No way I can think of for Flow to know you have a new contact added to that subgrid.)
(2) Use the OpportunityID as the key to a query that finds all contacts linked to that ID.
(3) Loop through the List Records result, and do what you need to do...
HTH,
Dave
President, Visionary Software
http://crm-rules.com
Hi.
You can use a list record flow step to retrieve the list of contacts. I'm assuming with the subgrid on Opportunity. You have a lookup field on contacts linking to the primary opportunity.
See below screenshot. You'd replace new_opportunitylookupfield with your lookup field's logical name and after the eq you'll need to add in the value of the related opportunity ID.
new_opportunitylookupfield eq '@{triggerBody()?['contactid']}'
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Tom_Gioielli 70 Super User 2025 Season 2
Gerardo RenterÃa Ga... 43 Most Valuable Professional
Daniyal Khaleel 32 Most Valuable Professional
