Microsoft Applied Skills: processes using Power Automate

Sign up for the Power Apps developer plan. Use a work or school email with Office 365 (Excel, SharePoint, Outlook) access, verify with Microsoft Authenticator, and access Power Automate environment.

Learn how to create a work or school email to sign in to the Power Platform, set up a free Microsoft 365 business trial, and access Power Automate.

Create a scheduled cloud flow in Power Automate that runs every 30 minutes to fetch Orlando's current weather with MSN Weather and save results to an Excel online workbook.

learn to extend a scheduled power automate flow by writing a row into an Excel Online Business table and inserting dynamic weather data from previous actions.

Learn how to share flows in Power Automate by designating owners and co-owners, managing run-only users, and sending a copy from the details screen or mobile app.

Explore creating cloud flows with templates in the power automate portal, configuring connectors like outlook, onedrive, gmail, and teams to automate email attachments, calendars, and reminders.

Create a SharePoint site and document library, add Word, Excel, and PowerPoint files, then build a Power Automate flow that filters by file extension and outputs a CSV, with notifications.

Learn to create a manually triggered flow in Power Automate that lists a SharePoint folder and filters results by a user-provided file extension, then outputs a CSV table or notification.

Create a CSV table from an array, customize columns and headers, and use a switch to route .docx and .pptx files to mobile notifications or others to email.

Design an automated flow that triggers on incoming emails with the word complaint in the subject, then emails your manager and adds the event to your calendar.

Build robust Power Automate flows by handling errors with parallel branches and conditional actions, sending emails after get manager succeeds or fails, and testing the flow.

Automate calendar entries in Outlook 365 by creating an event from a new email using Power Automate, including a UTC now start and end time via Power Fx.

Create an instant cloud approval flow to request leave with start and end dates, use approve/reject first to respond, add approved leave to calendar, or email if rejected.

Builds an approval flow in Power Automate using a Condition to auto-create a calendar event when approved, or email when denied, with date handling and And/Or logic.

Automate loading and filtering a spreadsheet in Power Automate to retrieve the last 12 hours of weather data, create an HTML table, and email it every Monday and Thursday.

Create an html table from prior data and email the results with Office 365 Outlook. Test the flow and review the last 12 hours of weather in Orlando, Florida.

Set up a SharePoint workflow that triggers on new files, checks for .docx, prompts for approval, and moves documents to approved or not approved folders while emailing the outcome.

Create a Power Automate flow with a nested approval condition, move approved or not approved files in SharePoint, and send an email notification.

Automate workflows with Power Automate—from weather logging and Excel storage to SharePoint file handling, CSV creation, approvals, and calendar updates.

Celebrate completing the Microsoft Applied Skills: processes using Power Automate course by reviewing automated, instant, and scheduled triggers, actions for notifications, and conditional logic with switch and approvals.