Read intersection Table

[Sylv1]

Hi Community!

I created a many to many relationship between a table (Zone) and AAdUsers Table. 

I need, on my Canvas App Onstart, to get all Zones associated with current user and store them in a collection.

how can i read and filter the intersection table ?  

I tried  Filter(Zones, 'AAD Users' = User().FullName})

But with error that  Column is not accessible in the context

Thanks a lot

[MayankP]

HI @Sylv1 ,

Refer to this example article for this scenario..

https://powerapps.microsoft.com/en-us/blog/option-sets-and-many-to-many-relationships-for-canvas-app...

[Sylv1]

Thanks @MayankP 

I've read article. 
Usually that works for many-many relationships. But i do not know why it does not with Aad Users table
I have 2 tables Zones and AadUsers (manytoMany)

- GalleryZones.Selected.AadUsers : OK - works perfectly. Return all users from my zone.
- GalleryUsers.Selected.Zones : NOK - Never return any value (countRows =0). I tried on 2 environments.