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

[@andersjensenorg]

Thanks a lot for watching. If the video helps you, you can help me (and make me happy), if you give it a thumbs up 👍🙂 This is Power Automate, to learn it from the beginning, check this: kzbin.info/www/bejne/g3qnk2Z9hL5krqs

[@sacc19]

This is amazing! I can imagine thousands of posibilities using excel scripts!

[@andersonsarria1302]

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

[@andersjensenorg]

Thank you so much, Anderson 🙌😍

[@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 🇹🇭

[@andersjensenorg]

Hey bootsai. Wauw, thanks for the thrust 😍👍 I will do my best to not dissapoint you here 😀 Kind regards, Anders

[@nathanmora9734]

You're a Machine Bro, Thank You!

[@andersjensenorg]

Thanks a lot, @nathanmora9734 🤗 Your feedback helps me immensely. You're more than welcome at my Discord, where we're 8000+ RPA developers networking and solving problems: kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@kujodk]

Very good Anders.. keep them coming..

[@andersjensenorg]

Thanks a lot, kujodk - let me know, if you have any feedback for the content (I'm in a position, where I want to improve) 🙂 Kind regards, Anders

[@kujodk]

@@andersjensenorg I do have suggestions, will post them later. I work at a large DK company. Where we used Process Robot before and now Power Automate. And we do have very specific ideas and needs. So we often look at KZbin for help. I have been following you for a year. And congratulations on your new job.

[@bunorr]

Hi from Brazil, nice video

[@andersjensenorg]

Thanks a lot, Bruno!

[@DavidQuezada7]

Great content Anders and very useful! Thank you!

[@andersjensenorg]

Thanks a lot, David Quezada 🤗 Your feedback helps me immensely. Kind regards, Anders

[@travisstrah4567]

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!

[@andersjensenorg]

My pleasure. You're almost there 😀 Try this: ^[26]\d{10}$ Kind regards, Anders

[@MauiBoyTrav]

@@andersjensenorg I have a feeling these characters are not translating well because this isn't working, and when I look at the code after, it puts 2 slashes in front of the d. (//d) I really appreciate this solution and it's helpful regardless, I just wish I could get it only match if the first number is a 2 or a 6. Thanks again for sharing Anders!

[@dexterlee1199]

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

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 10,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@JY-ni7id]

Thank you very much for the great video!

[@andersjensenorg]

My pleasure, thanks a lot for letting me know 🙂

[@ChelanThomas]

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?

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 11,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@Juggler707]

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?

[@andersjensenorg]

Hey Juggler707. Exactly. You will find built-in activities in Power Automate, but they are on a subscription basis ($$) 😏Office scripts also let you customize it very quickly. Let me know if you have more questions - you can even send me a DM on LinkedIn. Kind regards, Anders

[@kujodk]

@@andersjensenorg another idea to get around license either from Power apps or Automate is to use SharePoint list as triggers between apps, Automate and Desktop. Then it stays as standard license compared to premium.

[@andersjensenorg]

Nice, I haven't tried it (yet), but one of the next steps on my list is to make a series of Power Apps videos 🙂 Have you done it yourself? Thanks for the feedback. Kind regards, Anders

[@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.

[@andersjensenorg]

Great. And I agree. I will put it on my list of to-dos 👍🙂 Have a great day. Kind regards, Anders

[@nicksonkoh]

Love this!

[@andersjensenorg]

Thank you so much, Nickson 🙏

[@nathanmora9734]

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?

[@andersjensenorg]

Hey Nathan - yes it's a premium (business) feature 🙂 And yes again, you can easily RegEx parse in Power Automate Desktop. Kind regards, Anders

[@Outsider1233]

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

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 12,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@FlowerBot]

the idea is you just keep an Excel file to hold the script, Excel is doing nothing else. You can have the flow do anything else you want it to. In fact you don't even need to create the Excel file but its nice for the sake of other people in your org who might want to find it or reuse it later. You have to open Excel to write and save the script though. You have to run the Power Automate flow with your own permissions (!) - because its stored on your OneDrive and nobody else can access it from Power Automate unless you do this. You can't store a script in a centralised location which will run. Its total bs. Any file you save will be 'created' or 'modified' by you and not the user who runs the flow.

[@drkmccy]

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

[@andersjensenorg]

Hey Derek McCoy Thanks for writing. I'm getting more than 50 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/lYK1emCPpJebbrc Have a great day. Kind regards, Anders

[@andersjensenorg]

Manual answer: use this patter [0-9]{6} 😀

[@WitheredGreenThumb-kf4db]

Yeah okay, better than splitting the body by ‘ ‘ and newline and searching for items with @. I got to get better with officescripts, especially logging info back into power automate. That’s a hill. Also, Chat GPT isn’t too bad at writing Regex. Makes it fun.

[@nikosthe15]

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?

[@andersjensenorg]

Hey nikos Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/lYK1emCPpJebbrc Have a great day. Kind regards, Anders

[@ninecrowns871]

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

[@andersjensenorg]

Hey Nine. Yes, it's an important part of UiPath: kzbin.info/www/bejne/d4eYanenna-UaZo Check this use case. Kind regards, Anders

[@kosamuki]

Any free solution for those that don't have the office 365 business subscription and don't have access to tthe excel scripts connector?

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 13,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@Entertainment-zb3hv]

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

[@andersjensenorg]

Hey they raised the limit to 1600 per day. And yes 🙂

[@larryding7618]

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

[@andersjensenorg]

Haha, thank you, Larry, I'll promise from next week, they will come (I will do this full-time) 😀

[@bn_ln]

top stuff!

[@andersjensenorg]

Thank you 👍🙏

[@P19-h8f]

how can i do this in power automate desktop?

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 12,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@tablatronix]

Is this still relevant? Are there any alternatives by now?

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 13,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@wingtracer]

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

[@andersjensenorg]

Hey Sir Walter Bradford Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/lYK1emCPpJebbrc Have a great day. Kind regards, Anders

[@hater99]

1:30

[@andersjensenorg]

?

[@dafinstruct]

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

[@andersjensenorg]

Hey Chris. Which of the actions are you trying? Kind regards, Anders

[@dafinstruct]

@@andersjensenorg Run script

[@mattymattffs]

This can't be the way to do this. Just more evidence that power automate is ass.

[@FlowerBot]

absolute bs that you have to go to this extreme to run a simple regex expression in Power Automate though, omg