Combobox, Variable, lookup Colum

[AtmaDharma]

Hi, There I'm trying to set the combo box to each value by 2 different buttons.

Booking Reference Number is a Lookup Colum

combobox items = Choices('Meal Orders Tables'.'Booking Reference Number')

this gives a drop-down with two choices, 10Q3L7Q0 and 11V0V7H7

I set Default selected items = varUser

here is the problem making the button to select the particular reference number

I tried in the onselect of the button

Set(
varUser,
LookUp(
Choices('Meal Orders Tables'.'Booking Reference Number'),
Value = ImpBooknumLogin.Text

the ImpBooknumLogin is text input where the user can put there reference number.

but I'm getting errors on the on select field of the button.????

[v-liwei-msft]

Hi @AtmaDharma 

Based on the formula you provided, I see two parentheses are missing in your formula.
When I add two parentheses and test it, there is no error.

1.

2.

3.

4.

Set(
varUser,
LookUp(
Choices('Meal Orders Tables'.'Booking Reference Number'),
Value = ImpBooknumLogin.Text
)
)

Best Regards,

Levi

[AtmaDharma]

I tried exactly that , even in a new canvas app, im still getting a red line under Value saying Name isnt valid 'Value' isnt recognised, and = say incompatible types for comparison.

[v-liwei-msft]

Hi @AtmaDharma 

Please click the formula in the items property of the ComboBox to check whether the table returned by the Choice function contains the Value field.

Best Regards,

Levi

[AtmaDharma]

I don't see Value dasa_referencenumber

[v-liwei-msft]

Hi @AtmaDharma 

According to the screenshot, the data you need is provided by dasa_referencenumber.
Try replacing Value with dasa_referencenumber.

Best Regards,

Levi

[AtmaDharma]

I just did that and there is no longer errors in the code, but it doesn't update the combo box on select

[v-liwei-msft]

Hi @AtmaDharma 

Do you want to change the display of the ComboBox based on the text input box?

The default value of the ComboBox is provided by a variable, so you need to click the button after the text input box is entered.

Best Regards,

Levi

[AtmaDharma]

Yes the text input is populated

[v-liwei-msft]

Hi @AtmaDharma 

Please click the button after text input is populated.

Best Regards,

Levi