If and Loop in Power Automate for Desktop (Full Tutorial)

This full video tutorial shows how to use If and Loop actions in Microsoft Power Automate for Desktop. The full use case takes you through the best practices in using If and Loop actions in your RPA development.
📂 Course materials: andersjensen.org/microsoft-po...
VIDEOS FOR YOU:
🔹 Power Automate for Desktop Full Tutorial Playlist: • Power Automate Desktop...
🔹 Power Automate Cloud Beginners Course: • Microsoft Power Automa...
👨‍👩‍👧‍👦 Discord: / discord
- Join my network with 2800+ RPA Developers, where we solve RPA problems, network, and help each other upgrade our careers. It's free!
FOLLOW ME:
💼 LinkedIn: / andersjensenorg
📸 Instagram: / andersjensenorg
👨 Facebook: / andersjensenorg
🐦 Twitter: / andersjensenorg
💌 Email Newsletter: andersjensen.org/email-newsle...
MY MONITOR (Amazon affiliate):
🖥️ Samsung 49-inch CRG9 Curved Monitor = geni.us/MDpejc
- If you are buying this, I can recommend the Mi Monitor Light Bar = geni.us/3Wwad
0:00 Intro
We're creating a simple game in Power Automate for Desktop. The game takes you through the If and Loop actions, as well as best practices in RPA development. First, create a new variable and assign a random value to it (our secret number). Then, use a Display input dialog action to take user input (the guessed number).
3:37 If
The If action asks a question and performs actions based on the outcome of the condition. Inside the If condition, we use a Display message to give the user a hint in the guessing game. Next, drag in an Else action to specify what will happen if the If condition is not true.
5:23 Loop
A Loop action also has a condition, and a Loop runs over and over as long as the condition is true. If nothing changes, it will run forever. Therefore it's best practice to always add something so the Loop stops at some point. The simple solution is to implement a counting variable and let the loop run X times. It's also shown how to make more statements in one condition using the AND operator.
15:13 Generate a random number
Use the Generate random number action to generate a random number instead of our static one.
#powerautomate #rpa #microsoft

[@andersjensenorg]

This is another lesson in the Power Automate for Desktop full course 🙌🔥 LIKE AND SUBSCRIBE IF YOU ENJOYED! Instagram: @andersjensenorg

[@nathanmora9734]

3 Years ago I was hired as an RPA Developer using UiPath. I Watched your videos daily to help me and now we have moved to Power Automate, and I'm here with you again lol. Thanks for all your content it has been helpful for me on my RPA journey!!

[@andersjensenorg]

Haha, I'm so glad to hear, Nathan! 🙂 Have you seen my discord community of 8000+ RPA developers. It's of course free and the link is in the video description. Kind regards, Anders

[@Ganesh749]

Thank you Anders Jensen, you are really awesome teaching and spreading knowledge about RPA. Your contents were indeed very helpful and we are learning a lot about RPA from this channel. can you please make one video on power automate license for enterprise and best practices while choosing right license

[@andersjensenorg]

Thank you so much for your kind words and support! I'll consider creating a video on Power Automate licenses for enterprises and best practices. Kind regards, Anders

[@MarkStettler]

Thank you Anders! Count yourself among the awesome teachers found on KZbin!

[@andersjensenorg]

Thanks a ton, Mark Stettler 🤩 Have a great day. You're more than welcome at my Discord, where we're 5000+ RPA developers networking and solving problems: kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@sazzarello]

Another excellent learning experience. TY!

[@andersjensenorg]

My pleasure, appreciated the nice words 😊 Kind regards, Anders

[@arielreina8552]

Andres really well explained and straight to the point. Excellent

[@andersjensenorg]

Thanks a ton, Ariel 😊

[@atiqure2000]

your channel is one of my best discoveries. keep it going

[@andersjensenorg]

