Answered

Set Default of ComboBox According to Text Input

(0) Share

Report

Posted on by shuhn1229

Hi,

I have a combobox with about 75 different choices. I would like the DSI of this combobox to be equivalent to a text input control value, if one exists. Is there an efficient way to do this without 75 different IF statements in the DSI? e..g.:

If(
 Field.Text = "MyChoice",
 LookUp(
 Choices([@'Test_1'].'Options.Choices'),
 Value = "MyChoice"
 ),

Categories:

Building Power Apps

All responses (6)

Answers (1)

Sort by

Rusk 1,369 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Here you go:

LookUp(ComboBoxSample,Value1 = TextInput1.Text)

Please see the following example. The key is to use the "DefaultSelectedItems" property
Typing "Item 1", "Item 2", etc. in the text input will change the dropdown value. In this example the source table for my ComboBox is named "ComboBoxSample" and the column I'm matching to is named "Value1"
shuhn1229 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi -

Thanks. What is the items property on your ComboBox? Cant get it to work as above. My combobox's items are set to distinct of a column for what its worth. Thanks.
Rusk 1,369 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
My ComboBox Items is "ComboBoxSample". That's the default placeholder table the control has. In your case, it should be
LookUp(YourDataSource,YourColumn = TextInput1.Text)

Your data source is the table your combo box is referencing, the column is the same column you're using in your combo box (first value, the value you are matching to)
shuhn1229 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi,

I'm sorry I'm completely confused now.

The DSI or Default selected items in your combobox control is:
LookUp(YourDataSource,YourColumn = TextInput1.Text)
You're saying that the items property on the combobox control is the same as above? I've tried both and neither work. Is your value1 column a text column or other type on sharepoint? Apologies ahead of time, trying to troubleshoot.

My Items is set to the following right now, which works to display the choices, but does not default to anything when something is typed in the textinput control. For what its worth my "YourColumn" is text.
RenameColumns( Distinct( dbName, someId ), "Result", "someId" )
Verified answer

Rusk 1,369 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Here's another example. I simply gathered a few items into a collection named colTest, text values only:
Then I added a Combo Box. The "Items" is set to colTest:
Lastly, I added a text input. Using the formula above, the new formula for my combo box "DefaultSelectedItems" is
LookUp(colTest,Item = TextInput1.Text)
shuhn1229 on at

Like
a
(1)

Report
Copy link

Link copied!
Thank you for all of your help. I got this to work by generating a collection on start using the distinct function

ClearCollect( colID2, Distinct( 'User Notification Controls', Title ).Result );

and then using the following on DSI:

LookUp(colID2,Result = TextInput1.Text)

Combobox items set to colID2