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

Drop down from two diffrent tables

Hey Guys,

 

I have a drop down box that displays a value called job, this is a number. I want a second drop down box that will display names of people that are working on the job number. These two values are in diffrent tables but a unique key in both tables called vendor is there to link the tables. Is there any way i can make my second drop box?

 

 

4 REPLIES 4
samuelJ
Level 8

Re: Drop down from two diffrent tables

Set items property to:

Filter('[dbo].[someTable]', keyValue = Dropdown1.Selected.keyValue)

Where "Dropdown1" is the name of your first dropdown, '[dbo].[someTable]' is the name of your data source, and "keyValue" is the name of the key that ties the two sources together.  

 

nickbuono
Level: Powered On

Re: Drop down from two diffrent tables

This was able to get me a single record in my drop down. However there should be others that appear in the dropdown with it. This is what i have in my second dropdown currently.

 

Sort(Distinct(Filter('[Std].[APM_MASTER__VENDOR]',Vendor=dropbox.Selected.Vendor),Name),Result)

 

Where Vendor is the key that is in both tables.

 

Thanks for the help!

 

 

samuelJ
Level 8

Re: Drop down from two diffrent tables

Take out the Distinct(), what do you get?

nickbuono
Level: Powered On

Re: Drop down from two diffrent tables

Still only one record. Im wondering if its easier for me to just not have a second drop down and make a list instead that the user can select from.

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
Users Online
Currently online: 181 members 5,601 guests
Please welcome our newest community members: