Answered

People picker not working in Power Apps form

(2) Share

Report

Posted on by DW-11041600-0

Hey everyone,

I've created a form in Power Apps, to submit data to a SharePoint list. The form passes the submitted data to Power Automate, which then passes the data to the SharePoint list. I've done it this way so the user filling out the form does not need access to the SharePoint list or the site where it is stored.

As a result, the form does not have the SharePoint list configured as a data source. It does have a "Office365Users" data source configured, so that I can use a People Picker.

In the form screen, i have a combo box called "User" configured, and the "Items" property is set to:

Office365Users.SearchUserV2(
{
searchTerm: User.SearchText,
isSearchTermRequired: false
}
)
 
When I test the app as a user, the People picker does not return user name results when data is typed in the field. It also shows a "0" option, that appears as a pulldown (see attached).
 
Can anyone offer guidance on why the People picker shows "0," and how to get it to show users in my org when text is entered?
 

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (2)

DW-11041600-0 18 on at

Like (0)

Report

One followup in case this helps: tried completing the form, and saw this error (id strings changed for security):

Office365Users.SearchUserV2 failed: ("status": "status": "message": "One or more input values is invalid. \rInclientRequestld: 4kjf8wd41-7f18-44d9-9223-f8add83j696d\r|nserviceRequestld: 18e8emns1-59ce-4457-9c53-af49sj3g9d5c", "error": ( "message": "One or more input values is invalid." ), "source": "office365users
eus2.azconn-eus2-003.p.azurewebsites.net" }|

Was this reply helpful? Yes No
Verified answer

DJ_Jamba 2,837 Super User 2025 Season 2 on at

Like (0)

Report
Could you try this with a classic combo control instead?
The modern combo box requires so much extra code to get it to work, it's really not worth it.

1. Add the SharePoint data source you're going to Patch to (we need the person column)

2, Drop a classic combo box onto the canvas

3. Configure the combo box like this:

- Items property:

Choices([@LIST_NAME].'PERSON_COLUMN_NAME')

Where LIST_NAME is the name of your list and PERSON_COLUMN_NAME should be the name of the person column in your list

- Edit the Fields property in the right hand side pane

and configure like this:

Now it will find people in your organisation.

Note you can get the classic combo to look exactly like the modern one.

The control on the left is a classic combo and modern combo is on the right...

Was this reply helpful? Yes No
DW-11041600-0 18 on at

Like (0)

Report

@DJ_Jamba: thanks for the suggestion.

As mentioned in the post, I am intentionally not adding the SharePoint list to my app as a data source, since doing that then requires giving the form submitter access to the SharePoint site and list in order to submit the form, which I don't want to do.

That's why I'm submitting via Power App vis a vis Power Automate. I do have the Office365Users data source configured, and my understanding is that should work.

Was this reply helpful? Yes No
Verified answer

stampcoin 5,058 Super User 2025 Season 2 on at

Like (0)

Report
@DW-11041600-0 Hi,

First thing you might want to check that SearchUser (v2), what it returns.

Then specify the .value.

//need user array, specify property .value not .Value Office365Users.SearchUserV2({searchTerm: ComboBox.SearchText}).value //specify the combox Fields.

the next, you have to specify the Fields, like @DJ_Jamba mentioned.

The default one for me is City ( the first one), of course it won't work unless all users have specified City.

When you specified the correct Fields, it will work for you.

Good luck.

Was this reply helpful? Yes No
DJ_Jamba 2,837 Super User 2025 Season 2 on at

Like (0)

Report

@DW-11041600-0

That is a myth or you don't know enough about how to configure SharePoint.
I configure SharePoint for all of my Power Apps solutions to only allow create, edit, delete & view actions via the Power App or Power Automate only and not in SharePoint.
In other words, my users get access denied if the try to go to the list in SharePoint but can update the list no problem in my Power App.

If you need guidance on how to do this, shout, but it might be better to ask that question in the SharePoint community so that others can benefit from it

Was this reply helpful? Yes No
DW-11041600-0 18 on at

Like (0)

Report

@DJ_Jamba: very possible you're right and I don't know enough about SharePoint.

Before trying the app, I had set it up this way with my SharePoint list configured as a data source, but even after many hours fiddling with SharePoint site and list permissions, the user submitting the Power Apps form could always still pull up the SharePoint list (which they see the URL for in their browser), and see their own submissions.

For my use case, I want the list completely separate from the form, so that users don't even have contribute access directly to the list. I want all list submissions going through the Power App.

On another note: once I used @stampcoin's suggestion for the people picker field, your suggestion for using the old combo box worked great.

Thanks to you both.

Was this reply helpful? Yes No
Suggested answer

ronaldwalcott 3,847 Super User 2025 Season 2 on at

Like (0)

Report

How are you using this

Office365Users.SearchUserV2(

{

searchTerm: User.SearchText,

isSearchTermRequired: false

}

)

Where is User.SearchText coming from?

Do you want to use the name to update a column in the SharePoint list? I don't understand this requirement but

You can use the search user but not in a combo box as you have it declared.

If you just want to find a user name or details about a user you can use a text box and a gallery to display the results.

See PowerApps Search User for some insight on how it can be done,

Was this reply helpful? Yes No
DW-11041600-0 18 on at

Like (0)

Report

@ronaldwalcott the code you're asking about was not working, which is why I posted. When I changed the combo box to a classic one, and added:

Office365Users.SearchUserV2({searchTerm: ComboBox.SearchText}).value

as suggested by @stampcoin, then adjusted the fields as suggested by @DJ Jamba, it started working.

Was this reply helpful? Yes No