Showing results for 
Search instead for 
Did you mean: 
Post Patron
Post Patron

get items from parent-child list with flow



I am trying to retrieve data from SharePoint Lists with 'get items'

I have 4 lists. Parent , child, grandchild1 , grandchild2.

child list and grandchildren have a lookup field  to the Parent list.

in the child list i have a field with 3 choices. Signature/Review/Approval

When a file is created in the grandchild list:


in the get items query i filter by the Lookup Field that connects all lists


Then i use a condition in order to get the type of action


In the grandchild1 list i have a person/group field and i want to retrieve it in order to send an email for review.

Flow runs successfully, but does not access any fields of the grand child lists. I tried the other way around (item created in the  child list). Any idea how to process with that?



Post Patron
Post Patron

Perhaps this will help.

When i click an add button in my App, i Patch the data (including ID,RequestID) in the child list. Then i click Save to Patch the data in the grandchild list.

I m not sure i am using the correct trigger, should i add a boolean action?

Helpful resources

Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Users online (25,713)