CODEWITHSUNDEEP
sharepoint-onlinepowerapps
Elina
Elina

Reputation: 139

How to Filter SharePoint Lookup Column using powerapps?

I have a two SharePoint list: List1 and List2 List1 has a Lookup column, its associated with List2.

Ex: List 2 Looks like below

enter image description here

So in List1 Lookup field I need only Test1 In the Dropdown (Where IsAvailable is No only those values I need in the DD) How to apply formula for this in Powerapps?

I was trying formula like below: 

choices(Filter( [@'List1'].LookupField , IsAvailable="No"))

Upvotes: 0

Views: 8890

Answers (3)

P. Desgouilles
P. Desgouilles

Reputation: 1

was able to filter with this :

Filter(
    Choices(List1.Field1),
    Id in Filter(
        List2,
        condition on liste 2
    ).ID
)

Upvotes: 0

Maruthi Kiran
Maruthi Kiran

Reputation: 77

You can use following formula to filter column based on other column :

Filter(Registrations2,Status.Value = "Active").Event

Source List : Registrations2 Choice column : Status Applyed filter on columnc: Event

Hope this works for you.Following is the screenshot for reference. enter image description here

Upvotes: 0

Ansar
Ansar

Reputation: 396

You have to include second list as a data source in order to achieve this

choices(Filter( [@'List2'], IsAvailable="No"))

Upvotes: 0

Related Questions