Advanced Filtering on SharePoint List

(1) Share

Report

Posted on by CU09092142-0

Hello,

I created a SP List that is used to track volunteers and activities. I have the rows set up based on the list if activities. The columns in that list are 'Activity' (single line of text column) and 'Email Address' (person or group column). I use the 'Email' column to assign people to the corresponding activity for that row so that column allows for multiple entries.

I am now wanting to build an app that will give the volunteers a more user friendly UI for tracking their activities. I want to be able to filter a drop down list in Power Apps from the email address in the 'Email' (multiple entry enabled) column based on the user who is signed in (User().Email).

Is this possible?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

Michael E. Gernaey 53,974 Moderator on at

Like (3)

Report
Copy link

Link copied!

Hi

Yes here is my sample

I have a sample List, with a Multi-person Column called Project Managers.

I want to filter it by the users log in Email

Thats how

Filter('Sample - Multi-Person Unique Project List', User().Email in 'Project Managers'.Email)

Was this reply helpful? Yes No
Suggested answer

Ravindra Jadhav 342 Moderator on at

Like (1)

Report
Copy link

Link copied!
you can user @FLmike Code to filter on basis of user and for multiple users you can go with this

Filter( SharePointList,PersonTypeCol.Email in combobox.email)

Please Closed the Question, Mark it Solved

If my answer helped resolve your issue, please consider marking it as solved to assist others facing the same problem. Additionally, giving it a like would be greatly appreciated and motivates us to keep helping

Thank You

Ravindra Jadhav

Please Subscribe to https://www.youtube.com/@jadhav_ravi_oo7

Connect On https://www.linkedin.com/in/ravindra-jadhav-powerplatform/

Was this reply helpful? Yes No