cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
Community Support
Community Support

Re: Combobox searchable with sql source

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.
Highlighted
Regular Visitor

Re: Combobox searchable with sql source

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

 

Highlighted
Community Support
Community Support

Re: Combobox searchable with sql source

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.
Highlighted
Regular Visitor

Re: Combobox searchable with sql source

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.

Highlighted
Community Support
Community Support

Re: Combobox searchable with sql source

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.
Highlighted
Regular Visitor

Re: Combobox searchable with sql source

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
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Watch Now

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (7,158)