Showing results for 
Search instead for 
Did you mean: 
Super User
Super User

Visualizing data in CDS Model driven app

Hello everyone,

I have been migrating my data to CDS 2.0 and exploring Model Driven Apps. I have been able to bring in two related entities into a new MDA but have been unable to figure out how to create a view that shows the relationship between the two tables. The entities already contain a primary key and foreign keys. 

For example, I would like to select a client (One side)  and show the encounters (Many side).   My data has Primary and Foreign keys in two entites but I can't figure out how to use them to create the view.  Any help would be appreciated.

Community Support Team
Community Support Team

Re: Visualizing data in CDS Model driven app

Super User
Super User

Re: Visualizing data in CDS Model driven app

Hi @v-yuxima-msft ,

I appreciate the reference but I still can't figure out how to use relationships to help me display my data in a Model Driven App.  I currently have a database of over 8000 patients with over 23000 visits.  I have no problem relating them in a canvas app using Primary and Foreign keys but I can't seem to figure out how to select a single patient and show the visits using a model driven app.  It seems like it should be simple but I am stuck on how to filter the visits entity after selecting a patient.  

Helpful resources


PowerApps Monthly Community Call!

Join us next Wednesday for our Demo Extravaganza, October 16, 2019 8am PDT.


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


Power Platform Summit North America

Register by September 5 to save $200

Users Online
Currently online: 145 members 3,676 guests
Please welcome our newest community members: