Unanswered

Filter dropdown items based on another column's value

(0) Share

Report

Posted on by Steeluser

New to powerapp but I have a sharepoint list with a lookup column to another list. I've also added some additional columns from that list.

I currently have an Employee ID dropdown but I'd like to filter it so it shows only Employees with a Status = "Active"

My current Items code is:

Choices([@'Weld Wire Tracker'].'Employee ID')

I believe I need to wrap that with a filter but nothing I've tried is working. Like this:

Filter(Choices([@'Weld Wire Tracker'].'Employee ID'),'Weld Wire Tracker'.'Employee ID: Status'="Active")

I get the error:

Incompatible types for comparison: These types can be compared: Table, Text

Categories:

Building Power Apps

All responses (5)

Answers (0)

Sort by

WarrenBelz 156,528 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Steeluser ,

Your structure will possibly cause you some grief here and later (Lookup columns are best avoided unless you really need to use them) and the below is not Delegable, but should get you the list you need

AddColumns( Filter( 'Weld Wire Tracker', 'Employee ID:Status'.Value = "Active" ), "EmpID", 'Employee ID'.Value ).EmpID

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps
Steeluser 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for replying but for some reason this code still generates a list of all employee IDs when I run the published app. Within the editor it doesn't generate any items when checking. Maybe I'm missing something.
WarrenBelz 156,528 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Steeluser ,

Does not surprise me actually - it is valid code to Power App but (as I noted) not Delegable. Please consider throwing away that Lookup column - they are not "best friends" with Power Apps at the best of times and "secondary" fields simply are not designed to work in Power Apps like that. It is way better to have "one degree of separation" between your lists.
Steeluser 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Are you saying throw away the Employee ID: Status lookup? How would I go about setting up my lists so that I can have a filtered dropdown of active employees?
WarrenBelz 156,528 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Steeluser ,

Just query the employee list directly in both the dropdown (simply EmployeeListName.FieldName) will get the same as the Lookup and write back to a Text field. Then Lookup the employee list with the item matching your Text field and get the Status

Lookup( EmployeeList, NameField = YourDropdown.Selected.NameField ).Status

which is completely Delegable.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps