web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Filter person or Group...
Power Apps
Unanswered

Filter person or Group Column from Sharepoint

(0) ShareShare
ReportReport
Posted on by

i have created gallery from Sharepoint, which contains Person/Group Coloumn which contain user Profile.

Now i want to filter gallery by using dropdown filter.

in Dropdown Item property i added this code : Choices(' Tracker'.Assignedperson)

in Gallery Item property i added this code : 

 

Filter(
'Tracker',
Assignedperson.Email=Dropdown1.Selected.Email)

 

but this not working ,dropdown not expanding to choose value.

any idea how to fix this ?

Categories:
I have the same question (0)
  • Verified answer
    v-yujincui-msft Profile Picture
    on at
    Re: Filter person or Group Column from Sharepoint

    Hi @venky232 ,

     

    Maybe you could try the following formulas:

    Distinct(AddColumns('Tracker'.Assignedperson,"useremail",Assignedperson.Email),useremail)
    Filter('Tracker',Assignedperson.Email=Dropdown1.Selected.Result)

    vyujincuimsft_0-1656920624131.png

     

     

     

    Best Regards,
    Charlie Choi

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 757 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 322 Super User 2025 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 209 Super User 2025 Season 2

Last 30 days Overall leaderboard