Answered

Org Chart from local collection (without Office365 connector!)

(0) Share

Report

Posted on by Christoph15

Hi everyone,

I'm struggling with collecting direct and indirect reports without using the Office 365 connector (I have a solution with it in place but the performance is bad when collecting multiple levels).

I do have a master collection (MergedPDC) with all employees (column name: 'Employee Name') and their supervisor (column name: 'Supervisor Name') and their email address (column name: 'Email') . I want to collect all indirect reports of the current user of the app to show up in a gallery.

1.) Collect direct reports of the current user (testemail) -> working fine

ClearCollect(
DirectReports,
Filter(MergedPDC,'Supervisor Name'=LookUp(MergedPDC,Email=testemail).'Employee Name')

2.) collect all direct report of every direct report of step 1 -> here I'm struggling

ForAll(
DirectReports,
Collect(
InDirectReports,
Filter(MergedPDC,'Supervisor Name'....

I want to filter all employees in the master collection with ,'Supervisor Name' = directreports.'Employee Name'

I am grateful for any advice!

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
@Christoph15 what have you tried?

Have you tried
ForAll( DirectReports, Collect(InDirectReports, Filter(MergedPDC,'Supervisor Name' = 'Employee Name') ) )
Christoph15 62 on at

Like
a
(1)

Report
Copy link

Link copied!

yep and doesn't work -> I think as the logical test only compares the columns inside MergedPDC and not in relation to the DirectReports collection.

to test:

First(Filter(MergedPDC,'Supervisor Name' = 'Employee Name')).'Employee Name'

is empty
Verified answer

Christoph15 62 on at

Like
a
(1)

Report
Copy link

Link copied!
I found a solution utilizing a gallery but no idea about directly working on collection level.

Clear(InDirectReports); ForAll( Gallery1.AllItems, Collect( InDirectReports, Filter( MergedPDC, 'Supervisor Name' = Title1.Text ) ) )