Modern Controls - people picker

[nic182]

Hi,

I have a Power App form which populates a Share Point list.

I need a field that searches for the 'Key contact' for a request. (This isn't necessarily the person typing the request)

I have added a Modern Control drop down list and completed all the steps like I have successfully done using the Classic controls. However all I get are numbers - and it's not searchable.

Any help please? 

[v-qiaqi-msft]

Hi @nic182,

Please edit the fields as below:

What's more, search feature is not available for modern controls, I strongly suggets you use the Office365User() function to get all your users.

Office365Users.SearchUser({searchTerm:"",top:999})

[nic182]

Thanks Qi! So I did that and now it displays a drop down list of names. Unsearchable like you said.

I'm sure this is probably basic - but where do I put the formula in, the Office365User() function you mentioned. And I don't know what to put in the 

({searchTerm:"",top:999})

[v-qiaqi-msft · Accepted solution]

Hi @nic182 ,

In this scenario, put nothing.

I have mentioned that this formula will display all the users in your organization at max of 999, just test it on your side.

Office365Users.SearchUser({searchTerm:"",top:999})

[samfawzi_acml]

To integrate with SharePoint's People Column, slight modifications are necessary. Start by collecting user data with Office365Users.SearchUser. Then, enhance this list by adding a "Claims" column and selectively displaying desired attributes. The final step involves renaming the "Mail" column to "Email" for compatibility. This prepared collection can then be utilized as a data source in a modern dropdown. This approach facilitates smooth integration with SharePoint's People Column, ensuring user data is appropriately formatted and accessible.

ClearCollect(UsersList,Office365Users.SearchUser({searchTerm:"",top:999}));

ClearCollect(FinalUsersList,RenameColumns(ShowColumns(AddColumns(UsersList,"Claims","i:0#.f|membership|"&ThisRecord.Mail),"Claims","Department","DisplayName","JobTitle","Mail"),"Mail","Email"))

then you can use the last collection as a data source for the modern dropdown.

[pauldj]

But even if this fixed the issue (and it doesn't) this only shows upto the top 999 people - what about the others...?

[samfawzi_acml]

To address the limitation of a 999-item cap, consider adopting an alternative strategy by utilizing a modern combo box instead of a dropdown. For setting the item values, you can use the following approach with the Office365Users connector to dynamically search and filter users:

Office365Users.SearchUser({
searchTerm: ComboboxCanvas1.SearchText,
top: 50,
isSearchTermRequired: false
})

Configure the combo box to display the following user fields:

1. Display Name
2. Mail

Implement an onChange event script to update the selected employee's information. You can use the following code snippet to set the EmpObject with the necessary details, ensuring seamless integration:

Set(EmpObject, { '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", Claims: "i:0#.f|membership|" & Employee.Selected.Mail, Department: "", DisplayName: Employee.Selected.DisplayName, Email: Employee.Selected.Mail, JobTitle: "", Picture: "" } )

This method enhances flexibility and user experience by allowing dynamic searches and selections beyond the standard item limit, ensuring that you can efficiently manage and reference a large number of users within your application.

[phildetwei]

Or you can simply use a "classic" combobox control. Just did a side-by-side comparison with the modern vs. the classic with the exact same "Items" property in both (the default like this: Choices([@Administrators].Administrator) ).

Classic works fine, returns any name in our 50K organization. Modern (which evidently means, "lame") does not return most people and is useless.

Nice work Microsoft... introduce a "modern' version of an existing feature that straight-up DOES NOT WORK... lmao

[Rosie]

See the video from Reza Dorrani.

https://www.youtube.com/watch?v=uNSOqgxwZds

At 17mins in he shows how use the classic datacard for email/person picker - essentially copy the classic datacardvalue control and paste it into the Modern Forms Datacard and delete the original modern datacardvalue.

Gold!

[rontan09]

Did this method work? I tested but not working. Able to get search result but not able to select the record as the app doesn't allow. Kinda buggy since sometimes able to select but most of the time not. 

But when I test, searching & selecting in the Modern Control Combobox using a Collection works fine but only limited to 999 records.