Answered

power automate approval flow lookup

(0) Share

Report

Posted on by LH-23071616-0

I have created a workflow that will trigger an approval/reject email to be sent when a new item is created in a sharepoint list. What i need to add to this flow is the ability to email a person based on variables.

I want the person emailed to be the manager of the "employee name" that is in the new row created on the list. Can anyone help me with how to accomplish this? Below is a screenshot of current flow.

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Sort by

srApps 306 on at

Like
a
(0)

Report
Copy link

Link copied!

Is the 'employee name' a person column? If so you can use the dynamic content to get that person's email address and use it in the 'Get manager (V2)' action. Then assign the approval to the email from the get manager dynamic content.

Was this reply helpful? Yes No
LH-23071616-0 87 on at

Like
a
(0)

Report
Copy link

Link copied!

It’s not a person column. I have a power app form that gets filled out and pushes to this list, and I couldn’t get the column as a person to populate correctly so I changed it to just text.

is there another way to accomplish this?

Was this reply helpful? Yes No
srApps 306 on at

Like
a
(0)

Report
Copy link

Link copied!

Ah. There is another action called 'Search for users (V2)' that you could put the name in to find their email, then their manager with that action. This would be prone to errors though, like multiple employees with the same display names or the name being spelled incorrectly in the form. These would result in either multiple users returned from the search or none. I would recommend trying to go back to making it a person field to not need to worry about those things.

Was this reply helpful? Yes No
LH-23071616-0 87 on at

Like
a
(0)

Report
Copy link

Link copied!

Got it! Could you send me a screen shot of what the branching for that would look like?

Was this reply helpful? Yes No
Verified answer

srApps 306 on at

Like
a
(1)

Report
Copy link

Link copied!

Sure. Based on your screenshot it would look like this. 'Search for users' dynamic content would be your 'employee name'. Even if it only returns one user, it will be an array. For the 'Get manager' I use the 'First' expression to get the first email address in the 'Search for users' array:
first(outputs('Search_for_users_(V2)')?['body/value'])?['userPrincipalName']
Then for the assigned to use 'Mail' from the 'Get manager' dynamic content.

Was this reply helpful? Yes No