Learn Power Automate Step By Step With Real Time Projects

Explore Power Automate basics and six flow types: automated cloud flow, instant cloud flow, scheduled cloud flow, desktop flow, business process flow, and process advisor, with practical triggers and examples.

Explore flow templates in the Power Automate portal, learn to find, search, and apply templates like approval and attachment flows, connect to connectors, and create flows.

Learn to create flows and use connectors in Power Automate, selecting triggers like when an item is created or modified, and explore built-in, standard, premium, and custom connectors.

Create maintainable flows by using meaningful step names and added comments, improving readability for others who may maintain the flow, such as approvals and condition checks in Power Automate.

Learn how to create maintainable Power Automate flows by using scope to group logic, leveraging renaming and comment features, and implementing try/catch patterns for readability and separation of concerns.

Explore variables in Power Automate basics, including initializing typed variables (boolean, integer, float, string, object, array) and reusing site address and list name across actions.

Learn to use the compose action in Power Automate to hold static values like site address and list name, and understand when to choose compose over variables in a flow.

Build the Excel uploader tool in Power Automate to push uploaded data into a SharePoint list. Learn rest API, Excel Online Connector, select and filter actions, and error logging.

Build an automated cloud flow in Power Automate that triggers on new Excel uploads in SharePoint. Read data via rest api and prepare it for loading into a SharePoint list.

Learn how to extract data from an Excel file using the Excel Online connector in Power Automate, including obtaining document library and file IDs, creating a table, and listing rows.

Learn how to use Power Automate data operations to filter arrays and map selected fields for a SharePoint list, including handling lookups and date formatting.

Explore looping in Power Automate to upload an Excel file into a SharePoint list via apply to each, creating items from selected records in the Excel uploader tool.

Implement try and catch logic in Power Automate using scope and parallel branches, handle success and failure, notify via Teams, and extract the uploader's email from JSON.

Learn to build the run history URL in Power Automate to help operations teams quickly diagnose failed flows.

Master Power Automate basics with a custom error log that captures flow name, step, status, error message, and run history URL in SharePoint for audit trails.

Explore how to use trigger conditions in Power Automate to prevent runs on non-Excel uploads, using a compose expression to check the file extension and test positive and negative cases.

Demonstrates using conditional control in Power Automate to validate uploads, route true/false branches, and notify users via Teams when a non-excel file is uploaded, with nested conditions and error handling.

Learn to use the Power Automate approvals connector to create and start approvals, wait for responses, and handle options like first to respond, wait for all responses, custom responses.

Learn to build a multi-level, serial approval flow in Power Automate by creating expense types and expense reports lists, triggering on item creation, and routing approvals step by step.

Build a conditional approval flow in Power Automate to manage travel requests, routing >500 to manager then HR, and <500 directly to HR, with SharePoint list updates.

Learn to configure a Power Automate flow with SharePoint lists to manage help desk requests, defining per-type approvals, first-to-respond or everyone-must-respond rules, and manager approvals.

Implement a reminder system within the configurable flow using Power Automate to trigger manager approvals, wait for responses, and send a Microsoft Teams adaptive card reminder until approval is completed.