cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mae_be9292
Level: Powered On

How do I connect / link two dropdown together

I have database in sharepoint with in choice form and then I link it to power app for dropdown type

 

but in power app I want to relate two dropdown together

ex.

 

When I choose "A" in first dropdown it will show "10","20"

and When I choose "B" in first dropdown  it will show "20000","25000"

3 REPLIES 3
Surender
Level: Powered On

Re: How do I connect / link two dropdown together

Have a look at this link: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/dependent-drop-down-lists

 

The above link explains how to use dependent dropdowns.

Community Support Team
Community Support Team

Re: How do I connect / link two dropdown together

hI @mae_be9292 

 

Are these all choices type in your SP list?

If you want to link these two dependent choice column,you need to make one table to generate the relation of them.

You can use collection.

 

For example,add one button control and then 

Button.OnSelect=ClearCollect(test1,{FirstChoice:"A",SecondChoice:10},{FirstChoice:"A",SecondChoice:20},{FirstChoice:"B",SecondChoice:20000},{FirstChoice:"B",SecondChoice:25000})

Then the SecondChoice's Data Card' .Items=Filter(test1, FirstChoice=DataCardValue8.Selected.Value).SecondChoice

linkdropdown.PNG

linkdropdown.gif

 

More information:

create-update-collection

 

Best Regards.

Yumia

 

mae_be9292
Level: Powered On

Re: How do I connect / link two dropdown together

Thank you for your solution. It work!

 

But may I ask you some more question,  the data doesn't save in my database - I mean sharepoint

What should I do about this issue.

 

Many thanks!

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (4,665)