Anders Thanks much for a great & simple video ! Very detailed & clear ! Started watching your videos ! I've run into an issue the B'day col in my XL is of String type having 4 chrs of format DDMM ; so I guess this has to be substringed into the Day & Mon parts; I am getting a syntax error trying to code this in the 'Apply to each' part . Greatly appreciate if you can point me to any of your other videos, or if you could ps. help. Thx. in adv
Thanks a lot, autobase 16 🤗 Your feedback helps me immensely. You're more than welcome at my Discord, where we're 5800+ RPA developers networking and solving problems: th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
Thank you Anders for this video. It was very helpful :) The only issue I had when running the flow, it did not like the birthday column on the spreadsheet as a date so I made it a text column and the flow ran without issues.
Hey Julie. Nice - and thanks for the comment. What happened with the birthday column? Did you create it in Excel desktop or online/cloud? Kind regards, Anders
Would love if you could do a video on how to rename files based on their content (especially word docs and PDFs)! I know how to do this with AHK but many managed devices provided by employers hate open source software, so MS Power Automate is the go-to. Even just how to batch rename things (like add the date, or remove the word "Draft") would be so useful! Love your videos!
Hey Sarah MacDonald 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
@@andersjensenorg I followed along today using business ID, created the first flows successfully as it shown Status Test succeeded. But I didn't get the email (test). May be there is a delay?
Thank you Anders! This is a great video. It has helped me do new things already. I like that you added a bit of "coding" into the "low code" app as well.
Hey Dion. Great idea/question. I will definitely do so. I plan to do a "complete" Power Automate and Power Automate Desktop course. Either a big (around 10 hours) or divided into smaller pieces and collected in a playlist. The latter would be the easiest to make, but the other would be more popular. I will go into the box and come back with an answer to your question and PA/PAD in general. Kind regards, Anders
This is an excellent tutorial... however, I followed it precisely and could not get an email. The test and the live run went successfully so I was suspicious that the condition was not being met. After digging through the details of the flow run results, it in fact showed that the condition was false. I am wondering if the date/date serial number or something is the cause? I know you can't see my flow, but do you think this is the problem?
I changed the birthday in the Excel file to be a text string and it worked. So I will play around with the flow now to get the condition to work with the date serial numbers!
Hey Matthew, yes. You're right. I've actually made an extended video that solves, your problem. But it's used for a course review, so I can't make it public. If you want a TH-cam link, just write me on either LinkedIn or FB 🙂 Kind regards, ANders
Hey Kathryn Spader 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
Hey Dana Dy 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
Hey Josee Martel 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
I work as a digital marketer. Do you think it's possible for me to do a career change to a RPA developer? Or is it only for people with a programming background?
Hey Michael. Yes and no. Highly yes, if you have some "other" skill like documenting, interacting with people, understanding/optimizing processes etc. If you don't have any of these as well as no programming skills, you're behind and need to work. But since it's such a new area, the demand for RPA developers are huge. And "too" huge tbh. But that's great news for you and me :) I think the two most important skills are: The tool itself and people skills. Have you seen this: th-cam.com/video/qiOswPF-0TI/w-d-xo.html Kind regards, Anders
Hey udi karo 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
Hi Anders. You are recommending a book called "Workflow Automation with Microsoft Power Automate". It is 1 year old. Is it still the best choice and up-to-date?? I trust a lot has happened with Power Automate the last year.
Hey Ole. Great question. Yes, it's the best (and only choice), and although a lot has happened (mainly Power Automate Desktop), it's up-to-date. If you live close to Allerød (with that name, I suspect you're Danish?), you can come by my office and have my copy 🙂 Kind regards, Anders Ps. I plan to cover Power Automate extensively in the coming months.
Hi@@andersjensenorg Yes. I'm Danish. Thank you for your kind offer, but I live in Silkeborg, so I will prefer to buy my own book. I'm looking forward to your coming Power Automate serie. I hope, it will cover a situation where Power Automate in the cloud works together with Power Automate Desktop.
We are automating web application using power automate ...i wanna to Thank You as we are automating our scripts by seeing your videos ....I do have one query ..How run the all created flows in sequence order
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 6000+ 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
I am looking for a way to create a tool which automatically takes employees' information from our company's intranet (which is SharePoint-based) and inserts the data into table cells in a Word template in order to build what we call a team sheet. Let's say that I want to create a team sheet listing two employees: Mary Jones and John Smith. Mary and John have their separate pages on our intranet which contain their photos, names, job titles, phone numbers and email addresses. Is there any way I can get the tool to locate Mary's page on the intranet, insert her photo into one table cell, insert Mary's name, job title, telephone number, cell phone number and email address into the next cell, then do the same for John? Thank you so much. 💕
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 6000+ 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
Not sure what went wrong. Received an error message - "Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The repetition action(s) 'Apply to each' referenced by 'inputs' in action 'Compose' are not defined in the template.'.'. Concat statement looks like this concat(outputs('Compose')[0],'/',outputs('Compose')[1]).
Hey The Professor 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 for your video, I am facing a issue where Flows are Turning Off after they are deployed/imported into the Target environment, it is becoming very tough to check every time and every flow which are disabled/deactivated after the solution import. Any suggestions on this please
Hey shiva G 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
Hey Chigozie Oziri 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
Hey S TAMILARASAN 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
Sir can you help me for a little task of power automation. Like this. As an example I have 4 chrome profiles on my pc and in all chrome profiles I have installed zenmate vpn. so I want to run 4 website links at each profile and automatically change the vpn region for 4 profiles using Power automation. Thank you. If possible pls help.
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 6000+ 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 sir. Can you please provide an idea if for example I wanted to create a table from sharepoint and wanted to send that table via email based on the status.
Hey Jun Albiso 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
Hey Mayank Tiwari 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
I do have a quick question, as I'm new to this program.. I am running the sequence and it gets to page 144 since the sequence tells it to keep hitting next, it won't save the spreadsheet and is stuck on page 144. What can I do?
Hey Joseph Walters 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
What about if original time is in ISO8601 so format is yyyy-MM-ddTHH:mm:ssZ ... when i split and concatenate to just get yyyy-MM-dd ... my [2] part will take everything (including) after dd
Hey Diaconescu Tiberiu 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
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 8000+ 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 Andrew Jones 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
Tried this a couple of times and it just doesn't run with company workflows. Not sure is it an Outlook thing. Might swap over to Gmail flow to Outlook address.
Hey rakhi 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
Great question. Have you made it 100% like I did? Else you're more than welcome at my Discord, where we can solve it (just post a screenshot of it) and we are a LOT to help you (Discord link is in the description). Kind regards, Anders
Hey Anders Bringmyr 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
Sir could you help me on this like in a folder I have editable and noneditable (images) pages PDFs I have to know which one are editable and which one are images like page count wise
Hey Bharathi Kumaresan 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
@@NickWindham Hi Nick, I also was facing the same issue, I believe that changing the format of the "Birthday" Column to text will help resolve this issue. Thank you Anders for this wonderful video series.
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
If the video helped you, let me know here in the comments, that will help me and the channel a lot 🙏 Thanks for watching and all your support 🙂
Anders Thanks much for a great & simple video ! Very detailed & clear ! Started watching your videos ! I've run into an issue the B'day col in my XL is of String type having 4 chrs of format DDMM ; so I guess this has to be substringed into the Day & Mon parts; I am getting a syntax error trying to code this in the 'Apply to each' part . Greatly appreciate if you can point me to any of your other videos, or if you could ps. help. Thx. in adv
Thanks you Anders, It was very helpful.
Hi anders jensen, how many days it will take to complete course?
THIS IS EPIC VDO !!!! GREAT THANKS
Thanks a lot, autobase 16 🤗 Your feedback helps me immensely. You're more than welcome at my Discord, where we're 5800+ RPA developers networking and solving problems: th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
Thank you, Anders. Excellent video tutorial. Simple, easy to understand, to the point. Exactly what a non-techy needs to know.
Hey Timothy. Thank you so much 💪🙂 Kind regards, Anders
Thank you so much Anders, you are incredible!!!!!!
Wow, Leonardo - thank you so much 🙋🏻♂️👍🙂 I'll try to make a lot of Power Automate videos in the coming. Kind regards, Anders
The best real life example video on power automate...great job
Thank you so much for the nice words 🤩
@@andersjensenorg in fact I am stuck to all your power automate videos...glad I found it
Thank you so much for all of you help. You have just saved my life.
Hey Nick - you're very welcome. Thanks for leaving a comment 🙂 Kind regards, Anders
Solid 30 mins for a beginner like me ! Good one Anders! 👍🏾👍🏾
Hey Jeson. Thanks a lot :) I'm looking forward to your invoice/AI video and just ping me for feedback. Kind regards, Anders
thank you ,Anders ,excellent tutorial
Hey Nakkala Hanumanthareddy. Thanks a lot 😊 Have a great day. Kind regards, Anders
Good job! You are gifted in teaching.😀
Hey hs1sey - thanks a lot 😍🙌 Have a great day. Kind regards, Anders
Thank you Anders for this video. It was very helpful :)
The only issue I had when running the flow, it did not like the birthday column on the spreadsheet as a date so I made it a text column and the flow ran without issues.
Hey Julie. Nice - and thanks for the comment. What happened with the birthday column? Did you create it in Excel desktop or online/cloud? Kind regards, Anders
@@andersjensenorg, I've encountered the same too.
Modified the col. to Text format, and it ran pretty well.
FYI, used Excel via cloud. :)
Would love if you could do a video on how to rename files based on their content (especially word docs and PDFs)! I know how to do this with AHK but many managed devices provided by employers hate open source software, so MS Power Automate is the go-to. Even just how to batch rename things (like add the date, or remove the word "Draft") would be so useful! Love your videos!
Hey Sarah MacDonald
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, thanks a lot. The video is very helpfull en very easy to follow.
Its a good start for me! 👍
You're very welcome, Patric Rademakers - your support helps me a lot 😍
Really enjoy the power automate video you made. Look forward to learn more 😁
Thanks a ton, Alice 😍
I really appreciate, and thanks for sharing this .
My pleasure! 😊
Love " Anders Jensen Teaching "
Thanks a lot, Mahesh patel 🤗 Your feedback helps me immensely. Kind regards, Anders
Thanks a lot, Anders!!! It's a great video and it is so easy to follow!!!! I'll check more of your videos! Thanks again!
Hey Paula- thanks a ton! 🤗 I'm back in this week with a lot more, since this is going to be my job from now 😀 Kind regards, Anders
Thanks so much
Hey my friend. Thanks a lot 🙂
It's been a while since I didn't took some time to watch your quality content. Thank you Anders.
Hey Fabrica - thanks a lot for the nice words 😊 Have you tried Power Automate Desktop as well? Kind regards, Anders
Great tutorial, already putting this to use at work. Thanks again Anders :)
Thank you so much, Hayden 🙂
Thank you Anders!
You're very welcome, Lilmini 🙂
@@andersjensenorg I followed along today using business ID, created the first flows successfully as it shown Status Test succeeded. But I didn't get the email (test). May be there is a delay?
You have earned a subscriber sir. Your videos are very helpful for me. Thank you for your hard work!
Hey Muhammet. Thanks a ton for your nice message 🤩 I'll try not to dissapoint you in the future 🤗 Kind regard, Anders
So crisp and informative! Greetings from Cph :)
Haha hey 🇩🇰 - thanks a ton 😀 Kind regards, Anders
Thank you Anders! This is a great video. It has helped me do new things already. I like that you added a bit of "coding" into the "low code" app as well.
Thanks a lot, Vin. I think it's important to show, as no-code doesn't exist in business automation (in my opinion). But it's still low-code and nice 🙂
Hello :) greetings from Costa Rica, thank you very much for your lessons, I'm learning a lot ! You're doing great, keep it up !
Hey apocalipmon. Thanks a lot :) I plan to make a lot of Power Automate (/Power Automate Desktop) videos in the coming. Kind regards, Anders
AMAZING! thank you
You're very welcome 🙂
Can you show how to combine Flow with Desktop and pass through variables (in and out)?
Hey Dion. Great idea/question. I will definitely do so. I plan to do a "complete" Power Automate and Power Automate Desktop course. Either a big (around 10 hours) or divided into smaller pieces and collected in a playlist. The latter would be the easiest to make, but the other would be more popular. I will go into the box and come back with an answer to your question and PA/PAD in general. Kind regards, Anders
Best😃🙋
Thanks a lot, Akshay 🤩👌
Anders, this is awesome.. would you happen to have the power automate desktop version of this?
Thanks a lot 😍 yeah sure: th-cam.com/video/HUq6ZQhOpbk/w-d-xo.html and sorry for the late reply. Kind regards, Anders
This is an excellent tutorial... however, I followed it precisely and could not get an email. The test and the live run went successfully so I was suspicious that the condition was not being met. After digging through the details of the flow run results, it in fact showed that the condition was false. I am wondering if the date/date serial number or something is the cause? I know you can't see my flow, but do you think this is the problem?
I changed the birthday in the Excel file to be a text string and it worked. So I will play around with the flow now to get the condition to work with the date serial numbers!
Hey Matthew, yes. You're right. I've actually made an extended video that solves, your problem. But it's used for a course review, so I can't make it public. If you want a TH-cam link, just write me on either LinkedIn or FB 🙂 Kind regards, ANders
Thank you for your video it is excellent, Really I didn't know this program and it's great.
You have a great channel and thanks again for the info
Thanks a ton, Rachid 🤩 Have you seen UiPath? th-cam.com/video/sp5ZwFKfh-0/w-d-xo.html Kind regards, Anders
Thank you, such great help! I'm stuck on trying to add an event to a group calendar. Any ideas?
Hey Kathryn Spader
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
It's awesome. But in my case it won't work in outlook desktop app.
Can you help me out? as soon as possible.
Hey Dana Dy
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
good video!! Can you please share or do a video regarding doing Power Automate Desktop AND power pivot Excel? Thanks!!
Hey Josee Martel
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
I work as a digital marketer. Do you think it's possible for me to do a career change to a RPA developer? Or is it only for people with a programming background?
Hey Michael. Yes and no. Highly yes, if you have some "other" skill like documenting, interacting with people, understanding/optimizing processes etc. If you don't have any of these as well as no programming skills, you're behind and need to work. But since it's such a new area, the demand for RPA developers are huge. And "too" huge tbh. But that's great news for you and me :) I think the two most important skills are: The tool itself and people skills. Have you seen this: th-cam.com/video/qiOswPF-0TI/w-d-xo.html Kind regards, Anders
awesome videos. this wil empower my worklife, and Get Sh*t Done!
Hey Preben. Very nice, thanks for getting back :) Let me know, how things progress down the line. Kind regards, Anders
hi tnx for this. i don't know why but it dose not work for me. no mail is being send and the flow is successful
Hey udi karo 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
Hi Anders. You are recommending a book called "Workflow Automation with Microsoft Power Automate". It is 1 year old. Is it still the best choice and up-to-date?? I trust a lot has happened with Power Automate the last year.
Hey Ole. Great question. Yes, it's the best (and only choice), and although a lot has happened (mainly Power Automate Desktop), it's up-to-date. If you live close to Allerød (with that name, I suspect you're Danish?), you can come by my office and have my copy 🙂 Kind regards, Anders Ps. I plan to cover Power Automate extensively in the coming months.
Hi@@andersjensenorg
Yes. I'm Danish. Thank you for your kind offer, but I live in Silkeborg, so I will prefer to buy my own book.
I'm looking forward to your coming Power Automate serie. I hope, it will cover a situation where Power Automate in the cloud works together with Power Automate Desktop.
We are automating web application using power automate ...i wanna to Thank You as we are automating our scripts by seeing your videos ....I do have one query ..How run the all created flows in sequence order
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 6000+ 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
I am looking for a way to create a tool which automatically takes employees' information from our company's intranet (which is SharePoint-based) and inserts the data into table cells in a Word template in order to build what we call a team sheet. Let's say that I want to create a team sheet listing two employees: Mary Jones and John Smith. Mary and John have their separate pages on our intranet which contain their photos, names, job titles, phone numbers and email addresses. Is there any way I can get the tool to locate Mary's page on the intranet, insert her photo into one table cell, insert Mary's name, job title, telephone number, cell phone number and email address into the next cell, then do the same for John? Thank you so much. 💕
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 6000+ 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
@@andersjensenorg Thank you. Can I hire you to help me with this project?
Book ordered via affiliate link
Thanks a lot for the gesture 🙂
@@andersjensenorg need the book
Not sure what went wrong. Received an error message - "Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The repetition action(s) 'Apply to each' referenced by 'inputs' in action 'Compose' are not defined in the template.'.'. Concat statement looks like this concat(outputs('Compose')[0],'/',outputs('Compose')[1]).
Hey The Professor
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 for your video, I am facing a issue where Flows are Turning Off after they are deployed/imported into the Target environment, it is becoming very tough to check every time and every flow which are disabled/deactivated after the solution import. Any suggestions on this please
Hey shiva G 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
@@andersjensenorgThanks for your response much Appreciated :)
@@shivaG-ds7cx My pleasure 😊😊
Is there a debugging function that allows you to see the values output from the flow steps?
Sure, you can test your flow and then in the log access the outputs
Wow, thanks Anders. Please I couldn't find the birthday mail in my inbox. BTW I used gmail in my Excel data. What could be the problem?
Hey Chigozie Oziri
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
Had the same issue: I changed the date format to: mm/dd/yyyy and then it worked out fine
Hi Anders, I have few douts Relating to Uipath. Bot will create new empty excel file, then how to add headers?
Hey S TAMILARASAN
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
Sir can you help me for a little task of power automation. Like this. As an example I have 4 chrome profiles on my pc and in all chrome profiles I have installed zenmate vpn. so I want to run 4 website links at each profile and automatically change the vpn region for 4 profiles using Power automation. Thank you. If possible pls help.
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 6000+ 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
@@andersjensenorg Thank you sir. But I am new. just help me how to ask my question on your platform.
Thank you sir. Can you please provide an idea if for example I wanted to create a table from sharepoint and wanted to send that table via email based on the status.
Hey Jun Albiso
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
can we not format and use utcnow() instead of the "current time"?
Hey Mayank Tiwari
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
I do have a quick question, as I'm new to this program.. I am running the sequence and it gets to page 144 since the sequence tells it to keep hitting next, it won't save the spreadsheet and is stuck on page 144. What can I do?
Hey Joseph Walters 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
What about if original time is in ISO8601 so format is yyyy-MM-ddTHH:mm:ssZ ... when i split and concatenate to just get yyyy-MM-dd ... my [2] part will take everything (including) after dd
Hey Diaconescu Tiberiu 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
Is it possible to read an excel file if excel file is not formatted as table in power automate?
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 8000+ 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
Sir, your tutorials are EXCELLENT however I couldn't receive the emails. I am not sure what I did wrong.
Hey Andrew Jones
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
Tried this a couple of times and it just doesn't run with company workflows. Not sure is it an Outlook thing. Might swap over to Gmail flow to Outlook address.
I honestly don't know 😏
How convert csv to excel. while try to convert formate change all data one coloum... Please help me.. or make video on this
Hey rakhi
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
at 26:39 when it says it is Invalid you can't skip it by pressing 'OK' , it doesn't let you proceed.........
what can I do about it?
Great question. Have you made it 100% like I did? Else you're more than welcome at my Discord, where we can solve it (just post a screenshot of it) and we are a LOT to help you (Discord link is in the description). Kind regards, Anders
Hi
have you created a power automation to export users with all attributes from azure?
or du you where I can find some templates?
Hey Anders Bringmyr
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
Sir could you help me on this like in a folder I have editable and noneditable (images) pages PDFs I have to know which one are editable and which one are images like page count wise
Hey Bharathi Kumaresan
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
@@andersjensenorg thank you
It is open source free like openRpa?
Unfortunately no, but it's included in your Office package 🙂
Can you cover Power automate from scratch and make separate playlist.we need regular video on that where you cover Power automate from basic
Hey prashant. Have you seen this: th-cam.com/play/PLXXz88_TPiHqGlJoWhBDCAxZ9m1N_jsB6.html Kind regards, Anders
@@andersjensenorg yep all of them but still more videos on that
@@prashantrai5911 I will do my best :)
Hi Anders. For me your videos are blurry. Other similar videos, such as those by Leila Gharani are fine.
Sorry about that - I think it's your screen, as it's recorded in 1920x1080. Kind regards, Anders
😮
😀
This automation isn’t working for me. No errors, but no emails being sent.
Hey Nick. It's most likely your condition, we need to fix. When you've run it, what is the log saying? Kind regards, Anders
@@andersjensenorg Thx for your fast reply. I’ll check the log and report back in a few hours when I can get back to it.
@@NickWindham Hi Nick, I also was facing the same issue, I believe that changing the format of the "Birthday" Column to text will help resolve this issue.
Thank you Anders for this wonderful video series.
@@andersjensenorg just add ' before your date to become text.
maaaan, that didnt work :(
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
Wicked good video! Thank you so much for a whole world of reasons. Great information and nicely presented!
Thanks a ton, Dekkarr 22 🤩 Have a great day. Kind regards, Anders