cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TomasZubov
Resolver I
Resolver I

Multiple search fields - Combo Box issue

I have some problems to use multiple search fields in my app

  1. I have SQL as datasource
  2. two comboboxes using the same datasource (dbo.companies)
  3. Comboboxes are on the same screen

The purpose of the first is to find supplier using name or VAT, second is to fill in counterpart, so the customer, again using name or VAT. 

 

A) It works only in the first combobox, but both are exactly the same and in both is SearchFields value set to:

["Name"; "VAT"]

 Is this known behaviour?

 

B) It is being reset to one searchfield every time I open web editor . 

  1. I change the value to one mentioned above
  2. I save it 
  3. I publish the version - two search fieds do work in published app (at least the first one) 
  4. I open editor and the values are immediately reset to one search field only  

Any clue why is this happening?

 

9 REPLIES 9
v-monli-msft
Community Support
Community Support

Hi @TomasZubov,

 

What is the formula that you used on the Items property of combo box? Also, explain the related data types. Notice the formula in SearchFields shoud be:

["Name", "VAT"]

 

 

Also take a screenshot of below settings:

Capture.PNG

 

Regards,

Mona

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

Hello @v-monli-msft,

 

Problem is that Microsoft decided long time ago, for some weird reason that I will never understand, to translate commands in Excel and the same is unfortunatelly true for PowerApps.

 

["VAT", "Name"] - does not work in Czech language
["VAT"; "Name"] - is "ok"

There is no difference if you have just 'dbo.companies' or Filter(...) in Items. Currently I have there full table so just 'dbo.companies' in Items.

 

I think that this issue is simply bug. I do not know where to report it... Cause of this bug is the translation mentioned above.

 

Workaround I found:

1) Set SearchFields ["VAT", "Name"] - ignore error (Unexpected symbols.....)

2) Run - stop preview

3) Correct SearchFields to ["VAT"; "Name"] - error is gone everything works fine now you can search in both columns

4) Repeat 1) - 3) for second combobox

5) Publish the version - everything works fine now you can search in both columns in both comboboxes

 

Problem is that you need to repeat steps above everytime you edit the app, because next time you open the app for editing, does not matter that you haven't changed a bit, SearchFields are reset to ["VAT"] only. 

 

 

Anonymous
Not applicable

Adding @FilipKto help with this question.

@Anonymous 

I'm also seeing this error. Think should be fixed!!!

 

 

 

Nicolai_Hardahl
Advocate I
Advocate I

Hi @TomasZubov , @Anonymous 

 

Was this issue ever solved? I face same issue in an app a recently created. I have several comboboxes on different screens, but only the first inserted combobox on the first screen allows me to search multiple fields from my connected SQL data source.

The rest of my comboboxes are setup exact same way as the first, using the same data source.

Hi @Nicolai_Hardahl ,

 

I just tested that and at least now it works with semicolon, but you need to change it before every single change.

 

So issue with search field deletion is not fixed. 

Hi @TomasZubov and THX for this. i live in Denmark and had the same problem. Hovever my solution has been to use "," instead of using ";" as i normaly do. I just ignored the error, and published the app, and it has been working fine since. Realy one of those "What?" moments. But once again, thank you for your solution.

 

/Frank

Denmark

Toni81
Frequent Visitor

Same problem in Finland 😞

calerof
Helper III
Helper III

Same problem in Mexico. The SearchField property keeps resetting the two columns and leaves only one.

SearchField_Error.png

 

When is that going to be fixed?

Fernando

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Power Apps June 2021

June Power Apps Community Call

Did you miss the call? Check out the recording here!

Top Solution Authors
Top Kudoed Authors
Users online (31,408)