Forum Discussion
How to assign manager to approval based on result of item details
needs_help if you have a column in your SharePoint list that holds the user's email address or Display Name (I always use the email address) then in your flow you can add an Office 365 Users action called Get manager (v2) to get their Manager. For the user input for that you select the Email column from the dynamic content box. You can then use the output of that in the Assigned to field of the Start and wait for an approval.
So no-one needs to select anything, it all works automatically based on the user's email address in the relevant column.
However, if you want to assign the approval based on, for example, a department column like IT or HR or Marketing then the way I do it is to have a separate list that holds the approver(s) for each department. Then the flow looks up the appropriate approver based on the the department selected in the list. But that's a different flow to the one above but if you need the steps for it let me know.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
RobElliott Could you also send me the workflow you describe?