Filter Choices person column of SharePoint

[RaulSG]

Hello everyone!

I have a person column in a SharePoint list. In a PowerApps, I present into a form this field with:

Items = Choices(SharePointListName.PersonField) and works fine and presents all the users of my tenant.

But I need to filter these choices only for people belonging to a group that I have in a table variable (varGroup) that has 3 users. I put this:

Items = Filter(Choices(SharePointListName.PersonField); Email in varGroup.mail) and don't show anything and don't allow to display the combobox.

How can I do this?

Thank you.

[v-xiaochen-msft · Accepted solution]

Hi @RaulSG ,

According to your description, I've made a test for your reference:

1\ This is my variable ‘Variables’.

2\ Set Items property of combo box control in form to:

ForAll(varGroup,{Claims:"i:0#.f|membership|"&ThisRecord.UserEmail,Email:ThisRecord.UserEmail,Department:"",DisplayName:"",JobTitle:"",Picture:""})

3\ Set other properties of combo box control like picture:

4\ The result is as follows:

// Email1 is a person column.

Best Regards,

Wearsky

If my post helps, then please consider Accept it as the solution to help others. Thanks.

[RaulSG]

Thank you very much @v-xiaochen-msft !

It's a strange way of solving it but it works perfectly. I just need to be able to search by name in the combobox but it works for me.