News and Announcements icon

Power Platform CommunityForums Power Automate - Building Flows Nested Lookup for Shar...

Power Automate - Building Flows

Unanswered

Nested Lookup for SharePoint Lists - getting data from 2 different nested lists into 3rd one

(0) Share

Report

Report

Posted on by jakalion

8

I have Table1 as main list (parent) and Table 2 uses column City as Lookup (table1) to get more fields like State & Country.

Table 3 looks up "School" from Table 2 but I also need the City, State and Country to be visible in this list.

SharePoint list cannot go to nested level lookups in the default setup. Any experts of PowerAutomate who have tried this and made it work ?

-Table 3 should get the values from Table 1 whenever the Table 3 list item is changed or created.

All responses Img

All responses (4)

Answers Img

Answers (0)

DavidSack 4 on at

Like (0)

Report

Re: Nested Lookup for SharePoint Lists - getting data from 2 different nested lists into 3rd one

Sorry, wrong link: https://learn.microsoft.com/en-us/microsoft-365/community/working-with-cascading-lists-in-sharepoint-and-powerapps
DavidSack 4 on at

Like (0)

Report

Re: Nested Lookup for SharePoint Lists - getting data from 2 different nested lists into 3rd one

Will this work?

https://powerusers.microsoft.com/t5/Building-Flows/Nested-Lookup-for-SharePoint-Lists-getting-data-from-2-different/td-p/1668985
jakalion 8 on at

Like (0)

Report

Re: Nested Lookup for SharePoint Lists - getting data from 2 different nested lists into 3rd one

@jimi_hendrix - Nopes, still stuck
jimi_hendrix on at

Like (0)

Report

Re: Nested Lookup for SharePoint Lists - getting data from 2 different nested lists into 3rd one

@jakalion Did you ever get this to work???

Helpful resources

News and Announcements

Upwork and Microsoft Power Platform Partnership

Welcome to the Power Platform Communities

Check out the New Agent Creator Community

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 566 Super User 2025 Season 1

#2

David_MA 516 Super User 2025 Season 1

#3

stampcoin 492

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans