Unanswered

Set Combobox Value

(0) Share

Report

Posted on by mogulman

764

This should be simple. I have a combobox (ClientContactCB) with a list of names. One name is Ted Bell. I have a variable, varClientContact = "Ted Bell". I want to set the value of the combobox to the value of the variable "Ted Bell".

Categories:

Building Power Apps

I have the same question (0)

All responses (12)

Answers (0)

Sort by

dinusc Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hello mogulman,
What do you mean by "set the value fo the combobox"? Do you mean:
1. Changing the value of one of the ComboBox items?
2. Selecting that item in ComboBox?

For #1, you would have to change tha value on the source (form which the ComboBox is getting data)
For #2 For example:
Button1.OnSelect=Reset(ClientContactCB);Set(d, [varClientContact ])
ClientContactCB.DefaultSelectedItems=d

Clicking on Button1 should select the item from the variable varClientContact

Was this reply helpful? Yes No
mogulman52 41 on at

Like (0)

Report
Copy link

Link copied!

I guess I'm not explaining myself very well. But I finally figured out problem. DefaultSelectedItems expects a table. Simply put square brackets around it to cast as table [varClientContact]. After I figured it out I looked dinusc's solution and noticed square brackets. Wasted 2 hours on this.

Was this reply helpful? Yes No
dinusc Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

I'm glad you figured it out. Please note that the reason you need square brackets is because the DefaultSelectedItems can have more that one item.

Was this reply helpful? Yes No
NPrice99 1,302 on at

Like (0)

Report
Copy link

Link copied!

Hi

How do I set the DefaultSelectedItems to the item the user has selected from the drop down ?

Regards

Nigel

Was this reply helpful? Yes No
NPrice99 1,302 on at

Like (0)

Report
Copy link

Link copied!

Hi

I have tried this abd I get an error for combobox.DefaultSelectedItems saying that DefaultSlectedItems is an invalid name !

Anybody Any ideas ?

Regards

Nigel

Was this reply helpful? Yes No
mogulman 764 on at

Like (0)

Report
Copy link

Link copied!
How do I set the DefaultSelectedItems to the item the user has selected from the drop down ?

I'm not understanding your question. Do you have Dropdown and a Combobox?

To get value of Combobox selection use this:

Last(ClientContactCB.SelectedItems).FullName
ClientContactCB is the combobox. FullName is the field in the combobox. If this is not what you want post specific details on your question.

Was this reply helpful? Yes No
NPrice99 1,302 on at

Like (0)

Report
Copy link

Link copied!

Hi Mogulman

I am trying to set a value for a combobox when a user selects a item from the dropdown.

Thanks

Nigel

Was this reply helpful? Yes No
dinusc Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello Nigel,

The following should work for default ComboBox1 and DropDown1 controls:
DropDown1.OnSelect=Reset(ComboBox1);Set(dsi,Dropdown1.Selected.Value)
ComboBox1.DefaultSelectedItems=[dsi]

Was this reply helpful? Yes No
NPrice99 1,302 on at

Like (0)

Report
Copy link

Link copied!

Hi dinusc

This almost worked !

The selected value flashes up for a moment before "Find Items" overwrites it.

Regards

Nigel

Was this reply helpful? Yes No
dinusc Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

There should be another formula that overwrites it then. Please test this with a blank app with default DropDown and ComboBox controls. Selection should work and this should be a good starting point to check other formulas in your "real" application. My guess is that there's somewhere another "Reset(ComboBox1) formula that removes the selection.

Was this reply helpful? Yes No