pull data from Excel Spreadsheet, check against Office Users and Get Manager, then update new file

[DebV]

Greetings,

I need to be able to pull a specific field from an Excel spreadsheet which is the Employee ID (has a much longer name on the spreadsheet). Then compare the Employee ID number to the Office 365 Users and get the name of the Employee's manager. Once I get the Manager's name I want to update another Excel file with the Employee ID and Manager Name.

I'm bogging down on pulling only the specific column I need from Excel. I know there is a way to do it, but I can't figure it out.

The Excel spreadsheet looks like this:

Date of Call Contact?	What is the Start Time of call?	What is the call number for this call?	What is the employee ID of CR being assessed?
2/27/2019	9:03 AM	313.235.3599	00012345

I need to pull the "what is the employee ID of CR being assessed" into a separate file then get the name of the manager from Office 365 and put the Employee ID and Manager name in a new file.

Any assistance would be greatly appreciated!

[Brad_Groux · Accepted solution]

First, I would recommend steering clear of the Excel connectors due to their severe issues and limitations, if you can I'd highly suggest using SharePoint Lists. With that said, your desired Flow could look something like this:

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!