Answered

Filter dropdown items

(0) Share

Report

Posted on by ajd116

I have a dropdown where employees can select their name before beginning a training. The names are pulled from a sharepoint list that also has a column with a checkbox for if the employee is an active employee or not. I would like to filter the names that appear in the dropdown box to only show those that have the active employee column selected as a yes.

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

SpongYe 5,715 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi @ajd116

Try this code:
Filter( SPList, ActiveEmployeeColumn = "yes" )
If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

Was this reply helpful? Yes No
Ami K 15,687 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
@ajd116 - you can use:

Filter( 'Your SharePoint List', 'Your Yes/No Column' )

Was this reply helpful? Yes No
Verified answer

Prabhakar_S 735 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi @ajd116 ,

Assuming your SharePoint list is named 'Employees' and the column indicating active status is named 'ActiveEmployee', you can modify the Items property of your dropdown as follows:

Filter(Employees, ActiveEmployee = true).EmployeeNameColumn

Replace 'EmployeeNameColumn' with the actual name of the column that stores employee names.

Filter(Employees, ActiveEmployee = true) - This part filters the records in the 'Employees' list to include only those where the 'ActiveEmployee' column is set to true.

By using this formula, you ensure that only the names of active employees will be displayed in the dropdown. Adjust the column names accordingly based on your SharePoint list structure.

Thanks!!!

Please consider marking my response as the accepted solution if it successfully resolves your concern. If you found the information beneficial in other aspects, kindly express your appreciation by giving it a thumbs-up.

Was this reply helpful? Yes No
ajd116 11 on at

Like (0)

Report
Copy link

Link copied!

I am getting the same list of people with "yes" and "no". I am only getting the list of people that are not active employees.
Filter('Employee Safety Training','ActiveEmployee'= "yes") is what I have but I am getting people who do not have the box selected a yes on my sharepoint list.

I also want the dropdown sorted so it shows them in alphabetical order but when i try and combine the sort/filter I am getting an error. This is what I have for my combination:
Sort(Filter('Employee Safety Training','ActiveEmployee'="yes"),'Employee Safety Training',Title,SortOrder.Ascending)

Thanks for the help.

Was this reply helpful? Yes No
ajd116 11 on at

Like (1)

Report
Copy link

Link copied!

I figured it out, had to use true instead of yes and then when sorting and filtering I didn't need to call out my list a second time so it ended up looking like this:

Sort(Filter('Employee Safety Training','ActiveEmployee'=true),Title,SortOrder.Ascending)

Was this reply helpful? Yes No
SpongYe 5,715 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@ajd116

Nice to see that it worked out.

If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

Was this reply helpful? Yes No
Ami K 15,687 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@ajd116 - there is no need to evaluate a field for true if that field is a Boolean. Simply referencing the field will suffice.

Sort(Filter('Employee Safety Training',ActiveEmployee),Title,SortOrder.Ascending)

Was this reply helpful? Yes No