I saw a lot of your videos and this one it was for me a litle difficult, especally the Account part. But i saw it a few times to understand it.Very good video Thank you. Question: why my Excel sheet change its properties after i run the PAD, and after that that´s impossible to run again?
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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
This is the first time I've ever written a comment on UA-cam (how scary! 😆), but I wanted you to know how much your videos have helped me! I've probably watched 20 different PAD videos over the last week and yours are my favorite by a mile! You really get into the more complicated flows, and there aren't many videos on those.
Hi Anders, Thankyou!!! this poc helped me to understand most of the power automate commands. As u said that DKK is our base currency, it means that Amount DKK column is to convert all the exchange rate values of their currencies to DKK? If yes, how did we take the formula. Is that /100 means DKK rate value?
Hey Geraldine. Thanks a lot 🙌😊 All your support helps me a lot. Have you seen my video from today: ua-cam.com/video/TmeGaxksrUA/v-deo.html where I go a little more advanced. Have a great day. Kind regards, Anders
Thanks for this and it was great - my project that i am working on is that a customer sends us an Excel spreadsheet with stock to be imported but the columns vary each time they send to us as they cannot follow a template e.g. Barcode of product should be column B but this week is D and next week will be F although the column heading will be called Barcode. I then need to copy this data and write it to a CSV file and set the column for the barcode to a number with zero decimal places then save for our WMS to import very time consuming to copy and paste each time - hopefully this video will assist me in writing an RPA process using PAD
Hey shaun, thanks a lot. Let me know, how it goes and you're very welcome on my Discord, where we help each other and network (4000+ RPA developers). Have a great day. Kind regards, Anders
Hey Alsafeer_kw. Thanks a lot for the valuable comment. You're right, it's always nice to reuse. At the same time, when I created this video, it was also about keeping it simple, so left it out. In my "own" flows, I have subflows for init, logs, error-handling etc. Please continue with comments like this - they're gold. Have a great day. Kind regards, Anders
Hey Lawrence. Thanks a lot. Yes, and it will be in my advanced PAD course, expected early 2023. So either you have to wait of find another teacher 😞 Have a great day. Kind regards, Anders
Thanks a lot 😊 So you want to scrape data, but you need to login first? Sure no problem. If you mean the data that I use in the video, sure they are publicly available. Kind regards, Anders
@@andersjensenorg I can filter evaluations of my company from the web (employee login is required). I would like to insert this data into Excel, make it fancy and forward it to certain people by mail.
Thanks but real challenge is how to schedule this on server PC machine? Could you pls make a video so far I have not seen anyone makit scheduling video
Hey, brijendraydv. Thanks a lot. You need to make the connection to PA Cloud: ua-cam.com/video/mxfOEpTE6hw/v-deo.html and then you can easily schedule it from there. Let me know, if you have any questions. Kind regards, Anders
Hey naresh kumar 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: ua-cam.com/video/_QRI-Yo2h8U/v-deo.html Have a great day. Kind regards, Anders
Thanks for all your support 🙌🔥
Please rate the video by giving it a thumbs up or down
- that helps me a lot, thanks 😊
@Anders Jensen , your videos have been really helpful and beneficial .. thank you for your contribution and support ... can only appreciate
Hey Rajesh - thanks a lot for such a nice comment - highly appreciated 🙌😊 Kind regards, Anders
I saw a lot of your videos and this one it was for me a litle difficult, especally the Account part. But i saw it a few times to understand it.Very good video Thank you.
Question: why my Excel sheet change its properties after i run the PAD, and after that that´s impossible to run again?
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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Super helpful and well-explained. Thanks!
So happy you could use it, thanks a lot 😎😍
Thank you for this tutorial Anders
I'm happy you could use it, Akshay 🙌😍
This is the first time I've ever written a comment on UA-cam (how scary! 😆), but I wanted you to know how much your videos have helped me! I've probably watched 20 different PAD videos over the last week and yours are my favorite by a mile! You really get into the more complicated flows, and there aren't many videos on those.
Haha, thanks a lot for the nice comment 🙌💪😊 I will create new PAD videos in the autumn. Kind regards, Anders
Hi Anders, Thankyou!!! this poc helped me to understand most of the power automate commands. As u said that DKK is our base currency, it means that Amount DKK column is to convert all the exchange rate values of their currencies to DKK? If yes, how did we take the formula. Is that /100 means DKK rate value?
Yeah, that's because the site, where we get the currency rates from use 100 of that currency (instead of 1). Thanks a lot, Sweety! 🙂
Thank you for all the good information. Please keep it up 👍
My pleasure, HASAN 🙌😎
Another great video tutorial, learned something new again from this. Thank you Anders for doing it! Truly helpful. ❤❤❤
Hey Geraldine. Thanks a lot 🙌😊 All your support helps me a lot. Have you seen my video from today: ua-cam.com/video/TmeGaxksrUA/v-deo.html where I go a little more advanced. Have a great day. Kind regards, Anders
Thanks for this and it was great - my project that i am working on is that a customer sends us an Excel spreadsheet with stock to be imported but the columns vary each time they send to us as they cannot follow a template e.g. Barcode of product should be column B but this week is D and next week will be F although the column heading will be called Barcode. I then need to copy this data and write it to a CSV file and set the column for the barcode to a number with zero decimal places then save for our WMS to import very time consuming to copy and paste each time - hopefully this video will assist me in writing an RPA process using PAD
Hey shaun, thanks a lot. Let me know, how it goes and you're very welcome on my Discord, where we help each other and network (4000+ RPA developers). Have a great day. Kind regards, Anders
I didn’t see you use Subflows in your videos… i think it works like functions in programming if your flow has repeated work
Hey Alsafeer_kw. Thanks a lot for the valuable comment. You're right, it's always nice to reuse. At the same time, when I created this video, it was also about keeping it simple, so left it out. In my "own" flows, I have subflows for init, logs, error-handling etc. Please continue with comments like this - they're gold. Have a great day. Kind regards, Anders
Hello Anders ,do you give captcha courses,that will be a fun to watch. BT W,always enjoy your videos!
Hey Lawrence. Thanks a lot. Yes, and it will be in my advanced PAD course, expected early 2023. So either you have to wait of find another teacher 😞 Have a great day. Kind regards, Anders
Hi, your videos are great.
Can I get data from the web that I have to log in?
Thanks a lot 😊 So you want to scrape data, but you need to login first? Sure no problem. If you mean the data that I use in the video, sure they are publicly available. Kind regards, Anders
@@andersjensenorg I can filter evaluations of my company from the web (employee login is required).
I would like to insert this data into Excel, make it fancy and forward it to certain people by mail.
No problem, but you need a few more actions in the process then.
Thanks but real challenge is how to schedule this on server PC machine? Could you pls make a video so far I have not seen anyone makit scheduling video
Hey, brijendraydv. Thanks a lot. You need to make the connection to PA Cloud: ua-cam.com/video/mxfOEpTE6hw/v-deo.html and then you can easily schedule it from there. Let me know, if you have any questions. Kind regards, Anders
thankyou sir
My pleasure, Shubham - glad you liked it 😊🙌
how to loop through each row of a data table in a webpage
Hey naresh kumar 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: ua-cam.com/video/_QRI-Yo2h8U/v-deo.html Have a great day. Kind regards, Anders
Top"! @powerbinareal