How to Route SharePoint Approvals to the Correct Manager with Power Automate
Question details
Configure a Power Automate flow to dynamically route SharePoint item requests to specific managers based on the submitting employee.

- Product
- Microsoft Power Automate
- Device & OS
- not provided
- Scenario
- Automating the approval process for employee submissions, such as vacation requests, directly from a SharePoint list.
- Observed behavior
- The user wants the system to automatically identify the submitter's manager and send them an Outlook email or approval request instead of manually assigning the approver.
Ensure you have active Microsoft 365 credentials with access to Power Automate, and that you have edit permissions for the target SharePoint list.
Retrieve the Manager Automatically via Microsoft 365 Users
This is the most efficient method if your organization's Active Directory is fully populated, allowing you to dynamically pull the employee's manager directly from Microsoft 365.
By utilizing the Microsoft 365 Users connector, Power Automate can look up the organizational hierarchy and find the manager associated with the person who created the SharePoint list item.
In Power Automate, create an automated cloud flow. Select the 'When an item is created' trigger for SharePoint, and connect it to your Site Address and List Name.
Add a new action and search for 'Get manager (V2)' under the Microsoft 365 Users connector. In the 'User (UPN)' field, insert the 'Created By Email' dynamic content from your SharePoint trigger.
Add another action to either 'Start and wait for an approval' or 'Send an email (V2)'. In the 'Assigned to' or 'To' field, select the 'Mail' dynamic content originating from the 'Get manager (V2)' step.
Save the flow and submit a test item to your SharePoint list to verify that the email or approval request correctly arrives in your manager's inbox.

Map Managers Using a Condition or Lookup List
Use this approach if your organization does not use the Microsoft 365 manager field and instead relies on custom mapping.
Looking for a Lightweight, Free Alternative for Office Documents?
While Microsoft Power Automate is excellent for complex enterprise routing, WPS Office provides a free, highly compatible, and lightweight suite for your everyday document creation, editing, and collaboration needs. Enjoy a familiar interface and seamless compatibility without the heavy subscription costs.

Frequently Asked Questions
Why does the Get Manager action fail in Power Automate?
The 'Get manager (V2)' action will fail if the user's profile in Microsoft 365 (Azure Active Directory) does not have a manager officially assigned. The IT administrator must update the user's Active Directory profile to resolve this.
Can I send an Outlook email instead of a formal Approval request?
Yes. You can simply replace the 'Start and wait for an approval' action with the 'Send an email (V2)' action from the Outlook connector, and insert the dynamically retrieved manager's email into the 'To' field.
How do I handle requests from users who do not have a manager assigned?
You can configure the 'Run after' settings on the step immediately following the 'Get manager' action so that it continues even if the step fails. Alternatively, use a Condition block to verify if the manager field is empty, routing those specific requests to a default HR or administrator email.




