Unanswered

Direct Reports - collection within a collection

(1) Share

Report

Posted on by Aethyta

Is there a way I could create a collection within a collection? For example:

ClearCollect(
 myReports,
 Filter(
 Office365Users.DirectReports(_varMyEmail),
 AccountEnabled = true
 )
);

It should give me all email directly reporting to me. But if my manager is viewing the app, she should see everyone directly reporting to her including staff directly reporting to each of her staff.

So if my staff Employee 1 & 2 are both managers with 5 staff each. When I view the app, the gallery should display Employee 1 & 2 + 10 staff.

Categories:

Building Power Apps

All responses (5)

Answers (0)

Sort by

poweractivate 11,078 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Tamras

Try this high level approach

Use AddColumns to merge two collections. Similar discussion: Merge one collection with another

The generic approach above could work if adapted to your case.
Aethyta on at

Like
a
(1)

Report
Copy link

Link copied!

@poweractivate Thanks. I'll test this soon. I'm currently testing another solution from another post. But I will definitely post back the results later.
yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Tamras

You can follow these threads to get a list of all the direct and indirect staff members for a specific user:

https://powerusers.microsoft.com/t5/Building-Power-Apps/DirectReports-and-all-their-DirectReports/m-p/167970

https://powerusers.microsoft.com/t5/Building-Power-Apps/Direct-Reports-and-Indirect-Subordinates-in-powerapps/m-p/187387

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
poweractivate 11,078 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@Tamras

You can also try something like this (from Direct Reports and Indirect/ Subordinates in powerapps 😞

From one button:
ClearCollect(
DirectReports,
Office365Users.DirectReports("YourManagerEmail")
)

Set the OnSelect proeprty of the "InDirect Reports" button to following:
Clear(InDirectReports);
ForAll(
DirectReports,
Collect(InDirectReports, Office365Users.DirectReports(Mail))
)
yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Tamras

If you would go to the links provided in my response, you will be able to understand the whole process of what is going on in this case. A well explained solution is provided on the thread.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!