
Thank you for taking the time to read my question.
I have 3 tables that have many to many relationships.
Team - Resources
Task - Team
Task - Resources
A Team is a predefined list of Resources. Either a Team or a Resource(s) can be assigned to a Task.
This is all working.
I'm struggling however to create a screen where I can show the number of Tasks assigned to a Resource (even when a part of a Team) or Tasks Assigned to a Team.
I've tried using a Gallery based on Tasks, and then using dot notation to refer to the Team, but I can't use dot notation to reference the Resource because there can be many Resources associated to a Task. So I tried to use a child gallery but can't seem to link it properly. PowerApps is not hinting any fields that are useful.
Am I approaching this correctly? Any direction would be appreciated.
Thanks