Combo box is not displaying selected items from the Datasource

(0) Share

Report

Posted on by KennyJ

168

Hi,

I have combo box where users can search for users within the organisation, and can select multiple users. This is then stored in a SharePoint list, where the results are stored as text, separated by a semicolon. However, when i retrieve the record and these values, i don't seem to be able to get the combo box to show the results stored in SharePoint. This is the formula i was using in the DefaultSelectedItems property:

ForAll(
 Split(varCustomerRecord.AccountManagers, ";"), First(Office365Users.SearchUser({searchTerm: Result,top:1})).Mail)

Any ideas why the relevant records are being selected?

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

WarrenBelz 156,774 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @KennyJ ,

Two things - the DefaultSelectedItems need to be a Table, reflecting the field displayed, which I suspect is Mail - you have not posted the Items of the Combo Box, but I assume it is an Office365Users search something like

Office365Users.SearchUser( { SearchTerm: Self.SearchText, Top: 999 } ).Mail

The other issue is why are you bothering to search for a value you already have in the string ? I suspect you are simply after

{ Mail: First( Split( varCustomerRecord.AccountManagers, ";" ) ).Result }

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.

MVP (Business Applications) Visit my blog Practical Power Apps
KennyJ 168 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi, thanks for coming back to me.
I updated the DSI to the above, but it only giving the first item, not everyone.

This is what i have in Items
Office365Users.SearchUser( If( IsBlank(cboAccountManagers.SearchText), {searchTerm: "zzz"}, {searchTerm: cboAccountManagers.SearchText} ) ).Mail

This is why i was originally trying to create the ForAll as i thought i would need to loop through each of the records where there is more than one user selected.

Thanks
Verified answer

WarrenBelz 156,774 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @KennyJ ,

If you want them all, you just need

RenameColumns( Split( varCustomerRecord.AccountManagers, ";" ), "Result", "Mail" )

which will produce a Table with a Mail field matching your selection structure. You also do not need to test for blank SearchText in your Items - it will display all records until you put something in there.

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.

MVP (Business Applications) Visit my blog Practical Power Apps
KennyJ 168 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you, this works.
Much appriciated.