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
User | Count |
---|---|
73 | |
50 | |
48 | |
27 | |
18 |
User | Count |
---|---|
27 | |
27 | |
25 | |
20 | |
19 |