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: th-cam.com/video/MIDb3GOY1xI/w-d-xo.html
@@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 TH-cam for help. I have been following you for a year. And congratulations on your new job.
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: th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
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 🇹🇭
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): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
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 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!
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
@@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.
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
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.
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): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
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?
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): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
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.
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?
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: th-cam.com/video/_QRI-Yo2h8U/w-d-xo.html Have a great day. Kind regards, Anders
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?
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: th-cam.com/video/_QRI-Yo2h8U/w-d-xo.html Have a great day. Kind regards, Anders
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.
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): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
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): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
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): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
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: th-cam.com/video/_QRI-Yo2h8U/w-d-xo.html Have a great day. Kind regards, Anders
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: th-cam.com/video/MIDb3GOY1xI/w-d-xo.html
This is amazing! I can imagine thousands of posibilities using excel scripts!
I'd like to give you one hundred of likes for your explanation :)Thanks a lot !!!!
Thank you so much, Anderson 🙌😍
Very good Anders.. keep them coming..
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
@@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 TH-cam for help. I have been following you for a year. And congratulations on your new job.
You're a Machine Bro, Thank You!
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: th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
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 🇹🇭
Hey bootsai. Wauw, thanks for the thrust 😍👍 I will do my best to not dissapoint you here 😀 Kind regards, Anders
Hi from Brazil, nice video
Thanks a lot, Bruno!
Great content Anders and very useful! Thank you!
Thanks a lot, David Quezada 🤗 Your feedback helps me immensely. Kind regards, Anders
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
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): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
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!
My pleasure. You're almost there 😀 Try this: ^[26]\d{10}$ Kind regards, Anders
@@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!
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?
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
@@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.
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
Love this!
Thank you so much, Nickson 🙏
Thank you very much for the great video!
My pleasure, thanks a lot for letting me know 🙂
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.
Great. And I agree. I will put it on my list of to-dos 👍🙂 Have a great day. Kind regards, Anders
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?
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): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
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?
Hey Nathan - yes it's a premium (business) feature 🙂 And yes again, you can easily RegEx parse in Power Automate Desktop. Kind regards, Anders
Can you do this with Outlook instead of excel to use regex to categorize incoming emails to sub folders??
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): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
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.
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?
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: th-cam.com/video/_QRI-Yo2h8U/w-d-xo.html Have a great day. Kind regards, Anders
Manual answer: use this patter [0-9]{6} 😀
Hi is this Regex can also be used on Uipath? Or is there difference?
Hey Nine. Yes, it's an important part of UiPath: th-cam.com/video/AV59DqhJa38/w-d-xo.html Check this use case. Kind regards, Anders
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?
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: th-cam.com/video/_QRI-Yo2h8U/w-d-xo.html
Have a great day.
Kind regards,
Anders
Anders, i need more UiPath videos to upgrade my career. 😁😁😁
Haha, thank you, Larry, I'll promise from next week, they will come (I will do this full-time) 😀
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.
What happens if the office scripts exceeds 400 it will work or it will ask any amount
Hey they raised the limit to 1600 per day. And yes 🙂
top stuff!
Thank you 👍🙏
how can i do this in power automate desktop?
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): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
Any free solution for those that don't have the office 365 business subscription and don't have access to tthe excel scripts connector?
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): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
Is this still relevant? Are there any alternatives by now?
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): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
Says flag is required - but what if we don't want a "g" flag and only want the first one?
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: th-cam.com/video/_QRI-Yo2h8U/w-d-xo.html
Have a great day.
Kind regards,
Anders
1:30
?
"These features require an account for work or school and you have a personal email."
Hey Chris. Which of the actions are you trying? Kind regards, Anders
@@andersjensenorg Run script
absolute bs that you have to go to this extreme to run a simple regex expression in Power Automate though, omg
This can't be the way to do this. Just more evidence that power automate is ass.