I am creating a flow that notifies users if their assigned VSTS work item has not been touched for more than 7 days.
I have created a flow action that pulls a VSTS query result for work items not touched in 7 days.
I want to send an email to the person that the work item is assigned to. The output of 'Assigned To' is in this format: FirstName LastName <email@microsoft.com>. The Send an email action does not understand this as an input. How can I take the "Assigned To variable and only return the email address?
Here is the flow:
Hi @LeviC,
Do you want to get the email address from the output of Assigned to in format “FirstName LastName <email@microsoft.com> “?
Please try the following flow configuration.
In my testing flow, it is triggered by a button.
Add a Compose action, get the start position of the actual email address:
add(indexOf(triggerBody()['text'],'<'),1)
Add a Compose2 action, get the last position of the actual email address:
add(indexOf(triggerBody()['text'],'.com'),4)
Add a Compose3 action, get the actual email address:
substring(triggerBody()['text'],outputs('Compose'),sub(outputs('Compose_2'),outputs('Compose')))
I have made a test on my side and it works fine.
Please try it on your side.
Best regards,
Mabel Mao
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
User | Count |
---|---|
41 | |
40 | |
37 | |
34 | |
30 |
User | Count |
---|---|
48 | |
37 | |
35 | |
26 | |
24 |