cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ShaheerAhmad
Advocate V
Advocate V

Create a column to show the number of related rows from another table

Hello, as you can see here i have two tables: Class & Class Sections

both are related. i have a column in Class Sections Table that shows its parent Class.

I want to create a custom column in dataverse table that shows the numbers of sections of the class.

or in other words i want to create a column in Class Table to automatically count the number of related columns in Class Section Table.

I hope im clear enough. Im not sure how to achieve this. Need some help.

Thanks

 

 

 

ShaheerAhmad_0-1662195094374.pngShaheerAhmad_1-1662195117201.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
Mira_Ghaly
Dual Super User
Dual Super User

@ShaheerAhmad 

You need to create a roll-up column for this purpose.

Please find below link to guide on how to create roll-up columns

https://docs.microsoft.com/en-us/power-apps/developer/data-platform/calculated-rollup-attributes#rol...

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

View solution in original post

1 REPLY 1
Mira_Ghaly
Dual Super User
Dual Super User

@ShaheerAhmad 

You need to create a roll-up column for this purpose.

Please find below link to guide on how to create roll-up columns

https://docs.microsoft.com/en-us/power-apps/developer/data-platform/calculated-rollup-attributes#rol...

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Users online (5,620)