Showing results for 
Search instead for 
Did you mean: 
Post Prodigy
Post Prodigy

Match subject line against existing list item and update with body text



I have a flow where a user receives an email when their email has been added to a SharePoint list.

In the email their ticket number is confirmed in the email body and the subject line [WFM-2] where 2 = list ID number.


Is there a flow action that if the user replies to the email where it would check the subject line and see that [WFM-

already exists and then matches the number against the existing list item and copies the reply response into a text field in the SharePoint list? Rather than having a new ticket created.


See my current flow below - which is not working.









Hi there.  Short answer: "Yes".  But a couple of questions first:

  • If we want to avoid replies creating new tickets, have you considered filtering out emails where the subject starts with RE:?
  • Assuming we still want the text from the reply once we found the matching SP Item, how do we handle if there is already text in that field?  Append? Replace?

If you are still moving forward...My suggestion - 

  • When the email comes in, parse the subject line into two bits using Split() - and store the WFM and the 2 in two different Compose actions.
  • Use the first part in a Switch action, to check the appropriate list using a List Items action filtering on the second Compose from your subject line.
  • Use Configure Run After to add the line if no match is found.
  • If a matching item is found, store the existing comments in a third compose so that when you grab the body of the email, you can update the text field with the original comments followed by the new text from the email.

I think that should get things started.  Let us know what you think.



If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

Hi @edgonzales (Ed),


That sounds good using Re: in the subject line.


I'm still a novice flow creator.


Please could I get some visual pointers on how to set that up if possible?


Thanks (:

Helpful resources

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 tips 768x460 v2.png

Restore a Deleted Flow

Did you know that you could restore a deleted flow? Check out this helpful article.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Users online (3,379)