Combo boxes multi selected

(0) Share

Report

Posted on by galvang

I have run into an issue that I cannot seem to find a solution for.

ComoBox is giving me an error, "Value isn't recognized.".

I have a TextInput that I use to do a search and it is working, but as soon as I added a comboBox I get this error message.

I saw that Combo boxes multi selected will return data of type table. It cannot be compared with text.
And it needs to get all combo box values as a string by using the Concat function and then comparing it. But I still could not figure out how to solve this issue.
There are Text columns in sharepoint.

ClearCollect(
colDadosGrid,
Filter(
'Clan - Consejo',
StartsWith(
CLAN,
txtCLAN.Text
)
&& (IsBlank(cmbConsejo.SelectedItems) || IsEmpty(cmbConsejo.SelectedItems) || CLAN.Value = cmbConsejo.Selected.Value)
)
);

Categories:

Building Power Apps

All responses (7)

Answers (1)

Sort by

ANB 7,252 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @galvang ,

Can you try this
ClearCollect( colDadosGrid, Filter( 'Clan - Consejo', StartsWith( CLAN, txtCLAN.Text ) && (IsBlank(cmbConsejo.SelectedItems) || IsEmpty(cmbConsejo.SelectedItems) || CLAN.Value in cmbConsejo.SelectedItems.Value) ) );

Check this https://powerusers.microsoft.com/t5/Building-Power-Apps/ComboBox/td-p/2358845/page/2

------------------------------------------------------------------------------------------------------------------------------

I hope this helps.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.

Thanks,
ANB
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
HI @galvang,

Since you want to get all combo box values as a string by using the Concat function and then comparing it, you could try the following formula

CLAN.Value in Concat(cmbConsejo.SelectedItems,Value,",")
galvang 71 on at

Like
a
(0)

Report
Copy link

Link copied!

Still having the same issue. "Name isn't valid. 'Value isn't recognized"
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @galvang,

Could you please tell me how you set the Items property of the cmbConsejo?

Is this CLAN a single-line-of-text column?
Verified answer

galvang 71 on at

Like
a
(0)

Report
Copy link

Link copied!

In the items property of the cmbConsejo I have the date base 'listConsejo'.
I kind of solved the problem, but still can't search in both textInput and combo box. If I do that the results of the gallery disappear.

ClearCollect(
colDadosGrid,
If(
!IsBlank(txtClanConsejo_1.Text),
Filter(
'Lista CONSEJO',
(StartsWith(CLAN, txtClanConsejo_1.Text) || StartsWith(CONSEJO, txtClanConsejo_1.Text))
),
Filter(
'Lista CONSEJO',
(IsBlank(cmbConsejo_1.Selected) || CLAN = cmbConsejo_1.Selected.CLAN)
)
)
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @galvang，

So confused....

1). If thius combobox allows multi select or not?

2). If the column you populated the ComboBox is a single-line-of-text?

3). "still can't search in both textInput and combo box", which makes me confused too, if you want to search based on textinput and combobox, you need to combine them using the "&&"

If it allows multi select, surly your formula does not work.
galvang 71 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @v-qiaqi-msft,
Sorry about the confusion.
What I was referring to is that I was not able to perform simultaneous filtering, such as selecting an option in the ComboBox and also typing something in the search field. Using this example I mentioned, the gallery records disappeared.