Unanswered

Trying to set combo box value with the press of a button

(0) Share

Report

Posted on by Community Power Pla...

Hi all,

I'm new to powerapps and dataverse, and i have run into a problem that i feel like i have used too much time on now.
In my powerapp I'm trying to use the SET and LOOKUP function to set a value in a combo box via a press of a button. The Combo box is connected to a dataverse form. The dataverse table is connected in the powerapp.

The thing i tried was:
Button(OnSelect): Set(Var,LookUp(DB, columnName = "Bla Bla"))
Combo Box(DefaultSelectedItems): Var
But here i get the "These types cant be compared: DB, text"

Then i tried this function:
Button(OnSelect): Set(Var,LookUp(DB,"Bla Bla" in columnName))
Combo Box(DefaultSelectedItems): Var

Here is a little info box:
Var = Just a variable
DB = Table name
columnName = Table column name
"Bla Bla" = Combo box option

Let me know if anything is unclear - Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Community Power Pla... on at

Like (0)

Report

I totally forgot to add the error i got from the 2nd function.

But when i use the function: Button(OnSelect): Set(Var,LookUp(DB,"Bla Bla" in columnName)) I get the runtime error: Server Response: DB failed: No function signature for the function with name 'contains' matches the specified arguments. The function signatures considered are: contains(Edm.String Nullable=true. Edm.String Nullable=true).

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report

Hi @Anonymous ,

Could you please tell the Items of the Combo box? Since the selected items should be one or more records that exist in the table, on your end you need to make sure the Items property is the DB Dataverse table as well.

I made a simple test for your reference:

If the Items and the Set function share different data sources, you need use another LookUp function in DefaultSelectedItems to get the corresponding record.

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @v-jefferni,
Thank you for your answer 🙂
I have added both items to the datastore collumn and then i tried this:
Employment/Combo box:

I tried with just userDBS (which is the table name), but without any success.

Button:

I get this "error" but could it be that i need to use the Text() function?

When i select an item from the combo box then i can see both options

Was this reply helpful? Yes No
Verified answer

v-jefferni on at

Like (1)

Report
Hi @Anonymous ,

So it is a Choice column (Option Set) of Dataverse. I made a test for your reference:

Set(var, LookUp(Choices('Employment (UserDBS)'),Value = 'Employment (UserDBS)'.'White Collar'))

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @v-jefferni,

Thank you so much. This helps alot! 🙂

Was this reply helpful? Yes No