Answered

Filter the drop down list based on multi-select column

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi, All.

I have a drop down field in my app that shows the Titles in the SP list. That SP list has also "Team members" Person type column where there could be multiple names. I want the drop down to show only the Titles where the User is listed in that "Team members" column. What would be the filter on my Items property? There are a lot of examples where you compare with one selected name but I can't find a comparison with the multiple selection.

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

LaurensM 12,516 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi @Anonymous, you can filter the dropdown by the current user with the following statement:

Filter(ListName, User().Email in PersonField.Email)

Should the User.Email() not match the mail within the Person field, you could also add the Office365 Users connector and replace User().Email:

Filter(ListName, Office365Users.MyProfileV2().mail in PersonField.Email)

However, the 'in' will make your filter not delegable. Should you have a long list (>500 or >2000 dependent on app settings) or this list will slowly grow to those numbers, I would suggest looking for delegable alternatives.

I recently came across a great article written by @WarrenBelz,. The article mainly tackles multi select combobox filtering but It might also be applicable to this case.

I hope this helps!

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@LaurensM , thank you so much! This works. And my list will not grow over 50 so I think I am ok, although I will look into the alternatives.

Was this reply helpful? Yes No