Kind of regex

(0) Share

Report

Posted on by Default

Hi,

I would like to create a flow that checks if there is a string in the subject of an e-mail message. That string always looks like this: Mnnnn nnnn, and n are digits from 0 to 9, e.g. M1234 9876.
I can get this done in Regex, and I see examples with a regex function in Office scripts, but I would prefer to do it entirely in PowerAutomate.

Is that possible?

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

Sort by

grantjenkins 11,063 Moderator on at

Like (1)

Report
Copy link

Link copied!

If it was me, I'd definitely be using an Office script. I have an Excel file setup centrally in our company (Power Platform Portal - SharePoint site) and everyone has read access to it so they can leverage it in their flows. It contains quite a few scripts that are useful and tightly controlled so as not to affect flows that use it.

There are third-party connectors out there that allow you to do regex within the flow.

I'm sure you could do it using the standard connectors (without regex) but likely some ugly hacky expressions to get what you want. I can see what I can come up with.

Was this reply helpful? Yes No
Suggested answer

Matkje 22 on at

Like (0)

Report
Copy link

Link copied!

Hey

You can do this by using Parse Text function in Power Automate. That allows RegEx as input. Explained in below video.

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

Best regards
Mathias Kjeldsen

---
If this has helped solve your problem, please mark it as an helpful answer.

Connect with me on social platforms by using the links below.
YouTube: https://www.youtube.com/@matkjeldsen
LinkedIn: https://www.linkedin.com/in/mathiaskjeldsen/

Was this reply helpful? Yes No