Combobox issue

(0) Share

Report

Posted on by MiniMe_83

245

Hi,

Ive come across an slight issue where I have a DataCard in a form which copies the text from a ComboBox which searches a column in a SharePoint List. What I'm looking to achieve, if possible, is to use the selected item from the combobox or use the searchable text if nothing is found. I can seem to do one or the other but not both.

Any ideas?

Thanks for your help

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (2)

Ami K 15,679 Super User 2024 Season 1 on at

Like (0)

Report
@MiniMe_83 - as I understand it, you want to filter a Gallery based on either a combo box selection or search text?

The below example assumes your ComboBox is referencing a Choice column.

Filter( YOUR_DATA, CountRows(YOUR_COMBO_BOX.SelectedItems) = 0 || YOUR_CHOICE_COLUMN.Value = YOUR_COMBO_BOX.Selected.Value, IsBlank(YOUR_TEXT_INPUT.Text) || StartsWith( COLUMN_TO_SEARCH, YOUR_TEXT_INPUT.Text ) )

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

If I have answered your question, please mark your post as Solved.

If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
Verified answer

NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like (1)

Report
Hi @MiniMe_83 ,
You can use something like below -

If(IsBlank(ComboboxName.Selected.Value), ComboboxName.SearchText, ComboboxName.Selected.Value)

Was this reply helpful? Yes No
Verified answer

MiniMe_83 245 on at

Like (0)

Report

Hi NandiniBhagya20, this was my first thought but it doesnt seem to work. Im assuming this is entered into the default of the datacard?

Was this reply helpful? Yes No
MiniMe_83 245 on at

Like (0)

Report

.

Was this reply helpful? Yes No
MiniMe_83 245 on at

Like (0)

Report

Hi Amik,

The column is a simple single text column, not sure if this makes any difference.....

Was this reply helpful? Yes No
NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like (0)

Report

HI @MiniMe_83 ,
Yes, you can put the formula in Default property of DataCard.
Make sure IsSearchable property of combobox is set to true.

Was this reply helpful? Yes No