Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

MS form person field, convert to email address for approvals on flow?



In a MS form, we a drop don list of persons eg:

Jow Bloggs


That person is a person in company. In the flow, I want it to select that field selected, convert to email address and then sent to approvals. How do I do this when its not in full format like



Community Support
Community Support

Hi @slewis1972,


You could put the person email into the Assigned to parameter directly as below:

Screenshot 2021-03-31 155330.jpg


Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

So, will the flow automatically link up the entry in the field with whats in 365 as long as its in the same format as the visable name eg Jow Bloggs?


We would rather not have the email address in the drop downfield in the form.

Continued Contributor
Continued Contributor

@slewis1972 Hi so I wanted to ask you the drop down list you mentioned and the users in that list are the users in your D365 CRM ??

Yes. All under the tenant.

Continued Contributor
Continued Contributor

Hi @slewis1972 so here is what I came up with 


Data I used (Users) in CRM and MS forms drop down

Vidit Gholam 

Ethan Rebello


MS forms Screen shot - Here I have a Drop down of 2 People which are users in my CRM


CRM Screen shots -


 Here is how the flow goes (User same Connectors which I used I haven't Purposely renamed them so that it is easy for you to find the connector ) 

Step -1  the flow triggers when a response is submitted and will get the details of the response as show in the below Screen shot


Step 2 - get users from CRM whos full name contains the name entered in the MS forms Option set.

Fetch XML Query - 


Step 3 - list all the users using list row connector 


Check  empty condition i.e. are there any users present in the CRM as the selected option in the MS drop down.(we need to Null check cus if  it is null then the flow might fail)


Empty query - 

Step - 4 now just get the users primary ID and send an approval to him in the Yes Section of the condition

Output - 


Hope this helps ! 

If this resolves your issue please mark this post as answered and hit me a thumps up.

Thanks and Regards,



Continued Contributor
Continued Contributor

Screen shot of the flow for your reference 



Continued Contributor
Continued Contributor

also the fetch XML query - 

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">
<entity name="systemuser">
<attribute name="fullname" />
<attribute name="businessunitid" />
<attribute name="title" />
<attribute name="address1_telephone1" />
<attribute name="positionid" />
<attribute name="systemuserid" />
<attribute name="internalemailaddress" />
<attribute name="lastname" />
<attribute name="firstname" />
<attribute name="personalemailaddress" />
<order attribute="fullname" descending="false" />
<filter type="and">
<condition attribute="fullname" operator="like" value="(User Name from the MS form )" />

Apologies, some confusion, they are not in Dynamics, they are just in the tenant.

I am struggling to link in the field they select for name and conversion to email address

Helpful resources

Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (2,687)