cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
slewis1972
Helper I
Helper I

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

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

8 REPLIES 8
v-litu-msft
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.

ViditGholam
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.

ViditGholam
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

ViditGholam_0-1617210623449.png

CRM Screen shots -

ViditGholam_1-1617210760260.png

 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

ViditGholam_2-1617210909471.png

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

Fetch XML Query - 

ViditGholam_3-1617210999049.pngViditGholam_4-1617211040027.png

Step 3 - list all the users using list row connector 

ViditGholam_5-1617211120568.png

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)

ViditGholam_6-1617211193966.png

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
ViditGholam_7-1617211299014.png

Output - 

ViditGholam_8-1617211359343.pngViditGholam_9-1617211393084.pngViditGholam_10-1617211423415.pngViditGholam_11-1617211458385.png

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
Continued Contributor
Continued Contributor

Screen shot of the flow for your reference 

ViditGholam_0-1617211733504.png

 

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

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

Announcements
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,426)