Combobox searchable with sql source

[Luccif]

Hello, using a simple combobox with search, multiple selection and sql server data source, I encounter in a problem, to follow the steps to replicate it:

- I'm looking for an item in the list

- I select the first of the filtered list based on the search (it is added to the selectedItems)

- I'm looking for another item, the first of the list is already selected (even if different from the first, see attachment)

- if I click on the selected item, the previous selection disappears (it is removed from the selectedItems)

The same error is not present using Office365 source.

There is a solution or woraround?

[v-yutliu-msft]

Hi @Luccif ,

Do mean that if you choose another selection in your combo box, the first selected item will disappear?

Just like this:

If so, I do not think this is related to what data source that you use.

That should be about your combo box's settings.

Please turn "allow multiple selection" on.

 Then you will not meet this problem.

If the problem still exists, please show me:

1)all your settings of your combo box

2)the sql field's data type that you use in the combo box

3)the formula that you used when using Office365 connector

Best regards,

[Luccif]

Hi @v-yutliu-msft 

It is not a setting problem, in attachment my combobox property.

The combobox seems to work normally with Office365 and other source. I use in Items for Office365 : UtentidiOffice365.SearchUser({searchTerm:""})

As you can see from the attachment shared with the first post,
I searched and selected CANGY (which was the first in the initial list), then I look for GAUDIO which is already selected (blue text) being the first result of the search. And this applies to any other search (the first one remains selected). By clicking on GAUDIO, CANGY in the selected ones is removed.

The problem is in the position of the selected if I do a search and select the 3rd, on the new search the 3rd element will always be marked in the list as selected (even if different from the one actually selected and present in SelectedItem) and at the click it re-removes the one correctly selected instead of adding to the SelectedItems

[v-yutliu-msft]

Hi @Luccif ,

Do you mean that your combo box only not worked good when connected with sql server?

Could you show me the combo box's settings when you connected with sql server?

I've made a similar test and not met this kind of problem.

In my test, I connect with Sql server and my combo box's data source is the sql table.

I suggest you update your gateway and sql.

Clean your browser's cache , update it to the latest version.

Or try other browsers to try again.

Best regards,

Phoebe

[Luccif]

Hi @v-yutliu-msft, the connection is like yours, table on sql server (Azure).

I tried on other browsers in incognito navigation, but it remains.

In the example you show, a passage is missing. after selected, perform a search.

[v-yutliu-msft]

Hi @Luccif ,

Like this?

Still have no problem...

Best regards,

[Luccif]

Hi @v-yutliu-msft,

I tried to create a new DB, open the app on another browser and update the connection. Created a new app with the component

I don't have a gateway. Use of direct connection (cloud services). Do you think it's related to that?

thanks for the support you are giving me