Power Automate Cloud for Business is a practical course in building automated workflows with cloud flows that connect Outlook, Teams, SharePoint, Forms and Excel, from triggers, approvals, conditions and expressions to error handling and using Copilot to build flows. It suits office staff, team leads and IT staff who want to cut repetitive work across Microsoft 365.
A lot of office work is still repeated by hand every day: copying data from emails into Excel, sending forms to a manager for approval, chasing documents that have not arrived or letting the team know in Teams when a new item comes in. Organisations that use Microsoft 365 already have Power Automate, which links Outlook, Teams, SharePoint, Forms and Excel into automated workflows without programming. The flows simply have to be designed properly, handle errors and keep running even when the person who built them moves on.
This course teaches Power Automate cloud flows that run in the cloud, not Power Automate Desktop. Learners start with automated, instant and scheduled triggers, build flows with Outlook and Teams, store data in SharePoint lists and Microsoft Forms, route approvals with Approvals, and use conditions, loops and expressions so flows can make decisions on their own. They then learn error handling, work with Excel Online, use AI Builder and Copilot in Power Automate to help build flows, and manage environments, sharing and flow ownership correctly. The course closes with a capstone that builds a department workflow from start to finish. (2 days, 6 hours per day, 12 hours in total, Beginner to Intermediate level.)
Course Details
This course teaches Power Automate cloud flows for organisations that use Microsoft 365. It runs for 2 days, 6 hours per day (12 hours in total, 09:00-16:00), as lectures with labs and workshops. Beginner to Intermediate level. It covers automated, instant and scheduled triggers, flows with Outlook and Teams, SharePoint lists and Microsoft Forms, Approvals, conditions, loops and expressions, error handling, Excel Online, AI Builder and Copilot in Power Automate, and environments, sharing and flow ownership, and closes with a capstone that builds a department workflow. It does not cover Power Automate Desktop; for desktop RPA, see the Power Automate Desktop course.
Section 1: Getting to Know Power Automate and Cloud Flows
How cloud flows differ from desktop flows and which work suits each
The parts of a flow: triggers, actions, connectors and connections
Automated, instant and scheduled triggers
Lab: build a first flow from a template and read its run history
Section 2: Lab: Flows with Outlook
Trigger on a new email, filtered by sender or subject
Save attachments to OneDrive or SharePoint automatically
Send HTML emails that include data from the flow
Lab: a flow that summarises request emails and files attachments in the job folder
Section 3: Lab: Notifications and Communication in Teams
Post messages to channels and chats from a flow
Instant flows started from a message in Teams
Adaptive Cards that ask a question and wait for the user's reply
Lab: notify the team of new work with a button to claim it
Section 4: Lab: SharePoint Lists and Microsoft Forms
Design a SharePoint list to act as the workflow's database
Trigger on a new Forms response and fetch the response details
Create, read and update SharePoint list items
Lab: take requests from Forms, log them in a list and notify the sender
Section 5: Lab: Approval Processes with Approvals
Approval types: first to respond, everyone must approve and multi-stage
Track and respond to approvals in Outlook, Teams and on mobile
Update the status in the list and report the outcome on approval or rejection
Lab: a purchase approval workflow that routes by spending limit
Section 6: Conditions, Switches and Loops
Conditions and switches to branch the flow
Apply to each for multiple items, and Do until
Filter array and Select to reduce the number of loop iterations
Lab: a scheduled morning flow that chases overdue items and notifies the owners
Section 7: Lab: Expressions and Working with Data
How dynamic content differs from expressions
Common text, date and number functions such as formatDateTime
Variables, Compose and reading JSON output from actions
Lab: format Thai dates, calculate due dates and generate document numbers
Section 8: Error Handling and Monitoring
Configure run after, and try and catch patterns with scopes
Set retry policies and timeouts on actions
Alert the owner when a flow fails, with a link to the failed run
Lab: make a flow fail on purpose, then catch the error and send an alert
Section 9: Lab: Excel Online and Reporting
Format Excel data as a table before using it in a flow
Read, add and update rows in Excel Online
Build an HTML table or CSV file from data and send it as a report
Lab: a weekly summary report emailed to the manager automatically
Section 10: Lab: AI Builder and Copilot in Power Automate
Create and edit flows by describing them in natural language to Copilot
Use Copilot to explain a flow and help write expressions
AI Builder basics: extract data from documents and summarise text with prompts
Lab: extract data from PDF invoices into a SharePoint list
Section 11: Environments, Sharing and Flow Ownership
Environments, solutions and connection references at a basic level
Co-owners and run-only users so flows keep running when the builder moves on
Standard and premium connectors and the licences involved
Organisational data policies, and conventions for naming and storing flows
Section 12: Workshop: Capstone Department Workflow
Choose a problem from your own work, such as leave, purchase or complaint requests
Design a flow that uses Forms, a SharePoint list, Approvals and Teams
Add error handling and an automatic summary report
Present the work, review it together and wrap up with a go-live checklist
No public rounds are open right now. Join the waiting list and we will contact you first when the next round opens, or ask us on LINE. Or call 02-570-8449 or 088-807-9770
Built for Office, admin, HR and finance staff with repetitive document and approval work · Team leads who want fewer manual steps and easier tracking of their team's work · IT staff and Power Platform makers who build workflows for different departments Background you should have: Confident use of Microsoft 365, including Outlook, Teams, SharePoint and Excel · No programming needed, but familiarity with basic Excel formulas helps Not sure the fit is right? Talk to our team on LINE @itgenius or call 02-570-8449.
THB 7,500 (currently THB 6,750 on promotion). The course runs 12 hours. The price excludes 7% VAT (for payment in a company's name). Pay by bank transfer to the company account, confirm it on our payment page, and we can issue the receipt or tax invoice in your company's name.
Yes. Everyone who completes the course receives a Certificate of Completion from IT Genius Institute. Each certificate carries its own number, and anyone holding that number can verify it online on our certificate page, so you can add it to your portfolio or pass it to HR as evidence of training.
You can attend onsite at IT Genius Institute or arrange to join online, and we also run it as a private in-house session for your team. Ask about dates and venues on LINE @itgenius or call 02-570-8449.
Yes. You may retake the same course free of charge in a later round, under the institute's conditions. Tell our team which course and round you attended, and we will check it and offer you the rounds that still have seats. Ask us on LINE @itgenius or call 02-570-8449.
Enrol online with the registration form on this page. You can register several attendees at once and enter your tax ID and billing address for the tax invoice. Or request a company quotation straight from the quote button. For anything else call 02-570-8449 or reach us on LINE @itgenius.
Many organisations already use Microsoft 365 Copilot for everyday work. The next step is building their own AI agents that know the organisation's data, answer questions from internal policies and documents, and take action on people's behalf, such as opening…
Microsoft เปิดดาวน์โหลด Power Automate เป็นซอฟต์แวร์ RPA (robotic process automation) Power Automate เป็นบริการที่ช่วยให้คุณสร้างเวิร์กโฟลว์แบบอัตโนมัติระหว่างแอปและบริการต่าง ๆ เพื่อลดเวลาหรือลดงานซ้ำๆ ลง เช่น การสร้างข้อมูลพิมพ์ข้อมูลลงใน Excel การอ่านค่าใน…
Many Thai organizations already run Microsoft 365 across Word, Excel, PowerPoint, Outlook and Teams, so enabling Microsoft 365 Copilot is the fastest way to bring AI into daily work without changing tools. This course teaches Copilot in real work across every…
