Button A = Combo Box A visible, & Button B = Combo Box B Visible, then Text Input = Whatever was selected of either C.B. A or B

(0) Share

Report

Posted on by Deme_trius

Hi,

I'm needing a set up to do the following:

Either button A or B can be selected, which will show Combo Box A or B (respectively). (The two combo boxes are pulling from two different columns of a data table.)

I then need a Text Input to load either the selected data from Combo Box A or B.

Additionally, is there a way for a Combo Box or similar to search from two sets of data based on input?

@Amik I've tried working based off your solution to a topic in June but no luck (Solved: Container Pop-Up and Additional Buttons - Power Platform Community (microsoft.com))

Any help would be amazing!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Deme_trius,

Do you want to:

1). Click a button to make the representive combobox visible?

2). Filter items in ComboBox based on TextInput text?

Could you please tell me that if the ComboBoxB will be visible as well if ComboBoxA is visible?

Could it be possible that you want to make both of two ComboBoxes visible at the same time?

I think the issue in your scenario should be an either/or question, if so, please try the following steps:

1). Set the OnSelect property of buttonA:

Set(varA,true);Set(varB,false)

Set the ComboBoxA Visible property:

varA

Set the ComboBoxA Items property:

If(varA,Filter(list1,TextInput12.Text in Title))

2). Set the OnSelect property of buttonB

Set(varB,true);Set(varA,false)

Set the ComboBoxB Visible property:

varB

Set the ComboBoxB Items property:

If(varB,Filter(list2,TextInput12.Text in Name))

Was this reply helpful? Yes No
Deme_trius 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Qi,

Thanks, this has helped me get a start on the foundations of this.

Essentially - this app is used for vehicle identification - where people can either search via a company stock number (Option A) or Vehicle Identification Number (Option B).

As Data needs to be accurate (the vehicle needs to actually exist), a combo box is being used to ensure a valid selection is made.

So to answer your question, it is '1). Click a button to make the representive combobox visible?'.

What I then need is a third display only field (always visible) that will populate data from my table based on what was selected in either combo box.

For example:

My data looks like this:
VEHICLE STOCK VEHICLE IDENTIFICATION COLOUR
Truck Stock908 VIN123 Red
Car Stock906 VIN345 Blue

Option A chooses from Stock, and B from Vehicle Identification, based on what information the user has.

User selects VEHICLE IDENTIFICATION (Option B Button) and selects data: 'VIN123'

I then need my third display only and always visible field to mirror what has been selected in either ComboBox A or ComboBox B, as that is the data field I will pull through to my report once the user has completed all other fields.

Hope this makes sense!

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Deme_trius,

I assume that you set the ComboBoxA Items property:

If(varA,list.'VEHICLE IDENTIFICATION')

Well, just set the TextInput Default property as:

If(varA,ComboBoxA.Selected.STOCK,varB,ComboBoxB.Selected.'VEHICLE IDENTIFICATION')

Was this reply helpful? Yes No