Hey Syed, I'm so happy for your message 😍 Have you seen my new videos regarding the topic: If and Switch: kzbin.info/www/bejne/fmqwaod9i9Rmq8U Loop: kzbin.info/www/bejne/h4CwYXp9bNCShtk Kind regards, Anders

[@atiqure2000]

@@andersjensenorg Not yet. But will do it soon and every other video on PA.

[@febsil66]

Thanks a lot Anders!!! One more awesome tutorial!!!

[@andersjensenorg]

Thanks a lot, Fernando Silva 🤗 Your feedback helps me immensely. You're more than welcome at my Discord, where we're 5000+ RPA developers networking and solving problems: kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@craignorton8678]

Great video from Anders. Keep up the great work.

[@andersjensenorg]

Thank you, my friend. Did you start with PAD as well? 💪😄

[@craignorton8678]

@@andersjensenorg Yes. Doing a Proof of Concept comparison across Power Automate for Desktop, UiPath, and Nintex RPA.

[@farhadb7811]

very good. i enjoyed your tutorial very much

[@andersjensenorg]

You're very welcome, Farhad B - your support helps me a lot 😍 You're more than welcome at my Discord, where we're 5000+ RPA developers networking and solving problems: kzbin.info/www/bejne/roipq2CJbpuLfdE

[@PitakYT]

Thank you very much for good video training.

[@andersjensenorg]

Thanks a lot, Pitak 🙂

[@HammamDisini]

Great video. Thanks for sharing.

[@andersjensenorg]

Hey Hammam Disini - Excel. Thanks a lot 😊 Have a great day. You're more than welcome at my Discord, where we're 5000+ RPA developers networking and solving problems: kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@NickWindham]

Great example tutorial!

[@andersjensenorg]

Hey Nick Windham. Thanks a lot 😊 Have a great day. You're more than welcome at my Discord, where we're 5000+ RPA developers networking and solving problems: kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@suraj_singh321]

Anders Jensen Uipath RPA make a video on Excel Automation ignore empty cells and write cell at particular range within the cell specified range using uipath

[@andersjensenorg]

Hey Suraj. I don't 100% understand the question. Can you please post it on my Discord and be a little bit more specific? 😊 The link is in the video description. Kind regards, Anders

[@suraj_singh321]

@@andersjensenorg can you share your mail Id so I can Illustrate you

[@pranabgarg]

Post something about power automate desktop reading from Excel and updating in SQL server with query or querying with like parameter, cover if we reuse the same connection is there an overhead?

[@andersjensenorg]

Hey Pranab. Thanks a lot for feedback. That will be a narrow video, and I don't see it coming in the near future. BUT. For the Excel part check this: kzbin.info/www/bejne/sIfZkoV5j9aNbac and the for SQL part: Coming soon. Then you can combine it yourself 😊

[@pranabgarg]

@@andersjensenorg I'm building it myself so know some pitfalls which will not work.

[@Sauroflorence]

I am facing a "random" issue when I run my flow (it is a loop to export some report from SAP) from Power Automation Dashboard or using a keyboard shortcut. Sometimes the flow stops a the end of FIRST CYCLE of the loop, without any runtime error...sometimes it runs correctly till the END of the loop. If I run the flow from inside the Power Automate Editor it works smoothly 100% of times. What I should check ? I have updated the Power Automate Desktop to last release.

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

[@jafarbasha4394]

Hiii, i have a requirement that i need to get latest Textfile in folder by searching some keyword after i need to copy to my required folder using UiPath, any idea on this

[@andersjensenorg]

So you sarch for e.g. Tesla, then find all txt with Tesla in title and then you want the newest copied to a new folder?

[@jafarbasha4394]

@@andersjensenorg yah exactly

[@andersjensenorg]

@@jafarbasha4394 Cool, I'll make a video 😊

[@jafarbasha4394]

@@andersjensenorg if it will be today, i will more happy ☺️Thank you

[@Pratzy6365]

Hi how to decrement Loop in Power automate desktop

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