Answered

sync combo box at the same screen

(0) Share

Report

Posted on by sinanaalmac111

117

Hi All
I just want to share an interesting request that I'm facing with you. I couldn't find a solution maybe you guys give me some tips or advice.

I have a list that contains SkuNumber and SkuName. I put SkuNumber in a combo box. You can search by SKU number Filter it then submit it to update

Here is the request:
Some users want to search and filter SKUs from SkuName because they don't know all of SkuNumbers, and some want to filter SKU numbers. and they want to do this at the same time.

I'm Trying to do this:

I put two combo boxes, one with SKuNumber and the other with SkuName. If you select any of them during filtering, the relevant field in the other will be filled automatically.
for example, If I select SkuNumber "106" the SkuNanme combo box fills automatically with "Tornado-Canva"
If I select SkuName "Window-Comb" the SKuNumber Combo box fills automatically with "110"

is that possible to make or what do you suggest to do for me

Please help me with it.

Here is my interface

And here is my example table that I use

Regards
Sinan

Categories:

Building Power Apps

All responses (2)

Answers (2)

Sort by

Verified answer

WarrenBelz 156,520 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @sinanaalmac111 ,

Although you cannot make controls refer to each other (this causes a Circular Reference), you can set a Variable OnChange of each and then set the DefaultSelectedItems of each to the other variable. So assuming the output of each box is the field name concerned (you will need to change the code below if not) - OnChange of the Number box

UpdateContext( { varName: LookUp( SPList, Title = Self.Selected.Title ).'S-NAME' } )

then the DefaultSelectedItems of the Name box

{'S-NAME': varName}

OnChange of the Number Box

UpdateContext( { varNo: LookUp( SPList, 'S-NAME' = Self.Selected.'S-NAME' ).Title } )

DefaultSelectedItems of Number Box

{Title: varNo}

It would also be good to clear these values at screen OnVisible or anywhere else you want to reset them

UpdateContext( { varName: Blank(), varNo: Blank() } )

If you also want to display existing values on existing records, this will get a little more complex.

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.

MVP (Business Applications) Visit my blog Practical Power Apps
Verified answer

Tardisgx101 60 on at

Like
a
(1)

Report
Copy link

Link copied!

I think Warren has already said this.

I think you need 4 dropdown boxes refering to the same table. Only a set of 2 is visible at a time.

Make 2 buttons or checkboxes so the user can select search by SKU Number first or Sku Name first.

Here is a useful video talking about cascading dropdowns. So you want to do the same code twice effectively with name and number being the mother dropdown decider in each of their own set.

So Set 1 is dropdown(name)->specify dropdown(number) and Set 2 is dropdown(number)->specify dropdown(name)

If you don't want to mess around with the visible property of things just make 2 pages that look similar the buttons navigate to.
https://youtu.be/Qzpjq008cBY?si=d4QglI8ml-mf67rg