Answered

Combobox not able to pass on selected values from the dropdown list

(0) Share

Report

Posted on by Appyenthusiast

Hello,

I previously used DropDown but I found out that it does not have an inline search. So I have to use a Combobox for this function. The snapshot is from the list populated by Combobox1. Multiple selection is off. And the items property is a SQL table called 'Details'. The list that is shown is from a Column/Field named Customer_Name in the 'Details' table.

Now the lookup query is not working to retrieve the Customer_Id from the same table 'Details'

LookUp(Details, Customer_Name = Combobox1.SelectedItems).Customer_Id

But if I use the code below, it successfully returns the Customer_Id

LookUp(Details, Customer_Name = "Understated advantage").Customer_Id

What am I doing wrong here? Any help is appreciated.

Categories:

Building Power Apps

All responses (7)

Answers (1)

Sort by

WarrenBelz 156,566 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Appyenthusiast ,

Try

LookUp( Details, Customer_Name = Combobox1.Selected.Customer_Name ).Customer_Id

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Appyenthusiast 15 on at

Like
a
(0)

Report
Copy link

Link copied!

Unfortunately that did not work.
WarrenBelz 156,566 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Appyenthusiast ,

What are the Items of ComboBox1?
Verified answer

Appyenthusiast 15 on at

Like
a
(0)

Report
Copy link

Link copied!
As mentioned in my original question :
"And the items property is a SQL table called 'Details'."

However after some more trial and error, this edit using the CONCAT command seems to work. I am not sure why though.
LookUp(Details, Customer_Name = Concat(ComboBox1.SelectedItems, Customer_Name,", ")).Customer_Id
WarrenBelz 156,566 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Appyenthusiast ,

That does not make a lot of sense to me that your customer name would consist of the list of items selected in a combo box separated by commas.

As for your Items, I wanted to check if it was filtered on this list - I always ask for the exact code as many people post fairly vague references.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Appyenthusiast 15 on at

Like
a
(0)

Report
Copy link

Link copied!

There is no 'code' it just populates the name of the Data table in SQL
WarrenBelz 156,566 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Appyenthusiast ,

I know - I was just explaining why I ask questions rather than assuming the person posting understands what the content of their post could mean.