cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Entities relationships

Hi guys, 

 

I have a question about the relationships between entities in CDS.

 

So there are three entities, portfolio, projects and risks. As the attched image shows, between portfolio and projects, the relationship is one to many. Between projects and risks, the relationship is one to many. 

 

Blank Diagram.png

In this scenario, I want to put all related projects and related risks as subgrid views on the main form of portfolio. 

I know there is a option for projects, which is Show related records. But there is no option for risks. 

 

Capture.PNG

 

Please let me know your ideas. Much appreciated.

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Kudo Kingpin
Kudo Kingpin

Re: Entities relationships

You could create a one to many relationship of Portfolio to Risks, and a Process workflow that sets the value of Portfolio in Risks based on the Portfolio in the Risk's Project, to be triggered on Create, and on Change. In forms, keep the Portfolio in Risks, hidden or read only. 

 

It works.

View solution in original post

4 REPLIES 4
Highlighted
Community Support
Community Support

Re: Entities relationships

Hi @Anthlex ,

Do you want also to display related risks records as Subgrid View within the Main Form of your Portfolio Entity?

 

If you want to  display related risks records as Subgrid View within the Main Form of your Portfolio Entity, I afraid that there is no way to achieve to your needs in PowerApps Model-Driven form.

 

Currently, within PowerApps, we could only display direct relationship as Subgrid related view within one Entity form, we could not display indirect relationship as Subgrid related view within one Entity form.

 

If you would like this feature to be added in PowerApps, please submit an idea to PowerApps Ideas Forum:

https://powerusers.microsoft.com/t5/Power-Apps-Ideas/idb-p/PowerAppsIdeas

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Kudo Kingpin
Kudo Kingpin

Re: Entities relationships

You could create a one to many relationship of Portfolio to Risks, and a Process workflow that sets the value of Portfolio in Risks based on the Portfolio in the Risk's Project, to be triggered on Create, and on Change. In forms, keep the Portfolio in Risks, hidden or read only. 

 

It works.

View solution in original post

Highlighted
Regular Visitor

Re: Entities relationships

Hey Kris, Thanks for the information. I'll raise an idea there then. Cheers.

 

 

Highlighted
Regular Visitor

Re: Entities relationships

Yeah, it seems the only way to do now. Thanks for sharing you idea. Cheers.

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

Top Solution Authors
Users online (7,222)