Set the first Direct Report

[Power_Automater]

I am following the following tutorial to create a dynamic org chart. I have completed this and it is working correctly without any errors or issues.

What I would now like to do is add an additional vertical gallery showing the direct reports of the direct reports, if that makes sense. So looking at the diagram below, each box is a vertical gallery, the blue ones are finished and I would like to add the orange.

To make this easier I will assume there is a specific number of the direct reports (since this doesn't change often), so let's say there are 4 direct reports. Therefore what I thought I could do is set each of the direct reports into a separate variable eg. vardirectreport1, vardirectreport2 etc. Because then I could do the following for the Items of each of the orange galleries:

Office365Users.DirectReportsV2(vardirectreport1).value
Office365Users.DirectReportsV2(vardirectreport2).value
Etc

However I am not sure how to store the first/second etc direct report into a variable. I am thinking that by doing it this way if I ever need to add a 4th level to the hierarchy at some point I could use similar logic to achieve this.

How could I achieve this? If there is a better way also open to suggestions.

[KeithAtherton · Accepted solution]

Hi @Power_Automater,

To collect multiple values into a data collection, consider using the Collect function. For example, the following users are collected into a data collection called colUsers:

Collect(colUsers, Office365Users.DirectReportsV2(vardirectreport1).value);
Collect(colUsers, Office365Users.DirectReportsV2(vardirectreport2).value);
Etc

More info: https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-clear-collect-clearcoll...

Also, if the assumption that there are a maximum of 4 levels of reports is true then the approach you mentioned sounds good. However, if the number of levels may vary (for example, next year there are 5 or 6 levels of reports as the organisation grows) then you may want to consider a more flexible approach using recursion, although this would likely add more complexity.

---

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Follow me online.

[Power_Automater]

Thank you @KeithAtherton , I ended up using the approach I suggested by setting the variables in this way:

Set(vardirectreport1,First(Office365Users.DirectReportsV2(varcurrentuser).value));
Set(vardirectreport2,Index(Office365Users.DirectReportsV2(varcurrentuser).value,2));
Set(vardirectreport5,Last(Office365Users.DirectReportsV2(varcurrentuser).value));

I then used the following for the Items of the direct reports gallery (changing the variable for each gallery):

Office365Users.DirectReportsV2(vardirectreport1.mail).value

This worked fine for me but thank you for the alternative approach.