Check E-Mail subject with RegEx (check two mails)

[Anonymous]

Hi

I need a flow that check the E-Mail subject for a specific substring like this "Nr. 123456789". I have this RegEx:

(Nr.\s1\d{8}):

https://regexr.com/4i2v1

In my case it will be have always two mails with the same number (Nr. 123456789) but not the same subject-string.

But i can't use RegEx on MS Flow? Is there another way? The Flow dont must work with trigger like "incomming mail", it can be scheduled flow or a button flow

The second problem that i have is, that i must check the second mail with the same number. Which way is better to solved this problem? Trigger the flow by every incoming mail, or check every 5min all mails to find the two mails with the same number...

I hope someone can help me at least for the RegEx

example for the subject:

Mail 1 subject = "Lorem ipsum Nr. 100448899 dolor sit amet"

Mail 2 subject = "At vero eos et accusam Nr. 100448899 no sea"

[MattWeston365]

Hi @Anonymous 

I answered a similar question a few weeks ago where were trying to isolate a particular string pattern within the bod of the email. You could follow something similar to get the same from the Subject:

https://powerusers.microsoft.com/t5/Building-Flows/Creating-Email-Reply-Flow-to-post-item-to-a-SharePoint-List/m-p/311867#M33180

Basically what we did was get the index of a specific character patter e.g.  "Nr. " and then slowly reduce the string until we'd isolated the exact text that we wanted.

Let me know if you need any more help with this

[Anonymous]

Hi MattWeston365

But that will not help me to find the second Mail, and i dont want to extract i will match, or did i understand something wrong in your post?

Thx for the help

[RenzoTello]

it would be helpful to have regex action  ,