cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Arioule
Helper III
Helper III

Chart and Many to Many Relationship

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

 

 

2 ACCEPTED SOLUTIONS

Accepted Solutions

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.

View solution in original post

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

View solution in original post

3 REPLIES 3

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.

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

Thanks a lot for your help

 

Regards,

 

 

Helpful resources

Announcements
October Events

Mark Your Calendars

So many events that are happening this month - don't miss out!

Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Users online (2,628)