Get a list of all employees and their managers

[SachS]

I'm trying to create a list of all employees in my organization along with each employee's manager. I would like to create a CSV file and save it in a SharePoint folder. The workflow I'm using is as follows.

This works fine, and I can get a list of all employees. However, in the 'Create CSV table' step, I don't know how I can retrieve the manager for each employee and have it as the 3rd column. If I click the 'Value' field and open up the 'Dynamic content' panel, it doesn't give me an option to select the manager from there. Is there a way to get this done? I don't even mind using a different step than 'Create CSV table' (such as creating an Excel or whatever) as long as I get a list of all employees with managers.

[v-xiaochen-msft · Accepted solution]

Hi @SachS ,

I did a test for you.

result('Scope')[0]['status']

{"Employee":@{items('Apply_to_each')['displayName']},"Email":@{items('Apply_to_each')['Mail']},"Manager":@{outputs('Get_manager_(V2)')?['body/displayName']}}

{"Employee":@{items('Apply_to_each')['displayName']},"Email":@{items('Apply_to_each')['Mail']},"Manager":"No Manager"}

Best Regards,

Wearsky

[SachS]

This worked perfectly, thanks!

I understood everything but the use of 'Scope', could you please explain that bit?

[v-xiaochen-msft]

Hi @SachS ,

I used Scope here because If a user don't have a manager, 'get manager' action will report an error.

The scope action is used to catch error .

Best Regards,

Wearsky

[Anonymous]

Hi. I don't understand what the value should be for Create CSV? 

[Anonymous]

Hi @SachS ,

Since you have resolved the same issue, i have kind of same issue .

kindly suggest the flow to read a .xl file which conatins the  name of some employees and i need to find their manager.

So initially i need a flow to read the xl file of users and how to get thier managers name?

Appreciate your help.

[yulaw]

Hi @v-xiaochen-msft @SachS 

I am looking for solution exactly like your post. I followed your instruction but it does not work. Test is successfully done but no file is created. Could you share setting in "create csv table" and "create file". Here is mine and I am not sure where the issue is: