ComboBox data change based on the Label data

(0) Share

Report

Posted on by AVTS

538

ComboBox data changes based on the Label data (Full Cases or Single Unit) .

Example : If label is 5449000200761 then ComboBox should display 3838383 and similary if label is 5449000200747 then ComboBox should display 3838383

Material	Material Description	Full cases	Single Unit
9839393	BGS1	5449000200716	5449000200754
3838383	BGS2	5449000200747	5449000200761

How to achieve this,

Categories:

Building Power Apps

I have the same question (0)

All responses (26)

Answers (0)

Sort by

PatilChetan on at

Like (0)

Report
Copy link

Link copied!

@AVTS

Refer the post: https://powerusers.microsoft.com/t5/Building-Power-Apps/Conditional-visibility-choices/m-p/902186/highlight/true#M286232

Regards,
Chetan

Was this reply helpful? Yes No
WarrenBelz 155,463 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
HI @AVTS ,

I am not exactly sure what you need here as (I assume) you have a couple of errors in the examples and a combo box normally displays a list if items (not a single value). I will cover both - firstly if you are after the single value 9839393, where the Label is 5449000200716 showing 'Full Cases', it would be

LookUp( YourListName, 'Full cases' = YourLabelName.Text ).Material

if there was more than one matching item and you wanted a list of them, replace LookUp with Filter.

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.

Was this reply helpful? Yes No
WarrenBelz 155,463 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @AVTS ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

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.

Was this reply helpful? Yes No
AVTS 538 on at

Like (0)

Report
Copy link

Link copied!

Hi Warren,

i am getting following error, Expected table value

LookUp(Table2,'Full cases'= Label8.Text).Material.

Summary : ComboBox is used for two purpose . Purpose 1. list down the material from Tabel2 and Purpose 2. Shuffle the material based on the Label8 input which is from barcode scanner.

Tabel2 details follows
Material Material Description Full cases Single Unit
9839393 BGS1 5449000200716 5449000200754
3838383 BGS2 5449000200747 5449000200761

If barcode value(5449000200747) in label8 then comboBox should display material no 3838383.

Was this reply helpful? Yes No
WarrenBelz 155,463 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@AVTS ,

Where are you putting that code? If in a gallery, just drop the .Material - that will work in a Label.

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.

Was this reply helpful? Yes No
AVTS 538 on at

Like (0)

Report
Copy link

Link copied!

Hi i am keeping the code in the Items(ComboBox). Gallery in the Combobox or Label .

I am having following following items ,
One Barcoder
One Label
One ComboBox
Requirement : Label is displaying the result based on the barcode scanning and comboBox should display the matched value based on the label results. ComboBox is having two featuers. 1. Its display the full material list from tabel2 and 2.display the material based on the label results

Was this reply helpful? Yes No
WarrenBelz 155,463 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@AVTS ,

This will also work in a combo box, but you need Filter

Filter( YourListName, 'Full cases' = YourLabelName.Text )

Was this reply helpful? Yes No
AVTS 538 on at

Like (0)

Report
Copy link

Link copied!

tried same but no luck .. Dropdown is not getting populated from the label selection .

Was this reply helpful? Yes No
WarrenBelz 155,463 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@AVTS ,

Can you please share the exact code you are using (in Text) and where you are using it (please provide screen shot).

Was this reply helpful? Yes No
AVTS 538 on at

Like (0)

Report
Copy link

Link copied!

Attached . Filter(Table2,'Full cases' = Label8.Text)

Was this reply helpful? Yes No