Answered

Direct report code not showing direct report

(0) Share

Report

Posted on by xrxr031

Hello,

I have a scenario where I want a person that goes into the app to be able to see all those in their org structure (direct reports and indirect reports).

Example Org Structure: Director to individual contributor

John Director-->Jane Senior-Manager-->Tony Manager-->Karen Supervisor-->Emily Employee.

My goal is that when John Director logs in, I would like for him to see Jane, Tony, Karen, and Emily. When I tried to code this, the result I get after John logs in is Tony, Karen and Emily but no Jane (Jane is John's direct report). I wrote the code below to help accomplish my goal but cannot figure out why the direct report is not showing up but the rest of the org structure does:

Clear(colTeam);
Clear(colTeam2);
Clear(colTeam3);
Clear(colTeam4);
ClearCollect(colTeam,Office365Users.DirectReports(User().Email));

ForAll(colTeam,Collect(colTeam2,Office365Users.DirectReports(Mail)));
ForAll(colTeam2,Collect(colTeam3,Office365Users.DirectReports(Mail)));
ForAll(colTeam3,Collect(colTeam4,Office365Users.DirectReports(Mail)));
ClearCollect(colTeam,colTeam2,colTeam3,colTeam4)

Any advice is greatly appreciated. Thank you so much for your help.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (2)

Sort by

Verified answer

Al_10 1,691 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@xrxr031

last line of code:

Collect(colTeam,colTeam2,colTeam3,colTeam4)

Was this reply helpful? Yes No
xrxr031 95 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Alex_10,
Thank you so much for your help. I tried your suggestion and it worked. Thank you so much.
I do have another issue though and that is, although the app is giving me what I was looking for, it does show an error message (see attached). I can click on the x and the app continues to load fine however not sure why the error appears and how to get rid of it. Any ideas?
Again, thank you so much for your help.

Was this reply helpful? Yes No
Verified answer

Al_10 1,691 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@xrxr031

you can try to replace Mail with UPN:

Clear(colTeam);
Clear(colTeam2);
Clear(colTeam3);
Clear(colTeam4);
ClearCollect(colTeam,Office365Users.DirectReports(User().Email));

ForAll(colTeam,Collect(colTeam2,Office365Users.DirectReports(UserPrincipalName)));
ForAll(colTeam2,Collect(colTeam3,Office365Users.DirectReports(UserPrincipalName)));
ForAll(colTeam3,Collect(colTeam4,Office365Users.DirectReports(UserPrincipalName)));
Collect(colTeam,colTeam2,colTeam3,colTeam4)

Was this reply helpful? Yes No
xrxr031 95 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Alex_10,
That worked !! Thank you so much for your insight. Greatly appreciated.

Was this reply helpful? Yes No