Pull Email address from VSTS "Assigned To"

[LeviC]

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:

[v-yamao-msft]

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