In a MS form, we a drop don list of persons eg:
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 firstname.lastname@example.org
You could put the person email into the Assigned to parameter directly as below:
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.
@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.
Hi @slewis1972 so here is what I came up with
Data I used (Users) in CRM and MS forms drop down
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 -
Hope this helps !
If this resolves your issue please mark this post as answered and hit me a thumps up.
Thanks and Regards,
Screen shot of the flow for your reference
also the fetch XML query -
<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">
<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" />
<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
Keep up to date with current events and community announcements in the Power Automate community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!