web

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

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

Power Apps - Building 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 ?

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