web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Filter from a gallery ...

Power Apps

Suggested Answer

Filter from a gallery using dropdown and choices

(0) Share

Report

Report

Posted on by JM-14081323-0

174

Hello,

please help me with filtering from my gallery by a dropdown where there are departments of employees. These departments I am using are in "choices" of the column Departments. Can it be done?

This is in dropdown items

Choices('Department (EmployeesList)')

This I tried for the gallery

Filter( EmployeesList; Department = dropDepartment.Selected.Result)

Dropdown shows the choices (MAN+, MAN-, etc.) alright, but the gallery is not working

Thanks

I also used a searching field within the gallery, hope it will be alright to combine

Search( Sort( Sort(EmployeesList;Name ); ID ); searchEmployeesList.Text; Name )

Categories:

Building Power Apps

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

ronaldwalcott 3,914 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
You can get the items for the combobox using something like

Distinct('Job Descriptions',Department)

and the filter would become something like

Filter( 'Job Descriptions', Department = ComboboxCanvas1.Selected.Value)

You can then add a Sort

Join the conversation