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

(0) Share

Report

Posted on by Community Power Pla...

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"

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

MattWeston365 1,701 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

it would be helpful to have regex action ,

Was this reply helpful? Yes No
Suggested answer

Matkje 22 on at

Like (0)

Report

RegEx is available in Power Automate now. Luckily. So this problem should be fairly easy to handle now - at least the first part of your problem.

How to | Use RegEx to extract information from text files using Power Automate

Best regards

Mathias Kjeldsen

Was this reply helpful? Yes No