No video

Excel in Power Automate for Desktop (Full Tutorial)

  Рет қаралды 29,022

Anders Jensen

Anders Jensen

Күн бұрын

Пікірлер: 99
@andersjensenorg
@andersjensenorg 2 жыл бұрын
What do you think of the video? Please let me know here in the comments 🖐😊
@SehazArtworks
@SehazArtworks 2 жыл бұрын
Very Good Sir
@andersjensenorg
@andersjensenorg 2 жыл бұрын
@@SehazArtworks Thanks a lot, Sehaz 🙂
@vamsimantripragada
@vamsimantripragada Жыл бұрын
Hello Jensen, I want to connect .xlsm files into power automate web, can you help me?
@dharmateja51
@dharmateja51 5 ай бұрын
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
@andersjensenorg 4 ай бұрын
Your appreciation means a lot to me ❤️ I'll keep creating content to help as many people as I can 😊 Kind regards, Anders
@williambell4591
@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
@andersjensenorg Жыл бұрын
Hey William, thanks a bunch and I 100% agree with you 🙂
@adamshults9810
@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
@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
@mrnock2
@mrnock2 Жыл бұрын
Excellent video again Anders. The activity of running macros is of great use. Thanks for your continuous support!
@andersjensenorg
@andersjensenorg 7 ай бұрын
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: kzfaq.info/get/bejne/rr12rZCEnpy8d6M.html Kind regards, Anders
@obakenglebisi
@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
@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
@90daner
@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
@andersjensenorg Жыл бұрын
Hey Andre - thanks a bunch for your kind words 💯😍 Have a great weekend.
@markkurautanen1368
@markkurautanen1368 Жыл бұрын
Thanks Anders! Your videos helped me very much to get started.
@andersjensenorg
@andersjensenorg Жыл бұрын
Hey Markku. I'm so happy to hear, thanks a lot for letting me know 🙂 Kind regards, Anders
@stop007michaela
@stop007michaela 5 ай бұрын
Perfect! Thank you very much 🙂
@andersjensenorg
@andersjensenorg 5 ай бұрын
My pleasure 😊🙌 Kind regards, Anders
@litvin_china
@litvin_china 4 ай бұрын
Great job 👍👍👍👍👍👍👍👍 only watching u
@andersjensenorg
@andersjensenorg 4 ай бұрын
Thank you so much, Litvin ✔😊 Kind regards, Anders
@yahyafares7515
@yahyafares7515 7 ай бұрын
Very interesting tutorial , thank you for the quality of the content
@andersjensenorg
@andersjensenorg 7 ай бұрын
Many thanks, happy to hear 😍 Kind regards, Anders
@AndrewLee-nz4yk
@AndrewLee-nz4yk 6 ай бұрын
Thank you for this educational video.
@andersjensenorg
@andersjensenorg 6 ай бұрын
Thanks for the feedback, Andrew! Glad you found the video helpful 🌱 Kind regards, Anders
@anthonyluan3511
@anthonyluan3511 9 ай бұрын
Helpful to me a lots, thanks Mr.
@andersjensenorg
@andersjensenorg 8 ай бұрын
Thanks for the big support, kind regards, Anders
@craignorton8678
@craignorton8678 2 жыл бұрын
Another great video from Anders. Nice and clear. Keep up the great work and awesome videos.
@andersjensenorg
@andersjensenorg 2 жыл бұрын
Thanks a ton, my friend 🥰
@alfredpereira9152
@alfredpereira9152 2 жыл бұрын
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
@andersjensenorg Жыл бұрын
Hey Alfred, thanks a lot for the great feedback - in what ways do you think I can improve the English best? 🙂
@markdenton8027
@markdenton8027 Жыл бұрын
Good work sir. Well throught out and presented.
@andersjensenorg
@andersjensenorg Жыл бұрын
Thank you so much, Mark 😎🙌
@markdenton8027
@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.
@marcuscato1704
@marcuscato1704 2 жыл бұрын
Thank you very much. Great tutorial!
@andersjensenorg
@andersjensenorg 2 жыл бұрын
Thanks a ton, Marcus Cato 🤩 Have a great day. Kind regards, Anders
@Cosecci
@Cosecci 2 жыл бұрын
Thanks for the lesson, very interesting.
@andersjensenorg
@andersjensenorg 2 жыл бұрын
It's my pleasure, Corrado - thanks for commenting 🙌😊
@healthyman01
@healthyman01 11 ай бұрын
Amazing tutorial.
@andersjensenorg
@andersjensenorg 11 ай бұрын
I'm so glad to hear, thank you 😊 Kind regards, Anders
@georgewinters2066
@georgewinters2066 Жыл бұрын
What a fantastic video !! More More More please!!
@andersjensenorg
@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: kzfaq.info/get/bejne/rr12rZCEnpy8d6M.html Kind regards, Anders
@user-gy7xn6uz6f
@user-gy7xn6uz6f Жыл бұрын
Very good demo.
@andersjensenorg
@andersjensenorg Жыл бұрын
So kind of you, thanks, Michael 🙂
@davi.constante
@davi.constante 2 жыл бұрын
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
@andersjensenorg 2 жыл бұрын
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 😊
@ravivishwamitra723
@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
@andersjensenorg Жыл бұрын
Hey Ravi. Thanks a bunch for your nice words. Please check this video: kzfaq.info/get/bejne/Z72VrdV0ttLUco0.html Kind regards, Anders
@KT-uq3bs
@KT-uq3bs 2 жыл бұрын
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
@andersjensenorg 2 жыл бұрын
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
@andersjensenorg
@andersjensenorg 2 жыл бұрын
Find my complete Power Automate for desktop course here: kzfaq.info/sun/PLXXz88_TPiHpY_5bfeV8RAOHnBKgc-rtw 🙂
@efthimiosspiridopoulos9531
@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
@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: kzfaq.info/get/bejne/lbeCfJCK1JjMaIk.html Have a great day. Kind regards, Anders
@ildiandaprincipo163
@ildiandaprincipo163 Жыл бұрын
xlsm, I think for extension file
@king-tauro1166
@king-tauro1166 11 ай бұрын
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
@andersjensenorg 10 ай бұрын
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): kzfaq.info/get/bejne/rr12rZCEnpy8d6M.html Kind regards, Anders
@LapaConsult_Ex_Macraris
@LapaConsult_Ex_Macraris 2 жыл бұрын
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
@andersjensenorg 2 жыл бұрын
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
@LapaConsult_Ex_Macraris 2 жыл бұрын
@@andersjensenorg Thank you again it works!
@andersjensenorg
@andersjensenorg 2 жыл бұрын
@@LapaConsult_Ex_Macraris Great to hear 😊
@SrdjanS_Automations
@SrdjanS_Automations 2 жыл бұрын
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
@andersjensenorg Жыл бұрын
Hahaha, thanks Srdjan and sorry for the late reply - I hope you're still here (at the channel)? Kind regards, Anders
@chrisholden6658
@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
@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): kzfaq.info/get/bejne/rr12rZCEnpy8d6M.html Kind regards, Anders
@joseeduardohuertaornelas9864
@joseeduardohuertaornelas9864 Жыл бұрын
Great Video !!!
@andersjensenorg
@andersjensenorg Жыл бұрын
Thanks a ton, Jose 🙌🙂
@MrNelvaro
@MrNelvaro 4 ай бұрын
@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
@andersjensenorg 4 ай бұрын
Great question. Either build the logic in Excel or use Work Queues: kzfaq.info/get/bejne/pseJgsJy2LuYlZ8.html Kind regard, Anders 😊
@CP-zb3ky
@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
@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): kzfaq.info/get/bejne/rr12rZCEnpy8d6M.html Kind regards, Anders
@Hbedin92
@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
@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
@rogeryang18
@rogeryang18 2 жыл бұрын
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
@andersjensenorg 2 жыл бұрын
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
@rogeryang18 2 жыл бұрын
@@andersjensenorg Thank you so much! Make perfect sense to me.
@erikeringaad8638
@erikeringaad8638 2 жыл бұрын
@@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
@andersjensenorg 2 жыл бұрын
@@erikeringaad8638 Thanks a ton for taking your time giving us this feedback 😊😊
@HippieP629
@HippieP629 Жыл бұрын
@@andersjensenorg Ahh, thanks
@lookman06
@lookman06 2 жыл бұрын
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
@andersjensenorg 2 жыл бұрын
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: kzfaq.info/get/bejne/lbeCfJCK1JjMaIk.html Have a great day. Kind regards, Anders
@eduardciobanu1380
@eduardciobanu1380 3 ай бұрын
What if you wanted to save excel as... I got error when I tried it.
@andersjensenorg
@andersjensenorg 3 ай бұрын
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): kzfaq.info/get/bejne/rr12rZCEnpy8d6M.html Kind regards, Anders
@yowandafriskya.1502
@yowandafriskya.1502 Жыл бұрын
very nice tutorial
@andersjensenorg
@andersjensenorg Жыл бұрын
My pleasure, yowanda! 🙌🙂
@rvallejosguerrero
@rvallejosguerrero 10 ай бұрын
HI please, could you help me? how can I open a Excel file that ever is changing it name?
@andersjensenorg
@andersjensenorg 10 ай бұрын
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): kzfaq.info/get/bejne/rr12rZCEnpy8d6M.html Kind regards, Anders
@nghiepnguyen6241
@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
@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): kzfaq.info/get/bejne/rr12rZCEnpy8d6M.html Kind regards, Anders
@waveboardboy
@waveboardboy 9 ай бұрын
good
@andersjensenorg
@andersjensenorg 8 ай бұрын
Thanks a lot 😀
@fakruddinshaik5875
@fakruddinshaik5875 Ай бұрын
Hi jensen need your help on Excel automation in power automate can you please reply
@andersjensenorg
@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): kzfaq.info/get/bejne/rr12rZCEnpy8d6M.html Kind regards, Anders
@gydkam
@gydkam Жыл бұрын
Connections to External Data Sources popup window Resolution
@andersjensenorg
@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): kzfaq.info/get/bejne/rr12rZCEnpy8d6M.html Kind regards, Anders
@valapo80800
@valapo80800 Жыл бұрын
il se trouve dans quelle ville ce bistrot?
@andersjensenorg
@andersjensenorg Жыл бұрын
I don't understand, sorry 😔
@chrisakol
@chrisakol Жыл бұрын
Bat may halinghing ang boses? LOL.
@andersjensenorg
@andersjensenorg Жыл бұрын
What does that mean? 🙂
Files and Folders in Power Automate for Desktop (Full Tutorial)
30:06
If Barbie came to life! 💝
00:37
Meow-some! Reacts
Рет қаралды 78 МЛН
Gli occhiali da sole non mi hanno coperto! 😎
00:13
Senza Limiti
Рет қаралды 22 МЛН
Blue Food VS Red Food Emoji Mukbang
00:33
MOOMOO STUDIO [무무 스튜디오]
Рет қаралды 21 МЛН
👩‍💻 How to use Office Scripts in Excel & Power Automate
25:24
Kevin Stratvert
Рет қаралды 244 М.
Using Variables in Power Automate Desktop - Full Tutorial
36:24
Anders Jensen
Рет қаралды 19 М.
How to use Excel in Microsoft Power Automate Desktop
19:53
Anders Jensen
Рет қаралды 10 М.
🤖 How to use Microsoft Power Automate Desktop - Full tutorial
37:39
Kevin Stratvert
Рет қаралды 1,6 МЛН
Get Data from PDFs and Send to EXCEL with Power Automate Desktop!
18:52
Christine Payton
Рет қаралды 53 М.
If Barbie came to life! 💝
00:37
Meow-some! Reacts
Рет қаралды 78 МЛН