Seeking Assistance: Overcoming Limitations with Person Column in Power Apps and SharePoint Integration

[PowerFlames]

Dear Power Apps community,

I'm seeking assistance from fellow Power Apps users to help me address a pressing issue. I've developed a Power Apps canvas that is linked to my SharePoint list. Within this SharePoint list, there is a person column named "Paid By," intended for selecting Office 365 users within my organization. However, I've encountered a limitation where only 20 users can be selected. When attempting to search for the names of some colleagues, no results are returned. My goal is to be able to retrieve any user within my organization when conducting a search.

Attached is my modern form control, which includes data cards for the person column (combo box). Below are the codes for my comboBox field properties:

• Item: Choices([@SPlist].'Paid By')
• DefaultSelectedItems: Parent.Default
• Approver and 2nd Approver is also the same. 

Your support and insights on overcoming this challenge would be greatly appreciated.

Thank you,
Nor

[ANB]

Hi @PowerFlames, If you can change the items property of combo box to 

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

then this can help you to get the users.

-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

Please click Accept as solution ✅ if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.👍

Thanks,
ANB

[PowerFlames]

Hello @ANB ,

I appreciate your efforts. However, the proposed solution only displays all search results, addressing part of the issue. When attempting to select a user after conducting a search, the input field does not get updated; it remains empty. I have also attempted to add fewer filters to refine the search, and while it works, the user is still unable to select and update the input field.

Filter(
    Office365Users.SearchUserV2({
        searchTerm: Trim(Self.SearchText),
        isSearchTermRequired: false
    }).value,
    AccountEnabled = true && Not("EXT" in UserPrincipalName),
    Country = "Somalia"
)

[ANB]

@PowerFlames : Apologies! I didnt get this new issue. What do you mean by input field does not get updated? Please elaborate with some screenshots because I cannot see your screen.

Thanks,

ANB

[PowerFlames]

@ANB Sure, first the input field is a dropdown automatically created within my modern form control connected to my SharePoint list. so when i search a user it gives the result as a dropdown, then if i select it's not captured in the input field, as you can see the Paid by field is empty not like the approver and 2nd approver fields. 

[ANB]

@PowerFlames Can you confirm that your combo box Layout has this :

Thanks,

ANB

[PowerFlames]

@ANB apologies i mistakenly accepted as a solution. 
but here are the field of my combo box, it's different from the one you provided,

[ANB]

@PowerFlames I over looked your first main question. You are using modern form. And my screenshot is classic combo box. Select these 2 value:

-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

Please click Accept as solution ✅ if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.👍

Thanks,
ANB

[PowerFlames]

@ANB Issue still exists. if i click the drop down with searching any names i can see a whole list if i select any user from the suggested list it works just fine, but when i search a user and i select it disappears and the field is empty. to review again here are my property codes. 
Item: 

Filter(
    Office365Users.SearchUserV2(
        {
            searchTerm: Trim(Self.SearchText),
            isSearchTermRequired: false
        }
    ).value,
    AccountEnabled = true && Not("EXT" in UserPrincipalName),
    Country = "Somalia"
)

DefaultSelectedItems: ThisItem.'Paid by'

[ANB · Accepted solution]

Hi @PowerFlames, Apologies for late reply. This should work properly. I just tried at my end. Last suggestion. Use this on DefaultSelectedItems 

Office365Users.SearchUser({searchTerm: ThisItem.'Paid by'.Email})

-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

Please click Accept as solution ✅ if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.👍

Thanks,
ANB