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 Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Top Solution Authors
Top Kudoed Authors
Users online (2,285)