Answered

How to filter items in a dropdown based of the Yes/No field in the SPList

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi everyone, I'm trying to filter dropdown items based on Yes/No field from the SPList, if the field is false then the item should not be available in the dropdown selection choices.
For instance, let's assume I've got a list of user with Title as a user name and Active(Yes/No) to show where the user is still active or not. The idea here is that when the user is not active, he shouldn't be shown in the dropdown for task assignment.

Any idea as to how to go about this?

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

AshwiniBhandari 97 on at

Like
a
(1)

Report
Copy link

Link copied!

Try adding the below filter to your items property of dropdown:

Filter(AddColumns(UsersList,"hideDropDownValue",Active),hideDropDownValue).Title

The above filter will show all users who are active in the list. Active = Yes

If you want to show non-active one's try the below filter:
Filter(AddColumns(UsersList,"hideDropDownValue",Active),!hideDropDownValue).Title

See the attachments for results.

- - - - - - - - - - - - -
If you like this post, give a Thumbs up. If it solved your request, Mark it as a Solution to enable other users find it.
rubin_boer 4,843 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

hi @Anonymous you use a filter, combobox Item = Filter(yourSPList,YourSharePointColumnName)
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Solved😊. Thanks!!