Chart and Many to Many Relationship

(0) Share

Report

Posted on by Arioule

156

Hi,

I have created 3 entities : Project, Consultant and ProjetConsultant

The Project Entity properties : Name, Start Date, End Date

The Consultant Entity Properties : Name

The ProjetConsultant Entity Properties : Name, Name (from the Projet Entity), Name (from the consultant Entity)

There is a Many to One Relationship between ProjectConsultant and Project Entities.

There is a Many to One Relationship between ProjectConsultant and Consultant Entities.

Therefore, there is a Many to Many Relationship between Project and Consultant Entities.

I would like to create a Project Entity Chart which will display the number of project for each consultant based on the Ongoing Project View (already created).

How can I achieve this ?

Thanks,

Arioule

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (2)

Sort by

Verified answer

Joel CustomerEffective 3,224 on at

Like (0)

Report
Copy link

Link copied!

You aren't going to be able to build this chart from the project entity because project consultants are a 1:N relationship with project, and you can't include :N fields in a 1: view.

What you need to do is build your chart at the joiner level (project consultants). Create a view that includes fields from project and consultant, then use that as the basis of your chart.

You can then add the chart to a dashboard along with project level detail.

Was this reply helpful? Yes No
Verified answer

Joel CustomerEffective 3,224 on at

Like (0)

Report
Copy link

Link copied!

@Arioule I made a video showing you how this works. https://youtu.be/285dynzFl1M

Was this reply helpful? Yes No
Arioule 156 on at

Like (0)

Report
Copy link

Link copied!

Thanks a lot for your help

Regards,

Was this reply helpful? Yes No