Power Automate Training Singapore

Learn to integrate and automate with Power Automate.

All courses running remotely, join us live online.

Microsoft's traditional office systems sit alongside a new wave of computing power within reach of end-users, in a way that has never been available before. Power Automate is a key application within Microsoft 365 which allows end users to connect applications and automate workflows and processes.

Learn how to work with data and JSON, arrays, expressions and advanced functions to build smart automated workflows. View our detailed course outline below.

Power Automate Training Singapore

4.8

see reviews

Learn to automate workflows with Power Automate and start tapping into the Power Platform. Join remotely from Singapore.

430 355 SGD

10 max

1 day

Upcoming Courses:

Singapore

Date

Course

City

Status

Wed 10-Feb-21

Wed 10 Feb

Power Automate

Singapore

Status: Confirmed

Confirmed

Book Now

Fri 19-Mar-21

Fri 19 Mar

Power Automate

Singapore

Status: Scheduled

Scheduled

Book Now

Thu 29-Apr-21

Thu 29 Apr

Power Automate

Singapore

Status: Scheduled

Scheduled

Book Now

Wed 30-Jun-21

Wed 30 Jun

Power Automate

Singapore

Status: Scheduled

Scheduled

Book Now

Fri 9-Jul-21

Fri 9 Jul

Power Automate

Singapore

Status: Scheduled

Scheduled

Book Now

Fri 6-Aug-21

Fri 6 Aug

Power Automate

Singapore

Status: Scheduled

Scheduled

Book Now

Scheduled

Taking enrollments.

Confirmed

Taking enrollments.

Few Seats left

Book Now.

Sold Out

Try another date.

Power Automate Singapore Course Details

Price

430 355 SGD

Duration

1 day

Times

9am - 4pm ( approx )

Class Size (max)

Class Size (avg)

Reference Materials

Provided

CPD Hours

6 hours

Delivery

Instructor-led training

Live Online

Address

Centennial Tower, Levels 21 & 34, 3 Temasek Avenue, Singapore, 039190, Singapore

Power Automate Course Outlines

Power Automate

download course pdf

View Course

Other Courses

Microsoft Excel Specialist Training Courses

Other Courses

Course Rating

4.8 5 Power Automate Training Courses

4.8 out of 5
25089 Student Reviews

Skills Test

Try our short skills test and find out which course is right for you.

skills test nexacu

skills test

Contact Us

What do I need to know to attend?

The course will build on the base knowledge learned in our Office 365 Beginner and Intermediate courses. You should have completed these courses or have basic familiarity with Power Automate.

Power Automate Singapore Learning Outcomes

On completion of this course you will know how to:

Handle errors and debug Power Automate flows
Create String expressions
Understand how to use JSON in a flow
Work with Arrays, Functions and Data and Time expressions

Configure SharePoint Approval Flows
Create and Use Adaptive Cards in Teams
Tap into the Power Platform
Explore the basics of Cognitive Services and AI in Office 365

Power Automate Singapore Course Content

Introduction
Course Objectives
How this manual is organised
What is Office 365?
Office 365 Subscriptions

Power Automate – Error Handling
Introduction to Error Handling
Error Handling in Power Automate
Error Types in Power Automate
Create an error free Flow in Power Automate
Cause the Flow to error
View successful actions & triggers
View failed actions & triggers

Power Automate – Error Handling cont'd
Error handling techniques
Configuring Run Conditions
Handle the error with a parallel branch
Add an action after the parallel branches
Handle the outcome of all branches
Use Terminate to successfully end a Flow
More complex but efficient alternative error handling

Power Automate – Debugging
Debugging in Power Automate
View the output of an action
Using Compose to see data
Variables for debugging
Using a variable to capture debug information
Variables versus Compose
View a complex output from an action
Debugging with Static Results
Causing an error with Static Results
Advice for Debugging and Error Handling

Power Automate – Data and JSON
Basic data Types in Power Automate
Object and Array data types
What is JSON
JSON examples
How to handle JSON
How a Flow is defined (JSON)
A string of JSON in a Flow
An Object of JSON in a Flow
Handling data in JSON format
Parse JSON data
Extended Topic – JSON Schemas
More complex JSON data
Accessing an array of JSON data

Power Automate – Expressions
What is the Workflow Definition Language
The Workflow Definition Language Schema
The functions reference for Workflow Definition Language
Writing Expressions in Power Automate
The expression pane

Power Automate – String Expressions
A Basic String function
Combining String functions together
Power Automate – Variables in expressions
Variable naming conventions
The variables() function
Referencing a variable in another function

Power Automate – Arrays & Collections
What is an array
What is a collection
Defining an array
Looping through an array
Filtering an array
The length of an array
Find if an element exists in an array
Accessing an array element by index

Power Automate – Data & Math Expressions
Arithmetic Functions
Conversion functions
Power Automate – Date/Time types and expressions
The Date and Time data type
Date and Time functions
Time Zone functions
Formatting Dates and Times

Power Automate – Advanced Functions
The workflow() function
Data from the trigger
The dot (.) operator
Data from an action
Operators to access data fields
Avoiding errors with NULL or missing fields
The ? operator
Have a default if value is null
Other function groups

Power Automate – Configuration
Introduction to limits
Trigger Conditions
Tracked Properties
Create a Tracked Property
Accessing Tracked Properties
A calculation from a Tracked Property
Extended Exercise – Using a calculated output for Tracked Property
Other Power Automate settings
Secure Inputs and Outputs
Concurrency Control
Timeouts and Retries
Other settings

SharePoint Automation
Power Automate and SharePoint
SharePoint Triggers
SharePoint Actions
SharePoint caution with actions and triggers
Perform an action on an item using Power Automate
Share a SharePoint Flow
Select file and initiate the Flow
Use SharePoint metadata to advise user
Expand the SharePoint Flow functionality

