Power Automate Approval form

(0) Share

Report

Posted on by Leak

Hello

I have a Microsoft form that in the form required users that submitted need to choose their report line manager name.

I would like to set up Power Automate run to their line manager for approval or decline when a new response is submitted.

Example:

One user select drop down in the form selects "Bob" as his line manager, Bob will get this response by email and ask for his approval.

but if the user select drop down in the form and selects "Sara" as his line manager, Sara will get this response by email and ask for his approval.

And I'm as owner of form will has approval status in one drive excel, like" Approval, Declined, Pending"

May you please help and advice I tried to set up many time but it failed ?

Categories:

Using connectors

I have the same question (0)

All responses (9)

Answers (0)

trice602 15,402 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Leak ,

I have a similar flow in my sandbox and wanted to share with you. In this example, instead of using Windows Get Manager, I simply ask the question on my form 'Enter your manager's email address'. Next you simply put the response of the manager's email address in the approval action step shown below.

This form only has two questions for testing purposes but you can see the "Assigned to is the manager's email address provided on the form entry.

Please give this a try and let me know if this works for you. To test, add your email as the approver to see it in action! Always glad to help! Tom

Was this reply helpful? Yes No
trice602 15,402 Super User 2025 Season 2 on at

Like (0)

Report

Also note: if you wanted to use a dropdown question in your form as Bob, Sara, John, Tim, etc, you can use the switch condition and switch 'Bob' to Bob's email address. I've just found it easier for the person filling out the form to provide their manager's email address -- they absolutely know it by heart and typing it in hasn't been an issue in production. Tom

Was this reply helpful? Yes No
Leak 26 on at

Like (0)

Report

Hello Mr.Tom

Thank you for you input, May you help show me how to switch condition and switch 'Bob' to Bob's email address. ? I'm totally new to power automate
My form is drop down for user to select their line manager instead of provide input

Was this reply helpful? Yes No
trice602 15,402 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Leak ,

Here's a sample mockup (also note there are lots of ways to do this). Here in this example, I initialize a MgrEmail variable and then in my Switch control, I set the value to each case's email address based on the dropdown selection.

Let me know if this helps! Please mark as a solution and give me a thumbs up - always glad to help! Tom

Was this reply helpful? Yes No
Leak 26 on at

Like (0)

Report

Thank you Mr. Tom this worked, but if I want the user that filled in form get information about his line manager approval or reject? how to set up that

and how myself as owner of form get information about the approval or reject in update in form excel one drive ?

Was this reply helpful? Yes No
trice602 15,402 Super User 2025 Season 2 on at

Like (0)

Report

You can specific the recipient to get the approval or reject and the comments. You can also add this to Excel as needed. You can see the approvals in Teams. I recommend you try this as yourself as an approver to see it in action. Let me know if this works for you - please mark as a solution to help others find it too! Always glad to help! Tom

Was this reply helpful? Yes No
Leak 26 on at

Like (1)

Report

Mr.Tom, so we can track request approval status only by team per submitted. How to get as report like this ?

Was this reply helpful? Yes No
Leak 26 on at

Like (0)

Report

and if manager approved the request, user submitted get an update on that his line manager approved by outlook email? May you help guide me on how to set up that?

I tried to applied condition "Yes/No" but not work properly.

Was this reply helpful? Yes No
Leak 26 on at

Like (0)

Report

and if I want to set up letting users submit forms get an email outlook to notify whether his line manager is "Approved or Declined"? how to set up that?

Was this reply helpful? Yes No