Showing results for 
Search instead for 
Did you mean: 
Level 8

Filter on Relationship/Lookup Drop Downs using CDS

I have built several custom entties in the CDS as my Data Source and a Powerapp that is using these.  I have several relationships used thorughout the entites.  I am now to a point where I need to create som filtering on several of the drop downs on my forms which were automatically created within the CDS as a lookup field when creating the relationship.  Very cool.


I have done filtering before with standard Power App Drop downs that do not use the Choices field however I am struggling a bit to get this to work.





I would appreciate some guidance in how to make the bottom "Standard" drop down filter from the selected items in the top drop down.  I am confident i have my relationships, etc. correct within the CDS however just not getting the correct syntax.  I have tried many different methods and most of them come back with "wrong data type expects text type.  For example, Filter(Choices(SVC_Catalogs.crfb3_Standard, Organization.ID = DataCardValue95.Selected.ID), Name))

Level 8

Re: Filter on Relationship/Lookup Drop Downs using CDS

Another example, no matter what I try seems to always lead to this error.  2019-04-19_7-44-23.jpg

Helpful resources


Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.


Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020


Power Platform World Tour

Coming to a city near you


PowerApps Community User Group Member Badge

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


Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

Top Kudoed Authors
Users Online
Currently online: 524 members 4,675 guests
Recent signins:
Please welcome our newest community members: