Modern Control Combobox | Searching choice-column (people) is limited

(5) Share

Report

Posted on by bpattinaja

Hi, I have an issues with modern controls form and Combobox:

I use a sharepoint list as my datasource named "Register".

There is a column named "Responsible". This is a 'person' choice column, single select. So I can select any user within our organisation.

In my PowerApp I made a (Modern Control) form with the "Responsible" column as one field to fill in.

The Modern Control Form adds a dropdown-field (not a combobox). The results I get are very limited.

So I add in a Modern Control combobox and give it the exact same formulas:

Item = Choices([@Register].Responsible)

DefaultSelectedItems = Parent.Default

Fields = DisplayName

IsSearchable = true

I can now search, but the searchable values are still limited to the same few.

So I add in a (classic? Not the modern one) combobox. Add the same formulas:

DefaultSelectedItems = Parent.Default

Fields = DisplayName

IsSearchable = true

No I can search people from the entire organisation. When I save the form and reopen the item, it'll pop up on both comboboxes and the dropdown. The search cabilities on the modern control is still limited.

Is this a bug? Or am I doing something wrong?

Looking forward to get some responses. Thanks in advance!

(Not posting images due to privacy)

Categories:

Building Power Apps

All responses (10)

Answers (0)

Sort by

bpattinaja 22 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi, Thanks for your rapid response.
Data Row Limit is already set to 2000.
SearchFields does not exist in the modern control combobox, only in the classic combobox.
> When adding the Email-Field, it doesn't change.
PowerApps is up-to-date.

Classic combobox seems the only solution (for now).
bpattinaja 22 on at

Like
a
(1)

Report
Copy link

Link copied!

In addition:
I tried a modern-combobox (which was not connected to the form) with the following 'Items': Office365Users.SearchUser({searchTerm:Self.SearchText, top:999})
I could find all the users, but not be able to select a user..
When selecting a user, it'll just disappear right after.

If I could get this to work, this could be the workarround solution.
Tommy-Upton 119 on at

Like
a
(0)

Report
Copy link

Link copied!

Did you get this to work? I have the same issue...when I choose a person, it just disappears.
bpattinaja 22 on at

Like
a
(1)

Report
Copy link

Link copied!

Unfortunately not.. I am currently using the classic combobox to fix it.

Use the Color.WhiteSmoke for the (background)fills, chevron(background)fillsand selectiontag color. Remove the border. Give it a 32 height and 11 point font in Arial. This makes it fit the rest of the form.
pauldj 150 on at

Like
a
(3)

Report
Copy link

Link copied!

I have this same issue, causing great concern at the lack of ability and support from Microsoft of Modern features not fit for purpose. I have my issue which is pretty much the same on this thread...
https://powerusers.microsoft.com/t5/Building-Power-Apps/Modern-Controls-Form-NOT-looking-up-users-Email-addresses-or/m-p/2525394/emcs_t/S2h8ZW1haWx8dG9waWNfc3Vic2NyaXB0aW9ufExRT1ozM0w3MlU2TTFXfDI1MjUzOTR8U1VCU0NSSVBUSU9OU3xoSw

Still looking for a solution or will escalate to microsoft developers in the new year...
davibern 40 on at

Like
a
(0)

Report
Copy link

Link copied!

I have the same issue with this new control. More info in: Re: Modern Controls Form NOT looking up users (Ema... - Power Platform Community (microsoft.com)
ValeriaBreve 203 on at

Like
a
(0)

Report
Copy link

Link copied!

I do have the same issue today. The classic control is OK if you don't need the "OnChange" property - in my case, I need to collect when the user makes a change to the selection and just the fact of the loading the screen is making the "OnChange" trigger, quick makes it useless.

The modern control is searching the users erratically and also not allowing me to select them consistently (some I can select, sone I don't at all). Even when I get to select them, they disappear shortly after (!!) if they are not part of the first 999 items.
Jonathan Rogers 31 on at

Like
a
(0)

Report
Copy link

Link copied!

I have experienced this same issue and reverted to using the classic combobox control and formatting it to look and feel like the modern one.
Suggested answer

allan_t 310 on at

Like
a
(0)

Report
Copy link

Link copied!

I had the same issue you've described, in the Classic Form control, the Items property was Choices(datasource, column), but it would only display a limited number of users, not the full list. Clearly this was not a useable solution.

I've successfully tested this in my environment and it works. I spent awhile searching forums and AI for answers, none of which worked unfortunately. In the Items property for the combobox datacard in your modern form, set it to Office365Users.SearchUser({searchTerm: Self.SearchText})

This enables the user to search the full list of people and select them.
Suggested answer

FXDWG 2 on at

Like
a
(0)

Report
Copy link

Link copied!

This is an older thread but here is the correct solution... Other than Microsoft making a control for a people-picker field actually work like normal humans outside of Redmond would expect you can just remove the modern combobox field from your data card and replace it with the "Classic" version and wire it back to the data card or...

1. Add the Office365Users connector to your app.

2. Set the "modern" combobox Items property to:

Office365Users.SearchUserV2({searchTerm: Self.SearchText, top: 15}).value (You can change the 15 to however many resulting search items you want displayed.)

3. Make sure the combobox IsSearchable property is set to true

4. Set the combobox SelectMultiple property to true or false depending on your field parameters in SharePoint.

5. If, within your tenant, Parent.Default doesn't display the person value in edit mode properly, change the DefaultSelectedItems property to:

If(
IsBlank(Parent.Default.Email),
Blank(),
Office365Users.SearchUserV2(
{
searchTerm: Parent.Default.Email,
top: 1
}
).value
)

for a single select field or for multi-select:

ForAll(
Parent.Default As locPerson,
First(
Office365Users.SearchUserV2(
{
searchTerm: locPerson.Email,
top: 1
}
).value
)
)

Then, finally 6, in the data card's Update property use this for a single-select field:

With(
{
locUser: DataCardValueXX.Selected
},
If(
IsBlank(locUser.UserPrincipalName),
Blank(),
{
'@odata.type':
"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",

Claims:
"i:0#.f|membership|" &
Lower(locUser.UserPrincipalName),

DisplayName:
locUser.DisplayName,

Email:
Coalesce(
locUser.Mail,
locUser.UserPrincipalName
),

Department:
Coalesce(
locUser.Department,
""
),

JobTitle:
Coalesce(
locUser.JobTitle,
""
),

Picture:
""
}
)
)

Or this for a multi-select field:

ForAll(
DataCardValueXX.SelectedItems As locUser,
{
'@odata.type':
"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",

Claims:
"i:0#.f|membership|" &
Lower(locUser.UserPrincipalName),

DisplayName:
locUser.DisplayName,

Email:
Coalesce(
locUser.Mail,
locUser.UserPrincipalName
),

Department:
Coalesce(
locUser.Department,
""
),

JobTitle:
Coalesce(
locUser.JobTitle,
""
),

Picture:
""
}
)

Replacing the combobox with a classic is probably easier and Microsoft needs to fix it so by default, a people picker field acts like... you know.. a people picker.