Power Apps more than two levels filtering sharepoint

[JoJu]

I am building canvas Power App with Sharepoint as a data base. It is employee data with hierarchical structure based on manager personal ID. Hierarchy can be up to 6 levels. List has column "Approved". Data in the Power App is personalised and manager can see only organisation under him.

I need to be able to count how many employees are approved in the manager organisation. So if manager have five levels under him, I need to loop through all those 5 levels and check if value of the column approved is "Yes".

I can easily do it with two levels down by using nested galleries, but since power apps do not support more than two levels, I'm hitting a wall here.

Anyone had worked on something similar and could guide on how to achieve what I need?

[BCBuizer]

Hi @JoJu ,

Probably it's easiest to add further columns to your SharePoint list for the Level 1 manager, Level 2 manager, Level 3 manager, etc. You can then leverage this to apply a filter directly to the relevant column.

[JoJu]

Thank you for your answer! I was thinking about the same, but still can not wrap my head around on how the function should be. I have create an example data dump, would you be able to help me to create function based on this? 

Personal ID	Manager ID	Employee Email	Name	Approved	Manager Level	Is manager
12345		12345@google.com	emp1	No	1	Yes
12346	12345	12345@google.com	emp2	No	2	Yes
12347	12345	12345@google.com	emp3	No		No
12348	12345	12345@google.com	emp4	No		No
12349	12345	12345@google.com	emp5	No		No
12350	12345	12345@google.com	emp6	No	2	Yes
12351	12346	12345@google.com	emp7	No		No
12352	12346	12345@google.com	emp8	No		No
12353	12346	12345@google.com	emp9	No		No
12354	12346	12345@google.com	emp10	No		No
12355	12346	12345@google.com	emp11	No	3	Yes
12356	12346	12345@google.com	emp12	Yes		No
12357	12346	12345@google.com	emp13	Yes		No
12358	12350	12345@google.com	emp14	Yes		No
12359	12350	12345@google.com	emp15	Yes		No
12360	12350	12345@google.com	emp16	Yes		No
12361	12353	12345@google.com	emp17	Yes		No
12362	12353	12345@google.com	emp18	Yes		No
12363	12353	12345@google.com	emp19	Yes		No
12364	12355	12345@google.com	emp20	Yes		No
12365	12355	12345@google.com	emp21	Yes		No
12366	12355	12345@google.com	emp22	No	3	Yes
12367	12366	12345@google.com	emp23	No		No
12368	12366	12345@google.com	emp24	No		No
12369	12366	12345@google.com	emp25	No		No
12370	12366	12345@google.com	emp26	No		No
12371	12366	12345@google.com	emp27	No	4	Yes
12372	12371	12345@google.com	emp28	Yes		No
12373	12371	12345@google.com	emp29	Yes		No

[BCBuizer]

Hi @JoJu , 

• I meant to have 5 new columns (level 1-5 manager) where the full path is recorded per employee. As I'm typing on a phone now I can't add a table to show, but it would contain the below info for example 12373 :

Level 1: 12345

Level 2: 12346

Level 3: 12355

Level 4: 12366

Level 5: 12371