web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Filter person or Group...

Power Apps

Answered

Filter person or Group Column from Sharepoint

(0) Share

Report

Report

Posted on by venky232

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:

Building Power Apps

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-yujincui-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @venky232 ,

Maybe you could try the following formulas:

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

Best Regards,
Charlie Choi

Join the conversation