Nested filter with self-referencing List

(0) Share

Report

Posted on by mohanade

Hi all

I have a complicated use case that I need your help on it

I have a list called "AssigendGoals" with contains the goals assigned for each employee, and for each employee they can assign a goal for their direct report and link this new goal with their own goal, so we'll have hierarchy of goals.

the requirement here is I want to create a gallery that filters "AssigendGoals" list with my assigned goal (as a user) and my manager's linked goal, and may manager's manager linked goal ... then the strategic objective which will be the highest in the hilarity

I made it only to the 3rd level through this formula, but failed to make it reach higher levels

could you please suggest better solution?

thanks

Filter( AssignedGoals,ID=Gallery3.Selected.ID Or ID = Gallery3.Selected.'Manager Objective ID' Or
ID= LookUp(AssignedGoals,ID = Gallery3.Selected.'Manager Objective ID').'Manager Objective ID' Or
ID= LookUp(AssignedGoals,ID =LookUp(AssignedGoals,ID = Gallery3.Selected.'Manager Objective ID').'Manager Objective ID').'Manager Objective ID' )

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

victorcp 2,350 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi,
I would do something like this:
With( {Id1:LookUp(AssignedGoals,ID = Gallery3.Selected.'Manager Objective ID').'Manager Objective ID'}, With( {Id2:LookUp(AssignedGoals,ID = Id1).'Manager Objective ID'}, With( {Id3:LookUp(AssignedGoals,ID = Id2).'Manager Objective ID'}, Filter( AssignedGoals, ID=Gallery3.Selected.ID Or ID = Gallery3.Selected.'Manager Objective ID' Or ID= Id1 Or ID= Id2 Or ID= Id3 ) ) ) )
If you need to go deeper just create more Withs.

I hope it helps 🙂
mohanade 65 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you so much, I really appreciate your effort and time, super helpful