Answered

Filter a customized dropdown based on the employees position (another column)

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi all,

I am stuck currently with a customized dropdown with the name "Responsible Partner", which I would like to be able to filter based on the employeelist which is a SharePoint List with two columns: Name and Position.

I would ideally like to filter so that ONLY people with the position "Partner / Principal" will show up.

Currently I am trying this, but it gives me red scribbles underneath the "=" sign:

Sort(Filter('Employee List SPM'.'Name ({Name})','Employee List SPM'.Position = "Partner / Principal"),Ascending)

Can anyone guide me in the right direction as to what I should do?

This is a customized dropdown (not a combobox). I have done the same thing for a LookUp column combobox, which works with the following Items Property:

Filter(
 Choices('Sales Pipeline Management'.'Responsible Partner / Principal'),
 Value in Filter('Employee List SPM', Position.Value = "Partner / Principal").Name
)

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@Anonymous

Take a look at your syntax for the filter formula you are using.

Try changing to something like this:

SortByColumns( Filter('Employee List SPM', Position = "Partner / Principal" ), 'Name ({Name})', Ascending )

Set the Value to display of the DropDown control to "Name ({Name})".

This should give you the filtered list you are looking for.

I hope this is helpful for you.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@RandyHayes thank you for your comment.

I have tried using your suggested formula, but that gives me even more red scribble
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
@RandyHayes,

I think I have left out some important information:

The "Position" column from the employee-list is a CHOICE-Column. I have tried the following filtering, but I get red scribble under "Value":

Sort( Filter('Employee List SPM'.'Name ({Name})', Value in Filter('Employee List SPM', Position.Value = "Partner / Principal").Name),Ascending )
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous

That formula you have is not going to yield the results you want.

Please have a go with this formula:

SortByColumns( Filter('Employee List SPM', "Partner / Principal" in Position.Value ), 'Name ({Name})', Ascending )

By the way, keep in mind that these type of filters are not delegable (you'll now see a blue scribble). So, if you have a large list, consider you might have issues and need to rethink the strategy.