
Announcements
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
Same need here. Something trivial (actually automatic) on Airtable. Please help us build a flow for this.