Hello. I'm hoping I can get some help with a flow that I'm looking to build.
I'm looking to use the get manager flow to collect a series of direct reports for a manager and add them individually into a SharePoint list. This would look at 4 levels of managers and place them into a column of the SharePoint list.
It would be: Manager level 4 added to the level 4 column and then there Direct reports (Manager level 3) Manager Level 3 added to the level 3 column and then there Direct reports (Manager Level 2). Manager level 2 added to the level 2 columns and then there Direct reports (Manager level 1). Manager level 1 added to the level 1 column and then there Direct reports.
In the end each row of the SharePoint would have one entry from each level to break down a list of an organizational hierarchy.
Hoping someone has come up with something like this in the past.