SharePoint Automation cont'd
Content Approval in SharePoint
SharePoint Approval Process
SharePoint Workflows
Using Power Automate to manage SharePoint Approvals
Create a Flow to Approve SharePoint files
Add an approval action to the SharePoint Flow
The approval response handling
Testing the approval Flow

Advanced SharePoint Actions via API
The magic behind Power Automate
About Application Programming Interfaces
API Methods
Other API considerations
The SharePoint API action
The SharePoint API via a web browser
Finding the site Title from the API

Advanced SharePoint Actions via API cont'd
Filter only needed data using ODATA format
Accessing the property only
Use the Title in our approval Flow
More ODATA query examples
ODATA filters
Format of a response
References for the SharePoint API

Teams – Adaptive Cards
Types of Teams Apps
What are Adaptive Cards
Uses for Adaptive Cards in Teams
Structure of an Adaptive Card
Templates in Adaptive Cards
A basic Adaptive Card sample
Modify the sample Adaptive Card JSON
Populate an Adaptive Card with data from the Flow
Adaptive Card Schema
Text Formatting a Card
Adaptive Card Designer
Create an Adaptive Card in designer

Teams – Adaptive Cards cont'd
Test run the new card with Power Automate
Add dynamic fields to the custom card
Modify the card in designer with fields intact
Adding inputs to the trigger
Extended Topic – Actions on an Adaptive card
Action buttons on cards
Action on elements
Adding actions to a card
Other types of card elements
At mentions in cards (alternative)

Power Platform in SharePoint
Why is the Power Platform so useful
What are Power Apps
Power Apps and Data (SharePoint)
Create a SharePoint list
Manage the list with a 3-screen Power App
Trying to break the Power App
Modify the SharePoint column
Add an option to the column
Modifying the Power App
Saving, Sharing and Publishing the Power App
Housekeeping to clean-up our environment

Cognitive Services
Traditional Computing
What is Artificial Intelligence
What is Machine Learning
Uses for Artificial Intelligence
Microsoft Cognitive Services
What is Azure
Text Analysis
Image Analysis

Cognitive Services cont'd
Computer Vision
Facial Recognition
Face Verification
Face Detection
Emotion Recognition
Artificial Intelligence in Office 365
Artificial Intelligence in the Power Platform
AI Builder in Power Platform
Where to from here

Contact Us

phone

enquiry

What is Remote Training?

Login from your desk
Instructor-led Training
Your Questions Answered
Innovative Content
Microsoft Certified Trainers

Was a great session downloading the office 365 capabilities! -Office365 Intermediate Brisbane

Selvin - Office365 Intermediate, 20 Jan 2021.

Great course with some really helpful and insightful tips and tricks which I can use in the work place and beyond. Steven was an amazing trainer who explained each of the processes clearly and easily to understand. Thank you so much! -Office365 Intermediate Remote Online

Kaimani - Office365 Intermediate, 20 Jan 2021.

Great Course. Steven was a great instructor, was very clear in his instruction and kind whenever he had to re-address any content. He was also good at trying to cover the topics we were wanting to focus on. -Office365 Intermediate Brisbane

Emma - Office365 Intermediate, 20 Jan 2021.

This was a great opportunity to fill in so many gaps I had in my day to day use of Power BI. Very user friendly and easy to follow. -Power BI Advanced Brisbane

John - Power BI Advanced, 20 Jan 2021.

Jason was great and the course was extremely informative. -Power BI Beginner Canberra

Mark - Power BI Beginner, 20 Jan 2021.

Examples were useful, good spread of key functionality and handy tips -Power BI Beginner Canberra

Ben - Power BI Beginner, 20 Jan 2021.

It is a great course and Jason has done it very interestingly throughout the day. Thank you. -Power BI Beginner Canberra

Hemamali - Power BI Beginner, 20 Jan 2021.

Learnt a lot thanks Jason -Power BI Beginner Canberra

Mal - Power BI Beginner, 20 Jan 2021.

Good beginners course - came away with a lot -Power BI Beginner Canberra

Karin - Power BI Beginner, 20 Jan 2021.

Even though this course was conducted remotely, I still felt I got a lot out of this course. -Power BI Beginner Canberra

Fiona - Power BI Beginner, 20 Jan 2021.

Great Course. Soooo much information! Excited to get back to work tomorrow to check it out with relevant data! -Power BI Beginner Canberra

Rachel - Power BI Beginner, 20 Jan 2021.

Very good course. Easy to follow, great instructor, personable and enlightening. -Power BI Beginner Canberra

Logan - Power BI Beginner, 20 Jan 2021.

John was very knowledgeable and was able to get through the content today. Well structured learning. John did some extra work to address my queries and has taken some time after the course to follow up on a question -Project Advanced Melbourne

Vincent - Project Advanced, 20 Jan 2021.

Was very well structured, informative and practical, great 1 on 1 communication from Ken, special care was taken by him on the topics that required it. :) -Excel Advanced Melbourne

Harrison - Excel Advanced, 20 Jan 2021.

Thanks Domenic. -Power BI Intermediate Perth

Tony - Power BI Intermediate, 19 Jan 2021.

Good course. -Power BI Intermediate Perth

Kristal - Power BI Intermediate, 19 Jan 2021.

Course was great, Domenic is an excellent trainer. -Power BI Intermediate Perth

Scott - Power BI Intermediate, 19 Jan 2021.

Good stuff! -Power BI Intermediate Perth

Gian - Power BI Intermediate, 19 Jan 2021.

Another good session. -Power BI Intermediate Perth

Dionysius - Power BI Intermediate, 19 Jan 2021.

Domenic was a great trainer; would highly recommend -Power BI Intermediate Perth