Power Platform Community Forum Thread Details

Hello Team,

I have one requirement which is something like this - I have one container and a gallery in which i have resource details and the project in which they're working. If a manager logs in their reportees should come and after clicking to the down arrow the projects in which they're working should come (That's achieved). On the right hand side, i need the bandwith of the resources if i don't click the down arrow then it's should show the total bandwidth of the resource and after clicking the drop arrow the bandwidth should come as per the projects. Suppose A reports to me and he is working in 3 projects so for Jan-24 he is occupied for 1.5%. Project wise A1 - 0.8, A2-0.2, A3- 0.5. Similarly i need this for two years. For getting the bandwidth the data source is my Share Point list named as 'Resource Planning'. The project details data source is the collection of Excel Sheet Col_Project_Details. I am attaching the screen shot for better understanding. Please give me some idea how to achieve this. I have no clue for this. Thanks in advance.