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 / Reverse lookup of list...
Power Automate
Unanswered

Reverse lookup of lists relations

(1) ShareShare
ReportReport
Posted on by 2

Hi there,

the guys at MSFT Community directed my towards Automate as my goal seems not to be achievable out of the box by SharePoint / Microsoft Lists.

 

Situation

We have a SourceList and a TargetList.

SourceList has a multi-value (non-unique) lookup column that references to items of TargetList.

That all works all fine.

 

Goal

I want to have a "reverse" lookup of all lookup referencing to an item in TargetList, when looking at TargetList.

So assuming SourceList(1) points to TargetList(A) and SourceList(2) points to TargetList(A) as well.

When navigating into TargetList I want to see at TargetList(A) a column with "SourceList(1), SourceList(2)" in best-case as a link in the way as the lookup works on the SourceList items.

 

I worked with automate already, but somehow don't have a clue how to achieve that if the data model of lists is just not offering this?

 

thanks a lot,

Matthias

Categories:
I have the same question (0)
  • LFSchmidt Profile Picture
    5 on at

    Same need here. Something trivial (actually automatic) on Airtable. Please help us build a flow for this.

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…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 398 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 323 Super User 2025 Season 2

#3
Expiscornovus Profile Picture

Expiscornovus 183 Most Valuable Professional

Last 30 days Overall leaderboard