Finding email address based on selected name in Microsoft Form

(0) Share

Report

Posted on by werdnak

Hi there,

I am a newbie to MS Power Automate so I hope someone can help me.

I created a Microsoft Form, and one of the questions provided a list of managers for approval.

I would like to be able to send an email approval to the manager selected from the list.
I tried the following using Search for User (V2) but it doesn't work. Can someone help? Many thanks in advance.

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

efialttes 14,756 on at

Like (0)

Report

Hi!

'and one of the questions provided a list of managers for approval'

How is this list of managers currently defined in your form? Is it a list of email addresses and the user just picks one, or a list of (first name + sure name), other? Also, did you activated multichoice on the question?

If possible, please share a screenshot from 'Get response details' output so we can clearly see what's inside the response

Thanx!

Was this reply helpful? Yes No
werdnak 56 on at

Like (0)

Report

Hi @efialttes ,
The list of manager is a drop down list of specified names (e.g. John Doe, Jane Doe). User of the form cannot select multiple names. They can only select one name from the drop down list.
I provided the outputs below. I highlighted in yellow the name of the manager (based on the selection of the user).
Based on the yellow field, how do I get the email address and put that in the Assigned To field in Start and Wait for an Approval.
Note I also masked the personal information in black.
Thank you so much.

Was this reply helpful? Yes No
efialttes 14,756 on at

Like (0)

Report

Hi!

Just to get sure how is Andrew related info currently stored in your Tenant, do you have its email address? If so, create a manual dummy flow and add 'Get user profile v2' assigning Andrew email address as its input and execute it. This way you can inspect the way personal info is structured on your tenant and figure out why 'Search for users' fails

Hope this makes sense

Was this reply helpful? Yes No
werdnak 56 on at

Like (0)

Report

Hi @efialttes ,

There is no issue with Search for Users (V2) function.

The issue that I have is I am not sure how to convert the output from Search for Users (V2) -'UserPrincipalName' and put that into the 'Assigned Field' in Start and Wait for an Approval. I provided the screen shots (both the flow and outputs from Search for Users (V2)) below if you could assist. Many thanks.

Was this reply helpful? Yes No
efialttes 14,756 on at

Like (0)

Report
Hi!

Understood. Two comments:

1.- 'Search for users v2' output is an array of 0..n elements, I believe when executing 'Search for users' you always expect a single match, right?

2.- I am assuming the email address is stored under 'Email' property in each 'Search for users v2' output element, if not just try with UserPrincipalName instead

Please note on Select action block you need to switch input mode (click on the icon on the right)

Now, the WDL expressions inside are:

length(body('Search_for_users_(V2)')?['value'])

and

join(body('Select_MatchingEmails'),';')

Hope this helps

Was this reply helpful? Yes No
werdnak 56 on at

Like (0)

Report

Hi @efialttes ,
There is only a single match to the Search for Users (V2).
I still have the same problem as before. Following your guidance, I still receive an error message. Let me show you the flow and outputs. Note that our email address is the same value as the User Principal Name. I tried both and it still returns same error. I suspect that the join(body('Select_3'),';') is returning the following output [s.kong@XXX.edu.au] - with bracket. That is why it cannot find the user - but I don't know how to verify this. 😞

Condition 1: length(body('Search_for_users_(V2)')?['value']) - No issue here
Select 3: - No issue here
From : Value
Map: UserPrincipalName: UserPrincipalName
Start and wait for an approval 2: Issue
Assigned To: join(body('Select_3'),';')

FlowError Output

Was this reply helpful? Yes No
Verified answer

efialttes 14,756 on at

Like (1)

Report

@werdnak

I would suggest to add a dummy 'Compose' action block just before 'Send an email', assign as its input the join() based expression, reexecute the flow and inspect its outputs. This way you can verify its result

If there is a single email address, then it looks like a provisioning problem on the Azure AD

Hope this helps

Was this reply helpful? Yes No