How to use RegEx in Microsoft Power Automate (Full Tutorial)

This video tutorial shows how to use RegEx (Regular Expression) in Microsoft Power Automate. First, how to use the free solution by creating a simple Office Script in Excel online, which we can call from Power automate. Second, how to use an automated connector (Plumsail).

Unless you need more than 400 RegEx calls per day, you should go with the Office Script solution, where you create a RegEx script (written in TypeScript, which is a superset of JavaScript) and call it from Power Automate. A considerable advantage is that this solution is 100% free.

If you work in a large company/enterprise, you need a paid RegEx solution like Plumsail. It's drag and drop in Power Automate and therefore very easy to work with as well.

LINKS:

FOLLOW ME:

🖥️ My monitor

0:00 Intro

4:04 How to use Regex for FREE in Power Automate

10:29 Extract strings from an array in Power Automate
We use an 'Apply to Each' to extract all strings from an array in Power Automate. To extract a specific item in an array, we'll use an expression - outputs('Run_script')?['body/result'][0] for the first string and outputs('Run_script')?['body/result'][1] for the second string etc.

15:52 Unlimited RegEx extractions in Power Automate
We use the connector Plumsail to use RegEx in Microsoft Power Automate if we want more than 400 RegEx extractions per day.

#powerautomate #microsoftpowerautomate #office365

[DavidQuezada]

Great content Anders and very useful! Thank you!

[nathanmora]

You're a Machine Bro, Thank You!

[bootsai]

im yr Udemy student on 2 UiPath courses, im excited on yr new journey. i will support and can't wait for further VDO series about RPA things. Keep going man. 🤓 student from Thailand 🇹🇭

[andersonsarria]

I'd like to give you one hundred of likes for your explanation :)Thanks a lot !!!!

[JY-niid]

Thank you very much for the great video!

[dexterlee]

Hi thanks for sharing just want to check if we don't need plumsail and excel script for Power Automate Regex now? in 2023 end|
Thank you

[ISOEditGD]

The difficult part for me using MS PAD is to create a dynamic/custom selector. Please give it a try as there is less video from YT regarding this so far and its hard to follow.

[nikosthe]

I saw a video you made about getting values from a excel files and use those terms to search for data, but how can you get data from website if you already have the url's in a excel file? I have a excel file with one column and all url's I need, and I want to read every Url from that file add some delay to open the page (to make sure is loaded), get the data and then move to next url, and when every url is done save it in a excel file. Do you have any video that can cover that scenario? I searched but I didn't find anything. And how can I add the url to first column so I know what page the data are from?

[travisstrah]

Thank you Anders! This has provided many more options for me. I am having trouble with the regex pattern trying to match an 11 digit number that starts with 2 or 6. ^(2|6)\d{10}$ It doesn't like this pattern. Do you know how I can get it to filter out these numbers? I am currently using [0-9]{11}. Thank you!

[olajumokeodofin]

Can you do this with Outlook instead of excel to use regex to categorize incoming emails to sub folders??

[Juggler]

Hi Anders. So if I understand correctly you use Excel scripts to find the matches because there's no such activity built into Power Automate?

[loyfivi]

After providing file information for RUN SCRIPT, I did not have the 3 new entry locations as you do. (Input String, Pattern, Flags) Do you know why?

[nathanmora]

Are you using Power Automate Premium in this example? Can this be done through Power Automate Desktop for create new flow and build a sequence of activities?

[larryding]

Anders, i need more UiPath videos to upgrade my career. 😁😁😁

[ninecrowns]

Hi is this Regex can also be used on Uipath? Or is there difference?

[drkmccy]

Hi, brilliant vid! I managed to get it working and pull a 6 digit character using this this pattern:
Not sure if that's the 'proper' way to do it? or if there's a more efficient way?

[Entertainment-zbhv]

What happens if the office scripts exceeds 400 it will work or it will ask any amount

[vusuxek]

how can i do this in power automate desktop?

[wingtracer]

Says flag is required - but what if we don't want a "g" flag and only want the first one?

[dafinstruct]

"These features require an account for work or school and you have a personal email."