FANTASTIC! Starting with no PA experience I was able to develop a real-world solution in just a few hours. One thing I learned is that the browser element selector does not work well when browser is maximized.
Hey Adam. Thanks a lot 😀 With that said, it sounds very weird with the maximized window. Do you have a link and what you tried to click/get? Kind regards, Anders
This was a very nice tutorial, thank you so much for developing this training! Coming from UiPath, I've been tasked w/getting some experience with PAD to get familiar w/its capabilities. I LOVE the fact you can actually perform SYSTEM related functions - working with files (renaming, moving, deleting etc.) I actually feel Microsoft should INCLUDE Power Automate Desktop w/the operating system - starting at say, Windows Pro and above - it's a GREAT utility to have as a Windows power user - also a nice way for ANYONE to get some exposure to programming / software development!
Hey @mrnock2. Thanks a lot 😊 Have a great day. You're more than welcome at my Discord, where we're 11,000+ RPA developers networking and solving problems: ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
your lessons are great sir! never change you speed voice it is great beacause i dont have to press pause to do the same things that you are doing! thanks!
You are an excellent tutor sir. Your way of explanation, picking up topics and quality is excellent. Really helpful for people who can't afford premium trainings! Keep doing for us..❤
@@andersjensenorg My company runs on a bespoke web app we developed for the last 17 years. Today I added performance charts measuring load times for our main screen to our monitoring system. This is the first time we have ever had proper stats. I'm an infrastructure engineer.... I even struggle a bit with powershell. Power Automate ROCKS.
Hi Anders, great content as usual. I have a question. I wanted to fetch data from excel and then write into a textbox(s) on a website. For example: login credentials for a website OR filling Credit/Debit Card details. How do you achieve that?
Hello Anders, thank you I have learned how to activate macro from PAD. I am wondering why my Variable ExcelData do not show the Headers as yours but Column 1 Column2 and so forth. .. thank you
Hey Macraris - thanks a lot. In your Read from Excel worksheet, go to Advanced and tick 'First line of range contains column names'. That will work 😊 Kind regards, Anders
Hello, Anders! Thank you for all your lessons! Wouldn't be easier to use Power Query instead of Power Automate in this specific use case? Thank you for your help and attention! I'm sorry for any inconvenience!
Hey @georgewinters2066. Thanks a lot 😊 Have a great day. You're more than welcome at my Discord, where we're 8000+ RPA developers networking and solving problems: ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
Great guide, makes things a lot easier. Thank you Anders! Btw, I cannot manage to run a macro from my personal.xlsb (PERSONAL.XLSB!Consolidate) instead of one being stored on the current instance. Any ideas on how to do that?
Hey Efthimios Spiridopoulos 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: ruclips.net/video/_QRI-Yo2h8U/видео.html Have a great day. Kind regards, Anders
Hi Anders, what's the best way to set up a process to automate the refreshing of power queries in Excel? Is it to trigger a vba macro in the file or is there another way. Thanks
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
Very very interesting Anders. I am starting exploring RPA development using UiPath however I would like to learn Power Automate as well. What are the main differences between these two apps? strengths and weaknesses of those ones? Thanks
thx for the video I had a problem saving the excel, I disabled Read-Only option. I edit some rows in the excel, and when i want to save the excel it says that it cant save the excel, aprox a min a message button appears on screen "File available, {File} is available to edit. Choose ReadOnly and Write to open and save it " Do i need something to set before to skip this message?
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
Anders, hats off to your content! It's pretty good for one who already knows the basics! Also one recommendation. Please try to improve your English, more would be able to follow is what I believe, because more than a year ago I could not follow along with you(beginner). This is out of love for you I follow a lot of your content please don't take me wrong I believe a friend's rebuke is a blessing.
@andersjensenorg irrelevant question: if I stop my code say after 3 records and the total is 10 for example, and I want to continue where I left off instead of from the beginning, how would I go about it
Can I use Power Automate Desktop to just automatically make a few clicks on various buttons and options for single sign-on, refresh entire workbook, log off single sign-on, then save? Then set the Power Automate to run on its own once a day?
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 7000+ 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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
Hello Anders, Could you pls tell me if it's possible just to: Open the excel, update the data and close the file. It's a vry simple procedure, however I coudn't find the right path to take this action. Would you pls give me a hand on this? Thank you sirt
Hey Henrique. Sorry, for the late reply. Yes, it's straightforward to do with Power Automate Desktop. Can you post your exact problem on my Discord (the link is in the video description), and then we solve it? Kind regards, Anders
Hi Anders, thanks for your lesson! Just one concern about this -- the iteration looks pretty slow. If I have an excel file with 50000 rows, the whole process will take hours to complete?
My pleasure 😊 Great question. It's in debug, so it's slower, you can either run it from outside the development space (e.g. the overview or cloud) OR just change the Run delay to 1 in the lower right corner. Have a great day. Kind regards, Anders
@@andersjensenorg If I put a breakpoint on Close Excel and run.. it took 17 sec. if I run it with 10 in delay it took 7 sec. Then run it from Overview it gives 3 sec. so this works .. be carefull to put delay to low because even this powerfull tool can become dizzy. specialy when communicate with other applications. Coming from VBA I'm surprised by the possilities of this tool(s). @anders keep up the good work. I'm going to like you 👍
I've noticed something. There are 2 sheets in the excel file "andersjensenorg" and "Employees". How does PAD know which sheet we want since we didn't specify? EDIT: Nvm my comment was before last part haha
Hey Take the L 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: ruclips.net/video/_QRI-Yo2h8U/видео.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 9000+ 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): ruclips.net/video/xWFz-S96XGo/видео.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): ruclips.net/video/xWFz-S96XGo/видео.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 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): ruclips.net/video/xWFz-S96XGo/видео.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 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): ruclips.net/video/xWFz-S96XGo/видео.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 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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
What do you think of the video? Please let me know here in the comments 🖐😊
Very Good Sir
@@SehazArtworks Thanks a lot, Sehaz 🙂
Hello Jensen, I want to connect .xlsm files into power automate web, can you help me?
FANTASTIC! Starting with no PA experience I was able to develop a real-world solution in just a few hours. One thing I learned is that the browser element selector does not work well when browser is maximized.
Hey Adam. Thanks a lot 😀 With that said, it sounds very weird with the maximized window. Do you have a link and what you tried to click/get? Kind regards, Anders
This was a very nice tutorial, thank you so much for developing this training!
Coming from UiPath, I've been tasked w/getting some experience with PAD to get familiar w/its capabilities.
I LOVE the fact you can actually perform SYSTEM related functions - working with files (renaming, moving, deleting etc.)
I actually feel Microsoft should INCLUDE Power Automate Desktop w/the operating system - starting at say, Windows Pro and above - it's a GREAT utility to have as a Windows power user - also a nice way for ANYONE to get some exposure to programming / software development!
Hey William, thanks a bunch and I 100% agree with you 🙂
Excellent video again Anders. The activity of running macros is of great use. Thanks for your continuous support!
Hey @mrnock2. Thanks a lot 😊 Have a great day. You're more than welcome at my Discord, where we're 11,000+ RPA developers networking and solving problems: ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
Find my complete Power Automate for desktop course here: ruclips.net/p/PLXXz88_TPiHpY_5bfeV8RAOHnBKgc-rtw 🙂
your lessons are great sir! never change you speed voice it is great beacause i dont have to press pause to do the same things that you are doing! thanks!
Hey Andre - thanks a bunch for your kind words 💯😍 Have a great weekend.
You are an excellent tutor sir.
Your way of explanation, picking up topics and quality is excellent.
Really helpful for people who can't afford premium trainings!
Keep doing for us..❤
Your appreciation means a lot to me ❤️ I'll keep creating content to help as many people as I can 😊 Kind regards, Anders
Wonderful stuff - well explained and easy to understand. Thank you so much!
I'm so glad to hear, thanks a lot 🤩 Kind regards, Anders
Thanks Anders! Your videos helped me very much to get started.
Hey Markku. I'm so happy to hear, thanks a lot for letting me know 🙂 Kind regards, Anders
Thank you. This was very insightful. It really is a guide for beginners, everything was well explained and I even learned new excel tricks with ease.
Hello Obakeng - I'm so glad to hear. A pleasure to create videos, when nice persons like you are commenting :) Have a great day. Kind regards, Anders
Good work sir. Well throught out and presented.
Thank you so much, Mark 😎🙌
@@andersjensenorg My company runs on a bespoke web app we developed for the last 17 years. Today I added performance charts measuring load times for our main screen to our monitoring system. This is the first time we have ever had proper stats. I'm an infrastructure engineer.... I even struggle a bit with powershell. Power Automate ROCKS.
Helpful to me a lots, thanks Mr.
Thanks for the big support, kind regards, Anders
Very interesting tutorial , thank you for the quality of the content
Many thanks, happy to hear 😍 Kind regards, Anders
Thank you for this educational video.
Thanks for the feedback, Andrew! Glad you found the video helpful 🌱 Kind regards, Anders
Another great video from Anders. Nice and clear. Keep up the great work and awesome videos.
Thanks a ton, my friend 🥰
Hi Anders, great content as usual. I have a question.
I wanted to fetch data from excel and then write into a textbox(s) on a website.
For example: login credentials for a website OR filling Credit/Debit Card details.
How do you achieve that?
Hey Ravi. Thanks a bunch for your nice words. Please check this video: ruclips.net/video/1WezrCQlpBY/видео.html Kind regards, Anders
Thank you very much. Great tutorial!
Thanks a ton, Marcus Cato 🤩 Have a great day. Kind regards, Anders
Hello Anders, thank you I have learned how to activate macro from PAD. I am wondering why my Variable ExcelData do not show the Headers as yours but Column 1 Column2 and so forth. .. thank you
Hey Macraris - thanks a lot. In your Read from Excel worksheet, go to Advanced and tick 'First line of range contains column names'. That will work 😊 Kind regards, Anders
@@andersjensenorg Thank you again it works!
@@LapaConsult_Ex_Macraris Great to hear 😊
Thanks for the lesson, very interesting.
It's my pleasure, Corrado - thanks for commenting 🙌😊
Great job 👍👍👍👍👍👍👍👍 only watching u
Thank you so much, Litvin ✔😊 Kind regards, Anders
Hello, Anders!
Thank you for all your lessons!
Wouldn't be easier to use Power Query instead of Power Automate in this specific use case?
Thank you for your help and attention!
I'm sorry for any inconvenience!
Hey Davi. Thanks a lot. Sure. Most processes don't use Excel only, but a range of programs, and then you can't use PQ 😊
What a fantastic video !! More More More please!!
Hey @georgewinters2066. Thanks a lot 😊 Have a great day. You're more than welcome at my Discord, where we're 8000+ RPA developers networking and solving problems: ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
Very good demo.
So kind of you, thanks, Michael 🙂
Great guide, makes things a lot easier. Thank you Anders!
Btw, I cannot manage to run a macro from my personal.xlsb (PERSONAL.XLSB!Consolidate) instead of one being stored on the current instance. Any ideas on how to do that?
Hey Efthimios Spiridopoulos 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: ruclips.net/video/_QRI-Yo2h8U/видео.html Have a great day. Kind regards, Anders
xlsm, I think for extension file
Perfect! Thank you very much 🙂
My pleasure 😊🙌 Kind regards, Anders
Hi Anders, what's the best way to set up a process to automate the refreshing of power queries in Excel? Is it to trigger a vba macro in the file or is there another way. Thanks
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
Amazing tutorial.
I'm so glad to hear, thank you 😊 Kind regards, Anders
Very very interesting Anders. I am starting exploring RPA development using UiPath however I would like to learn Power Automate as well. What are the main differences between these two apps? strengths and weaknesses of those ones? Thanks
Hey KT. That's a big question, but:
UiPath: The best and expensive.
Microsoft: Good and cheap (already in your O365 package).
Kind regards, Anders
thx for the video
I had a problem saving the excel, I disabled Read-Only option.
I edit some rows in the excel, and when i want to save the excel it says that it cant save the excel, aprox a min a message button appears on screen "File available, {File} is available to edit. Choose ReadOnly and Write to open and save it "
Do i need something to set before to skip this message?
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
Anders, hats off to your content! It's pretty good for one who already knows the basics! Also one recommendation. Please try to improve your English, more would be able to follow is what I believe, because more than a year ago I could not follow along with you(beginner). This is out of love for you I follow a lot of your content please don't take me wrong I believe a friend's rebuke is a blessing.
Hey Alfred, thanks a lot for the great feedback - in what ways do you think I can improve the English best? 🙂
@andersjensenorg irrelevant question: if I stop my code say after 3 records and the total is 10 for example, and I want to continue where I left off instead of from the beginning, how would I go about it
Great question. Either build the logic in Excel or use Work Queues: ruclips.net/video/paYO_AsU4ek/видео.html Kind regard, Anders 😊
Can I use Power Automate Desktop to just automatically make a few clicks on various buttons and options for single sign-on, refresh entire workbook, log off single sign-on, then save? Then set the Power Automate to run on its own once a day?
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 7000+ 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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
Hello Anders,
Could you pls tell me if it's possible just to: Open the excel, update the data and close the file.
It's a vry simple procedure, however I coudn't find the right path to take this action. Would you pls give me a hand on this?
Thank you sirt
Hey Henrique. Sorry, for the late reply. Yes, it's straightforward to do with Power Automate Desktop. Can you post your exact problem on my Discord (the link is in the video description), and then we solve it? Kind regards, Anders
Great Video !!!
Thanks a ton, Jose 🙌🙂
Hi Anders, thanks for your lesson! Just one concern about this -- the iteration looks pretty slow. If I have an excel file with 50000 rows, the whole process will take hours to complete?
My pleasure 😊 Great question. It's in debug, so it's slower, you can either run it from outside the development space (e.g. the overview or cloud) OR just change the Run delay to 1 in the lower right corner. Have a great day. Kind regards, Anders
@@andersjensenorg Thank you so much! Make perfect sense to me.
@@andersjensenorg If I put a breakpoint on Close Excel and run.. it took 17 sec. if I run it with 10 in delay it took 7 sec. Then run it from Overview it gives 3 sec. so this works .. be carefull to put delay to low because even this powerfull tool can become dizzy. specialy when communicate with other applications.
Coming from VBA I'm surprised by the possilities of this tool(s).
@anders keep up the good work. I'm going to like you 👍
@@erikeringaad8638 Thanks a ton for taking your time giving us this feedback 😊😊
@@andersjensenorg Ahh, thanks
I've noticed something. There are 2 sheets in the excel file "andersjensenorg" and "Employees". How does PAD know which sheet we want since we didn't specify?
EDIT: Nvm my comment was before last part haha
Hahaha, thanks Srdjan and sorry for the late reply - I hope you're still here (at the channel)? Kind regards, Anders
any idea how to open the excel to maximized or normal size after using launch excel function? instead of it just opening in the shortcut tab?
Hey Take the L 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: ruclips.net/video/_QRI-Yo2h8U/видео.html Have a great day. Kind regards, Anders
HI please, could you help me? how can I open a Excel file that ever is changing it name?
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 9000+ 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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
Hi jensen need your help on Excel automation in power automate can you please reply
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
il se trouve dans quelle ville ce bistrot?
I don't understand, sorry 😔
Connections to External Data Sources popup window
Resolution
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
What if you wanted to save excel as... I got error when I tried it.
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
good
Thanks a lot 😀
I dont know why in my case, when i lanch excel (step1) my excel's window always appears, but in your case, its not. Sorry for my bad english
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
Bat may halinghing ang boses? LOL.
What does that mean? 🙂
very nice tutorial
My pleasure, yowanda! 🙌🙂