Answered

Filtering a dropdown from a Lookup table

(0) Share

Report

Posted on by altyrocks

Hello,

I have a SharePoint list called Customer that has a Vendor field. This Vendor field is of type Lookup and pulls its data from another SharePoint list called Vendor List. Currently, I have the Vendor field tied to a dropdown in PowerApps and it works as expected.

Choices([@'Customer'].Vendor)

What I'm being asked to do is filter the vendors based on whether they are active or not. The Vendor List table consists of a Title (vendor name) and an Active field (Yes, No). I have added the Vendor List as a data source to my PowerApps form.

Filter(
Choices([@'Customer'].Vendor),
Value in Filter([@'Vendor List'], Active = true)

This code does not work. What am I missing?

Thanks!

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @altyrocks ,
As your column type of Vendor column is lookup you can directly refer the values from Vendor list.
Distinct(Filter('Vendor List', Active = true),Title)
Assuming value of Vendor is stored in Title column of Vendor List
Verified answer

v-chengfen-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @altyrocks ,
Here is a test for your reference:
Here is list:

Here is test:

Best Regards
Cheng Feng
altyrocks 27 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you so much! I appreciate you recreating this for me.