cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

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

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/20199:03 AM313.235.359900012345

 

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!

1 ACCEPTED SOLUTION

Accepted Solutions
Super User II
Super User II

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: UpdateExcelFromOffice365Users.PNG

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!

View solution in original post

1 REPLY 1
Super User II
Super User II

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: UpdateExcelFromOffice365Users.PNG

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!

View solution in original post

Helpful resources

Announcements
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Microsoft Ignite

Microsoft Power Platform: 2021 Release Wave 1 Plan

Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (20,478)