Excel in Power Automate for Desktop (Full Tutorial)

[@andersjensenorg]

What do you think of the video? Please let me know here in the comments 🖐😊

[@SehazArtworks]

Very Good Sir

[@andersjensenorg]

@@SehazArtworks Thanks a lot, Sehaz 🙂

[@vamsimantripragada]

Hello Jensen, I want to connect .xlsm files into power automate web, can you help me?

[@jessebodie8541]

Really helpful lesson and your teaching voice is so calming lool I love your accent. "I want to customize this date, (Danish whisper:) so I customize it."

[@adamshults9810]

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.

[@andersjensenorg]

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

[@andersjensenorg]

Find my complete Power Automate for desktop course here: kzbin.info/aero/PLXXz88_TPiHpY_5bfeV8RAOHnBKgc-rtw 🙂

[@mrnock2]

Excellent video again Anders. The activity of running macros is of great use. Thanks for your continuous support!

[@andersjensenorg]

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: kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@williambell4591]

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!

[@andersjensenorg]

Hey William, thanks a bunch and I 100% agree with you 🙂

[@obakenglebisi]

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.

[@andersjensenorg]

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

[@dharmateja51]

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]

Your appreciation means a lot to me ❤️ I'll keep creating content to help as many people as I can 😊 Kind regards, Anders

[@90daner]

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!

[@andersjensenorg]

Hey Andre - thanks a bunch for your kind words 💯😍 Have a great weekend.

[@stuartlloyd2650]

Wonderful stuff - well explained and easy to understand. Thank you so much!

[@andersjensenorg]

I'm so glad to hear, thanks a lot 🤩 Kind regards, Anders

[@markkurautanen1368]

Thanks Anders! Your videos helped me very much to get started.

[@andersjensenorg]

Hey Markku. I'm so happy to hear, thanks a lot for letting me know 🙂 Kind regards, Anders

[@yahyafares7515]

Very interesting tutorial , thank you for the quality of the content

[@andersjensenorg]

Many thanks, happy to hear 😍 Kind regards, Anders

[@anthonyluan3511]

Helpful to me a lots, thanks Mr.

[@andersjensenorg]

Thanks for the big support, kind regards, Anders

[@markdenton8027]

Good work sir. Well throught out and presented.

[@andersjensenorg]

Thank you so much, Mark 😎🙌

[@markdenton8027]

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

[@AndrewLee-nz4yk]

Thank you for this educational video.

[@andersjensenorg]

Thanks for the feedback, Andrew! Glad you found the video helpful 🌱 Kind regards, Anders

[@craignorton8678]

Another great video from Anders. Nice and clear. Keep up the great work and awesome videos.

[@andersjensenorg]

Thanks a ton, my friend 🥰

[@georgewinters2066]

What a fantastic video !! More More More please!!

[@andersjensenorg]

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: kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@MichaelKrumenaker]

Very good demo.

[@andersjensenorg]

So kind of you, thanks, Michael 🙂

[@marcuscato1704]

Thank you very much. Great tutorial!

[@andersjensenorg]

Thanks a ton, Marcus Cato 🤩 Have a great day. Kind regards, Anders

[@stop007michaela]

Perfect! Thank you very much 🙂

[@andersjensenorg]

My pleasure 😊🙌 Kind regards, Anders

[@healthyman01]

Amazing tutorial.

[@andersjensenorg]

I'm so glad to hear, thank you 😊 Kind regards, Anders

[@Cosecci]

Thanks for the lesson, very interesting.

[@andersjensenorg]

It's my pleasure, Corrado - thanks for commenting 🙌😊

[@litvin_china]

Great job 👍👍👍👍👍👍👍👍 only watching u

[@andersjensenorg]

Thank you so much, Litvin ✔😊 Kind regards, Anders

[@LapaConsult_Ex_Macraris]

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

[@andersjensenorg]

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

[@LapaConsult_Ex_Macraris]

@@andersjensenorg Thank you again it works!

[@andersjensenorg]

@@LapaConsult_Ex_Macraris Great to hear 😊

[@yowandafriskya.1502]

very nice tutorial

[@andersjensenorg]

My pleasure, yowanda! 🙌🙂

[@ravivishwamitra723]

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?

[@andersjensenorg]

Hey Ravi. Thanks a bunch for your nice words. Please check this video: kzbin.info/www/bejne/Z4jIq6V5htGjeLs Kind regards, Anders

[@efthimiosspiridopoulos9531]

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?

[@andersjensenorg]

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: kzbin.info/www/bejne/lYK1emCPpJebbrc Have a great day. Kind regards, Anders

[@ildiandaprincipo163]

xlsm, I think for extension file

[@davi.constante]

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!

[@andersjensenorg]

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 😊

[@king-tauro1166]

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?

[@andersjensenorg]

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

[@KT-uq3bs]

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

[@andersjensenorg]

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

[@chrisholden6658]

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

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 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): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@joseeduardohuertaornelas9864]

Great Video !!!

[@andersjensenorg]

Thanks a ton, Jose 🙌🙂

[@MrNelvaro]

@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

[@andersjensenorg]

Great question. Either build the logic in Excel or use Work Queues: kzbin.info/www/bejne/ppK8gJJ3qLpnm80 Kind regard, Anders 😊

[@CP-zb3ky]

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?

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 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): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@alfredpereira9152]

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]

Hey Alfred, thanks a lot for the great feedback - in what ways do you think I can improve the English best? 🙂

[@Hbedin92]

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

[@andersjensenorg]

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

[@lookman06]

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?

[@andersjensenorg]

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: kzbin.info/www/bejne/lYK1emCPpJebbrc Have a great day. Kind regards, Anders

[@rogeryang18]

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?

[@andersjensenorg]

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

[@rogeryang18]

@@andersjensenorg Thank you so much! Make perfect sense to me.

[@erikeringaad8638]

@@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 👍

[@andersjensenorg]

@@erikeringaad8638 Thanks a ton for taking your time giving us this feedback 😊😊

[@HippieP629]

@@andersjensenorg Ahh, thanks

[@fakruddinshaik5875]

Hi jensen need your help on Excel automation in power automate can you please reply

[@andersjensenorg]

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

[@rvallejosguerrero]

HI please, could you help me? how can I open a Excel file that ever is changing it name?

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 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): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@SrdjanS_Automations]

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

[@andersjensenorg]

Hahaha, thanks Srdjan and sorry for the late reply - I hope you're still here (at the channel)? Kind regards, Anders

[@valapo80800]

il se trouve dans quelle ville ce bistrot?

[@andersjensenorg]

I don't understand, sorry 😔

[@eduardciobanu1380]

What if you wanted to save excel as... I got error when I tried it.

[@andersjensenorg]

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

[@gydkam]

Connections to External Data Sources popup window Resolution

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 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): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@nghiepnguyen6241]

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

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 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): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@waveboardboy]

good

[@andersjensenorg]

Thanks a lot 😀

[@chrisakol]

Bat may halinghing ang boses? LOL.

[@andersjensenorg]

What does that mean? 🙂