people picker Office365Users

(1) Share

Report

Posted on by CU19090705-0

Hello,

Can anyone tell me how to retrieve the user-info of any user (not the current user), from Office365Users, based on typed text or TextInput or Combobox or Dropdown?

Basically I would need a people picker from Office365Users.

I tried:

Office365Users.SearchUser({searchTerm: ComboBox.SelectedItems})
 
it gives error:

"This rule creates a circular reference between properties, which is not allowed..."

Thanks in advance!

Categories:

Connectors

Using Apps Using Formulas

General Questions

Mixed Reality

All responses (4)

Answers (0)

Suggested answer

HarminderSethi 6 on at

Like (1)

Report

people picker Office365Users

If you want to create Combobox as people picker then instead of using ComboBox.SelectedItems you should use ComboBox.SearchText because data type of 'ComboBox.SelectedItems' is Table whereas searchTerm takes 'Text' data type so use ComboBox.SearchText

Office365Users.SearchUser({searchTerm: ComboBox.SearchText})

And if you already have Combobox as people picker working (and only one selection is allowed) and you want to get specific property of selected user in the ComboBox then you can use something like

First(ComboBox.SelectedItems).Mail

but if you still have requirement to search the user again then you can do like below

Office365Users.SearchUser({searchTerm:First(ComboBox.SelectedItems).Mail})

which will take first item from the selected items from Combobox and use Mail property of item to search the user.
enriqueglopez 484 Super User 2025 Season 1 on at

Like (1)

Report

people picker Office365Users

CU19090705-0 That columns works exactly as you want, it's basically a People Picker that is already developed.

The People column reads from Azure AD, as Office365Users do.

By the way, if you need to specifically use that connector, follow this tutorial:

PowerApps Office 365 User Search

Also, you could try this in your formula:

Office365Users.SearchUser({searchTerm: Self.SelectedItems})

My recommendation is to use the SharePoint column, you will need less time to make it work.
CU19090705-0 36 on at

Like (1)

Report

people picker Office365Users

Hi enriqueglopez, I need to pickup users from Office365Users, not from SharePoint.

The company's Office365Users, has hundreds of users, and it maintained, and is the one that makes sense to use.

so I just need the right syntax to retrieve the user's info from Office365Users via App.
Suggested answer

enriqueglopez 484 Super User 2025 Season 1 on at

Like (1)

Report
people picker Office365Users

Here is a trick that I usually do in my apps.

First, create a 'Person' type column in your data origin (for example, SharePoint). If you are not using a list in your app, you can create a list/column just for this behaviour.

Then, use this in the Items property of your Combobox.

Choices([@YOUR_LIST].PersonColumn)

You take advantage of the Combobox's own search functionality. I also edit the Fields property and the SearchFields to ["DisplayName"]. You must allow searching.

If my reply helped, please mark it as solution

Have a nice day