web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Filter using a SharePo...

Power Apps

Unanswered

Filter using a SharePoint list Person field

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Hello, I created a SharePoint list with 2 columns, a title column and a person column. The person column allow multiple users in the same row.

In my app, I want to filter this list in a ComboBox, I want that the comboBox shows only the 'titles" that have the current user in the person field.

I use a code like this, but it is not working:

Filter(MyList; User().Email in Person.Email), where "person" is the 2 Column of my list.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!
@Anonymous

Your code does work. I have recreated your SharePoint list and used exactly the same code you provided.

What specifically is not working for you? Make sure you remembered to use this code in the both the DisplayFields and SearchFields properties of the ComboBox.

["Title"]

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No

Join the conversation