AllSearch and update Azure DevOps work item from email

[johns4Upmc]

Dear All,

I am working on a flow that should be triggered when an email arrives. I need to search for the work item in Azure Devops with the Subject line as Title excluding RE: or FW: and once the work item is retrieved, update the History section with the latest comments.

Can someone please help me with this?

Thanks and Regards,

Shyju John

[gabibalaban]

Hi @johns4Upmc ,

So basically you need to get rid of RE: and FW: from the email's subject ...

Well, you can achieve this using something like:

 Where in first action formula is:

substring(triggerOutputs()?['body/subject'],3,sub(length(triggerOutputs()?['body/subject']),3))

and should be used if you are sure that the email's subject you are interested on, contains a single appearance of "RE:" or "FW:"

if not use the second formula:

replace(replace(triggerOutputs()?['body/subject'],'RE:',''),'FW:','')

which removes all appearances of "RE:" and "FW:" from the email's subject.

Regarding the AzureDevOps, unfortunatelly I don't have an organisation and everything else to help you.

Hope it helps !

[johns4Upmc]

@gabibalaban Thank you so much for the response. This helps.