cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
johns4Upmc
Frequent Visitor

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 @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:

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 !
johns4Upmc
Frequent Visitor

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

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Users online (3,365)