Power Platform Community Forum Thread Details

Hi everyone,
This is in continuation to one of my posts that I had recently posted on Power Apps forum (which is marked as completed: As it in case for one list), but now I have a similar requirement (for more information you can check the below post wherein you can get some idea of what I am trying to convey)
Hierarchy Based Structure (within a single List)

I had to implement in my main app which has more than one SP list just to give you a context this application is wherein Employee fill in their details which include personal details, skill details and so on. Currently there is no Azure AD configured at my organization so using inbuilt functions of Microsoft Office 365 connector (DirectV2Reports) is not an option for now, so in sample how I have added a Person column (Manager) similarly I am thinking of adding here, but using the flow we can target permission for one list at a time in the actual app there are around 6-7 lists so in that case how should I configure this custom permission level

(In the above list we have details of employees that have registered in the app)

(This list shows the certifications list of an employee; Here employeeId is nothing but the session ID as every user has a unique session Id associated with them and currently on UI we are filtering it as per the userID {sessionID} so that only certification data associated with a particular user shows up)

These are some of the lists that are used in the actual app (and you might observe the common column in this lists is employeeId)
EmployeeId is nothing but the session Id which is a single line of text - Column type

So now if I have to implement the hierarchy like structure at SP list level for these lists how to achieve that. If I add a Manager (Person column) in the User Management list and assign a user for a user (like Teja has Manager: Shubham, so now Shubham should be able to access all the records that are associated with Teja)

(Do I need to add a new person column to all these lists ? 😶 as that will be harder to maintain as there a lot of records created in the application already)
Need some suggestions for this on how to proceed.

Regards,
Sidhant.