Power Platform Community Forum Thread Details

Hi, I have the following lists

Locations
Objects (list of users with the refence of the location)
DDI (list of DDIs with the reference of the location)
Associations (list of phone numbers with the reference of DDI and Objects)

in the edit screen of Associations, I would like to show in the lookup field of the users only the ones that didn't get yet a number. This is the actual code that is filtering the active users belonging to the same location of the number that I'm currently editing (based on the DDI list)

Filter(
Choices([@Associations].AssociatedTo),
Value in Filter(
Objects,
Active,
Location.Value = LookUp(
DDI,
ID = DataCardValue2.Selected.Id
).Location.Value
).'Display Name'
)

thank you in advance.

Categories:

Building Power Apps