web

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

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

Power Apps

Unanswered

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

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-yujincui-msft on at

Like (0)

Report
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)

Best Regards,
Charlie Choi

Was this reply helpful? Yes No

Join the conversation