cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

AllSearch and update Azure DevOps work item from email

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

2 REPLIES 2
gabibalaban
Dual Super User
Dual Super User

Hi @Anonymous ,

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

Well, you can achieve this using something like:

Capture.PNG

 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 !
Anonymous
Not applicable

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

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (3,831)