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

[slewis1972]

Hi

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 jow.bloggs@company.com

Thanks

[v-litu-msft]

Hi @slewis1972,

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

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.

[slewis1972]

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.

[ViditGholam]

@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 ??

[slewis1972]

Yes. All under the tenant.

[ViditGholam]

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 - 

empty(outputs('List_rows')?['body/value'])

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,

 Vidit

[ViditGholam]

Screen shot of the flow for your reference 

[ViditGholam]

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 )" />
</filter>
</entity>
</fetch>

[slewis1972]

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