cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Luccif
Regular Visitor

Combobox searchable with sql source

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?

6 REPLIES 6
v-yutliu-msft
Community Support
Community Support

Hi @Luccif ,

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

Just like this:

228000.gif

 

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.

2280001.PNG

 Then you will not meet this problem.

2280002.gif

 

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,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

 

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.

329.PNG

 

320.gif

 

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

 

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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.

Hi @Luccif ,

Like this?

32002.gif

 

Still have no problem...

 

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (3,524)