Power Platform Community Forum Thread Details

Hello,

Could you help me with this trouble :

I use 2 sharepoint lists :

- MyLocalCompanyUsers witch contains several added data (like personnal city location, actual project...)

In this list there is a field "Person", typed Person, witch contains one person from Office 365 Users (Claims, Email...)

This list is very use-full to do dropdown with only people of our local company and not from all the company (> 10 000 users)

- Projets

In this list there is a field "Affected", typed Person, witch contains several persons from Office 365 Users

I would like to enable an user to modify the field "Affected" in a PowerApps application.

For that, I created a Combobox with :

- Items : 'Utilisateursd''Office365'.SearchUser({}) -> all the user of Office 365 Users

- DefautSelectedItems : ProjectsComboBox.Selected.Affected-> ProjectsComboBox is a combobox to select the projet (that works)

- searchable : true

I but, I don't find how to limit the search to people who are in my the field Person of one reccord of my list MyLocalCompanyUsers.

An idea ?

Thanks a lot for your help,

Categories:

Filter Office 365 users with a list