Microsoft Power Automate - Tutorial for Beginners 2021

This video tutorial shows how to start with Microsoft Power Automate. As a beginner, you're taken through building a complete Power Automate flow from start to finish.

The tutorial takes you through an example, where you will learn to automate Microsoft Excel, Outlook, and Onedrive and work with Date and Time, Conditions, and Expressions. You'll learn how to build a birthday email sending flow, where we read an Excel Sheet of employees and then send emails to the employees that have birthdays that day.

LINKS:

VIDEOS FOR YOU:

NETWORK/SOLVE PROBLEMS IN MY GROUPS:

0:00 Intro
Microsoft Power Automate is very easy to learn, and there is a high salary if you get good because there is a massive demand for Power Automate Developers.

0:58 Open Power Automate and supporting Apps

9:05 Read Data from Excel
To read data from an Excel table, you should use 'List rows present in a table'. Remember to have your Excel data formatted as a table. To iterate through each row in the Excel table, use the 'Apply to each activity'. Use a condition to check if the birthday equals a specific date (today).

13:22 Send an Outlook Email
Use 'Send an Email' to send an email. It's straightforward as it's as simple as sending an email in Outlook. We create the email with both static and dynamic data that can change, so we personalize it.

17:02 Automated Birthday Emails (Advanced)
We expand our solution and make sure that our Power Automate flow can read all DateTime data.

19:56 Split Expression
We use a Compose with a Split expression to split the date into a day, month, and year and then parse the day and month, so we can use it. Expressions are a powerful way to modify our data.

21:52 Local Time and Power Automate Time
Power Automate uses UTC time, and if we use this, our flows won't be accurate. Current Time gets the Power Automate time. Then we convert it to our desired format (here month and day, MM/dd).

25:00 Concat Expression
We are concatenating elements from our array with the Concat function.

27:07 Update an Excel Row
We use the 'Update a row' action to update our excel data.

--
FOLLOW ME:

#microsoft #powerautomate #microsoftoffice

[andersjensenorg]

If the video helped you, let me know here in the comments, that will help me and the channel a lot 🙏 Thanks for watching and all your support 🙂

[immigration]

Thank you, Anders. Excellent video tutorial. Simple, easy to understand, to the point. Exactly what a non-techy needs to know.

[TheRealVinny]

Thank you Anders! This is a great video. It has helped me do new things already. I like that you added a bit of "coding" into the "low code" app as well.

[paulajimenez]

Thanks a lot, Anders!!! It's a great video and it is so easy to follow!!!! I'll check more of your videos! Thanks again!

[jesonjoshua]

Solid 30 mins for a beginner like me ! Good one Anders! 👍🏾👍🏾

[haydenr]

Great tutorial, already putting this to use at work. Thanks again Anders :)

[alicemorili]

Really enjoy the power automate video you made. Look forward to learn more 😁

[berggrog]

Wicked good video! Thank you so much for a whole world of reasons. Great information and nicely presented!

[nicknguyen]

Thank you so much for all of you help. You have just saved my life.

[pepper_lab]

THIS IS EPIC VDO !!!! GREAT THANKS

[patricrademakers]

Anders, thanks a lot. The video is very helpfull en very easy to follow.
Its a good start for me! 👍

[apocalipmon]

Hello :) greetings from Costa Rica, thank you very much for your lessons, I'm learning a lot ! You're doing great, keep it up !

[muhammetmelikkolgesiz]

You have earned a subscriber sir. Your videos are very helpful for me. Thank you for your hard work!

I really appreciate, and thanks for sharing this .

[SunflowerSyla]

Would love if you could do a video on how to rename files based on their content (especially word docs and PDFs)! I know how to do this with AHK but many managed devices provided by employers hate open source software, so MS Power Automate is the go-to. Even just how to batch rename things (like add the date, or remove the word "Draft") would be so useful! Love your videos!

[fabrice]

It's been a while since I didn't took some time to watch your quality content. Thank you Anders.

[juliekramer]

Thank you Anders for this video. It was very helpful :)
The only issue I had when running the flow, it did not like the birthday column on the spreadsheet as a date so I made it a text column and the flow ran without issues.

[aflyudr]

So crisp and informative! Greetings from Cph :)

[hssey]

Good job! You are gifted in teaching.😀

[soldeal]

Thank you for your video it is excellent, Really I didn't know this program and it's great.
You have a great channel and thanks again for the info