Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Table Setup for Drop downs on CDS

Good Afternoon Guys, 


Im trying to setup multiple dropdown boxes for an app im workng but having issues setting this up i have setup the table like this



But i cant get the app to look at the other columns? 


Can anyone recomend the best way to set this up and the best formula to use? 

Power Apps
Power Apps

Hi Martin,


Could you please give me an example of what you're trying to add in the lookup?


Assuming the entity in your screenshot is Entity A, are you trying to create another Entity B and have a lookup on A? Or have you already created that and are you trying to show different values from B in the lookup on A?



Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,434)