problem with combobox, o365useres and defaultselecteditems

(0) Share

Report

Posted on by nick9one1

281

I have a combobox configured to search o365users so I can search and select people in the organisation. On submission it writes to a single column in SQL.

It works well, apart from the defaultselecteditems property always adds the second account seen above.
It happens if I manually select one or more users, after saving and reopening the form 'exchange online-applicationAcount' has always been tagged on at the end.

I believe it is because I have a ; at the end of the last account when submitted.
in SQL it looks like this

DefaultSelectedItems property

ForAll(
Split(
 Gallery.Selected.ProjectSponsor,
 ";"
 ),
 First(
 Office365Users.SearchUserV2(
 {
 searchTerm: Result,
 top: 1
 }
 ).value
 )
)

and Update

Concat(ComboBox1.SelectedItems, DisplayName & ";")

Does anyone have any suggestions?

Categories:

General Questions

All responses (1)

Answers (1)

Verified answer

RandyHayes 76,287 Super User 2024 Season 1 on at

Like (1)

Report
Re: problem with combobox, o365useres and defaultselecteditems

@nick9one1

Please consider changing your Formula to the following:

ForAll( Filter( Split(Gallery.Selected.ProjectSponsor, ";"), !IsBlank(Result) ), First( Office365Users.SearchUserV2( {searchTerm: Result,top: 1} ).value ) )

I hope this is helpful for you.