• Home
  • WSQ - Microsoft Power Platform Functional Consultant (PL-200)

Exam PL-200 Microsoft Power Platform Functional Consultant Exam Prep

Course Information

  • Sessions 5 days
  • Duration 40 hrs
  • Level Intermediate
  • Assessment 2 hrs

Venue

12 Woodlands Square #07-85/86/87 Woods Square Tower 1, Singapore 737715. 5 mins walk from Woodlands (NS9) MRT station.

The venue is disabled-friendly.

Skills Framework

TSC Title
Applications Integration
TSC Code
ICT-DIT-3003-1.1

Learning Outcomes

By end of the course, learners should be able to:

  • LO1: Identify opportunities and perform feasibility scans for dataverse and Power App applications.
  • LO2: Utilise Business Flow and Power Automate to integrate functions across programs with API-level integration.
  • LO3: Execute tests in Power Virtual Agent and Power BI to verify their functioning across platforms.
  • LO4: Implement modifications to Power Platform with Power AI Builder and highlight technical issues.
Download Course Brochure

Certification

  • Certificate of Completion from Tertiary Courses - Upon meeting at least 75% attendance and passing the assessment(s), participants will receive a Certificate of Completion from Tertiary Courses.
  • OpenCerts from SkillsFuture Singapore - After passing the assessment(s) and achieving at least 75% attendance, participants will receive a OpenCert (aka Statement of Achievement) from SkillsFuture Singapore, certifying that they have achieved the Competency Standard(s) in the above Skills Framework.

Free Certificate Practice Exams

Take Free Certificate Practice Exams at exams.tertiaryinfotech.com.

You can also purchase Certificate exam vouchers at exams.tertiaryinfotech.com.

WSQ - Microsoft Power Platform Functional Consultant (PL-200)

Course Code: TGS-2024042588
  • WSQ
  • SkillsFuture Credit
  • PSEA
  • UTAP
  • SFEC
  • Absentee Payroll
  • MCES

1 Review(s) | Add Your Review

What's This Course About

Embark on a transformative journey to become a Microsoft Power Platform Functional Consultant with our targeted exam preparation course. This course is meticulously designed to arm you with the skills and knowledge essential for mastering the Microsoft Power Platform. Starting with identifying opportunities and conducting feasibility scans, you'll gain expertise in leveraging the capabilities of Dataverse and Power App applications. This foundational knowledge sets the stage for building sophisticated business solutions that can significantly enhance operational efficiency.

Further, the course dives into the practical applications of Business Flow and Power Automate, emphasizing on API-level integration to streamline functions across various programs. This hands-on experience is invaluable for understanding the intricacies of system integration and automation. In addition, you will learn to execute rigorous tests in Power Virtual Agent and Power BI, ensuring these tools function seamlessly across platforms. The course culminates with insights into implementing modifications using Power AI Builder, along with troubleshooting and highlighting technical issues, equipping you with a comprehensive skill set to excel in the Microsoft Power Platform environment. By the end of this course, you will be well-prepared to take the Microsoft Power Platform Functional Consultant Exam and step into a role that demands a blend of technical expertise and strategic acumen

Microsoft Learning Partner

We are Authorised Microsoft Learning Partner (Org ID:  5238476). To get the official Microsoft certification, please register your certification exam at Pearson Vue Test Center.

Certification Exam at Pearson Vue

We are Authorised Pearson Vue Testing Center. Once you have prepared for the exam, you can register for the certification here. The course fee does not include the certification exam fee.

You can purchase the exam voucher (one of the lowest prices in Singapore) at Microsoft Role-Based Certification Exam Voucher.

WSQ Funding

Full Fee $2,500.00 Before GST
GST $225.00 9% of fee
Baseline Nett $1,475.00 SG/PR age 21+ · 50% funded
MCES / SME Nett $975.00 SG age 40+ · 70% funded
SkillsFuture Enterprise Credit (SFEC)

Eligible Singapore-registered companies can tap on $10000 SFEC to cover out-of-pocket expenses.Click here to submit SkillsFuture Enterprise Credit

SkillsFuture Credit (SFC)

Eligible Singapore Citizens can use their SFC to offset course fee payable after funding but the $4,000 Additional SFC (Mid-Career Support) cannot be used. Click here for SkillsFuture Credit submission

UTAP

Eligible NTUC members can apply for 50% of the unfunded fee from UTAP, capped up to $250/year and for members aged 40 and above, capped up to $500/year. Click here to submit UTAP

PSEA

Eligible Singapore Citizens can use their PSEA funds to offset course fee payable after funding.

To check for Post-Secondary Education Account (PSEA) eligibility for this course, Visit SkillsFuture (course code: TGS-2024042588)
  • Scroll down to “Keyword Tags” to verify for PSEA eligibility.
  • If there is “PSEA” under keyword tags, the course is eligible for PSEA.

Once you are eligible for PSEA, please download and fill up the PSEA Withdrawal Form and email to us. 

Course FeeBefore Funding

$2,500.00 (GST-exclusive)
$2,725.00 (GST-inclusive)

Course Date

Course Time

* Required Fields

Additional Note

Please bring your own laptop for hands-on training. If you don't have laptop, we can provide spare laptop for training use.

Post-Course Support

  • We provide free consultation related to the subject matter after the course.
  • Please email your queries to enquiry@tertiaryinfotech.com and we will forward your queries to the subject matter experts.

Cancellation & Reschedule Policy

  • You can register your interest without upfront payment. There is no penalty for withdrawal of the course before the class commences.
  • We reserve the right to cancel or re-schedule the course due to unforeseen circumstances. If the course is cancelled, we will refund 100% for any paid amount.
  • Note the venue of the training is subject to changes due to availability of the classroom.

Course Details

Course Details

What You'll Learn

Topic 1 Describe the business value of the Microsoft Power Platform

Explore Microsoft Power Platform

Describe the business value of the Power Platform

Explore connectors and Microsoft Dataverse

Use Artificial Intelligence to increase productivity

Explore the business value of the Power Fx

Describe how Power Platform works with Microsoft 365 apps and services

Explore how Power Platform works with Microsoft Teams

Describe how Power Platform works with Microsoft Dynamics 365 apps

Explore how Microsoft Power Platform apps work together

Describe how Power Platform solutions consume Microsoft Azure services

Topic 2 Identify foundational components of Microsoft Power Platform

Describe Power Platform administration

Describe Power Platform security and governance

Explore Microsoft Dataverse

Examine Power Platform connectors

Exercise - Build a basic Dataverse data model

Topic 3 Create and manage environments in Dataverse

Environments in Microsoft Dataverse

Developer environments

Create and manage an environment

Create an instance of a Microsoft Dataverse database

Add users and roles within an environment

Manage settings in an environment

Environment operations

Topic 4 Create tables in Dataverse

Introduction to Microsoft Dataverse

Table characteristics

Dataverse logic and security

Dataverse auditing

Dual-write vs. virtual tables

Topic 5 Create and manage columns within a table in Dataverse

Define columns in Microsoft Dataverse

Column types in Microsoft Dataverse

Add a column to a table

Primary name column

Restrictions that apply to columns in a table

Create an auto numbering column

Create an alternate key

Topic 6 Working with choices in Dataverse

Define choice column

Choice columns

Standard choices column

Topic 7 Create a relationship between tables in Dataverse

Relate one or more tables - Introduction

Relationship types that are available in Microsoft Dataverse

Create a one-to-many relationship between tables

Create a many-to-many relationship between tables

Edit or delete relationships

Topic 8 Create and define calculation or rollup columns in Dataverse

Introduction to roll up columns

Create a rollup column

Introduction to calculated columns

Create a calculation column

Introduction to Power Fx formula columns

Topic 9 Load/export data and create data views in Dataverse

View data in a table

Create or edit views of data in a table

Dataverse data import options

Load data into a table

Dataverse data export options

Export

Add, update, or delete data in a table by using Excel

Import data using Power Query

Topic 10 Get started with security roles in Dataverse

Introduction to environment roles

Understand environment roles

Adding or disabling an environment user

Understand security concepts in Dataverse

Understand user security roles and security role defaults

Check the roles that a user belongs to

Configure Dataverse teams for security

Configure Dataverse group teams for security

Topic 11 Use administration options for Dataverse

Introduction to Microsoft Power Platform Admin Center portal

Use Microsoft Power Platform Admin Center portal

Tenant storage capacity

Advanced Customization options in Power Apps Portal

Dataverse Search

Auditing

Duplicate detection

Bulk delete

Long term data retention

Topic 12 How to build your first model-driven app with Dataverse

Introduction to Dataverse

Introduction to model-driven apps

Model-driven apps, powered by Microsoft Dataverse

Explore sample apps

Topic 13 Get started with model-driven apps in Power Apps

Introducing model-driven apps

Components of model-driven apps

Design model-driven apps

Incorporate business process flows

Topic 14 Configure forms, charts, and dashboards in model-driven apps

Forms overview

Form elements

Configure multiple forms

Use specialized form components

Configure views overview

Configure grids

Create and edit views

Configure charts overview

Dashboards overview

Use interactive streams and tiles

Topic 15 Use specialized components in a model-driven form

Create business process flows

Embed a canvas app in a model-driven form

Add a timeline in a model-driven form

Create a report in a model-driven form

Topic 16 Customize the command bar

Create or edit modern commands

Work with classic commands

Use Power Fx

Topic 17 Get started with Power Apps canvas apps

Introduction to Power Apps

Start Power Apps

Power Apps data sources

Use Power Apps with Power Automate and Power BI

Designing a Power Apps app

Topic 18 Customize a canvas app in Power Apps

Improve your app by making basic customizations

Explore controls and screens in canvas apps

Topic 19 Navigation in a canvas app in Power Apps

Understanding navigation

The Navigate and Back functions

More ways to use the Navigate function

Topic 20 Create formulas to change behaviors in a Power Apps canvas app

Formulas and functionality

Understanding true and false

Understanding control behaviors and actions

Performing multiple actions in a formula

Control the display mode through a formula

Use controls and functions to create a dynamic formula

Topic 21 Connect to other data in a Power Apps canvas app

Overview of the different data sources

Work with action-based data sources

Power Automate is a companion to Power Apps

Topic 22 Introduction to Power Apps cards

Design Power Apps cards

Send Power Apps cards

Topic 23 Core components of Power Pages

Introduction to Power Pages

Get started with Power Pages

Core tools and components of Power Pages

Overview of Power Pages security

Overview of Power Pages extensibility

Topic 24 Access Dataverse in Power Pages websites

Use lists to display multiple Dataverse records

Use forms to interact with Dataverse data

Topic 25 Explore Power Pages design studio

Get Started with Power Pages

Work with Power Pages websites

Introduction to Power Pages design studio

Work with pages

Page components

Site styling and templates

Topic 26 Integrate Power Pages websites with Dataverse

Basic form configuration

Multistep form processes

Set up multistep forms

Extend lists and forms

Topic 27 Integrate Power Pages with web-based technologies

Document management with SharePoint in Power Pages

Integration with Power BI in Power Pages

Model-driven charts in Power Pages

Topic 28 Explore Power Pages design studio data and security features

Introduction into Power Pages design studio data and security features

Data workspace in Power Pages design studio

Power Pages security features

Topic 29 Set up Power Pages security

Secure static content

Table permissions

Topic 30 Authentication and user management in Power Pages

Power Pages authentication settings

User registration in Power Pages

Authentication management for Power Pages users

Power Pages authentication providers

Topic 31 Best practices for error handling in Power Automate flows

Configure run after option

Power Automate analytics

Topic 32 Use Dataverse triggers and actions in Power Automate

Dataverse triggers

Query data

Create, update, delete, and relate actions

Topi 33 Introduction to expressions in Power Automate

Get started with expressions

Notes make things easier

Types of functions

Write complex expressions

Topic 34 Define and create business rules in Dataverse

Define business rules - Introduction

Define the components of a business rule

Create a business rule

Topic 35 Set up low-code plug-ins

Low-code plug-ins

Create a low-code plug-in

Instant plug-ins

Automated plug-ins

Topic 36 Use common low-code plug-in scenarios

Use Power Fx with plug-ins

Implement data validation

Data manipulation

Use connectors in plug-in logic

Use instant plug-ins from Power Apps

Use instant plug-ins from Power Automate

Topic 37 Get started building with Power BI

Use Power BI

Building blocks of Power BI

Tour and use the Power BI service

Topic 38 Introduction to solutions for Microsoft Power Platform

Solution layering

Solution architecture tools and techniques

Topic 39 Use Microsoft 365 services with model-driven apps and Microsoft Dataverse

Set up mailboxes

Server-side sync

Document management options

Document management

Deploy the app for Outlook

Set up Dynamics 365 App for Outlook

Integrate with Microsoft Teams

Topic 40 Use Microsoft Word and Excel templates with Dataverse

Create a dynamic Word template

Create a dynamic Excel template

Final Assessment 

Written Assessment - Short Answer Questions (WA-SAQ)

Practical Performance (PP)

Assessment

  • Written Exam
  • Practical Exam

Course Info

Promotion Code

Promo or discount cannot be applied to WSQ courses

Minimum Entry Requirement

Knowledge and Skills

  • Able to operate using computer functions with minimum Computer Literacy Level 2 based on ICAS Computer Skills Assessment Framework
  • Minimum 3 GCE ‘O’ Levels Passes including English or WPL Level 5 (Average of Reading, Listening, Speaking & Writing Scores)

Attitude

  • Positive Learning Attitude
  • Enthusiastic Learner

Experience

  • Minimum of 1 year of working experience.
  • Minimum 18 years old

Minimum Software/Hardware Requirement

Software: 

You can download and install the following software:

You can also sign up a Power BI account

Hardware: Window Laptop

About Progressive Wage Model (PWM)

The Progressive Wage Model (PWM) helps to increase wages of workers through upgrading skills and improving productivity. 

Employers must ensure that their Singapore citizen and PR workers meet the PWM training requirements of attaining at least 1 Workforce Skills Qualification (WSQ) Statement of Attainment, out of the list of approved WSQ training modules.

For more information on PWM, please visit MOM site.

Funding Eligility Criteria

Individual Sponsored Trainee Employer Sponsored Trainee
  • Singapore Citizens or Singapore Permanent Residents of age 21 and above
  • From 1 October 2023, attendance-taking for SkillsFuture Singapore's (SSG) funded courses must be done digitally via the Singpass App. This applies to both physical and synchronous e-learning courses.​
  • Trainee must pass all prescribed tests / assessments and attain 100% competency.
  • We reserves the right to claw back the funded amount from trainee if he/she did not meet the eligibility criteria.
  • Singapore Citizens or Singapore Permanent Residents who are DIRECT EMPLOYEE of the sponsoring company.
  • From 1 October 2023, attendance-taking for SkillsFuture Singapore's (SSG) funded courses must be done digitally via the Singpass App. This applies to both physical and synchronous e-learning courses.​
  • Trainee must pass all prescribed tests / assessments and attain 100% competency.
  • We reserves the right to claw back the funded amount from the employer if trainee did not meet the eligibility criteria.

 SkillsFuture Credit: 

  • Eligible Singapore Citizens can use their SkillsFuture Credit to offset course fee payable after funding.

 PSEA:

  • To check for Post-Secondary Education Account (PSEA) eligibility, goto mySkillsFuture portal and search for this course code.
  • Scroll down to "Keyword Tags" to verify for PSEA eligibility.
  • If there is “PSEA” under keyword tags, the course is eligible for PSEA.  
  • And if there is no “PSEA” under keyword tags, the course is ineligible for PSEA. 
  • Not all courses are eligible for PSEA funding.

 Absentee Payroll (AP) Funding: 

  • $4.50 per hour, capped at $100,000 per enterprise per calendar year.
  • AP funding will be computed based on the actual number of training hours attended by the trainee.

 SFEC:

  • If the Training Provider has submitted an enrolment for course fee grant claim in Training Partners Gateway (TPGateway), SSG would be able to derive SFEC funding based on this record. There is no need for enterprise to submit any claim request and the SFEC claim will be automatically generated and disbursed.
  • Where there is no such record, eligible employers are required to submit an SFEC claim after course completion via the SFEC microsite.
  • SkillsFuture Enterprise Credit (SFEC) Microsite 

Steps to Apply Skills Future Claim

  • The staff will send you an invoice with the fee breakdown.
  • Login to the MySkillsFuture portal, select the course you’re enrolling on and enter the course date and schedule.
  • Enter the course fee payable by you (including GST) and enter the amount of credit to claim.
  • Upload your invoice and click ‘Submit’

SkillsFuture Level-Up Program

The  SkillsFuture Level-Up Programme provides greater structural support for mid-career Singaporeans aged 40 years and above to pursue a substantive skills reboot and stay relevant in a changing economy. For more information, visit SkillsFuture Level-Up Programme

Get Additional Course Fee Support Up to $500 under UTAP

The Union Training Assistance Programme (UTAP) is a training benefit provided to NTUC Union Members with an objective of encouraging them to upgrade with skills training. It is provided to minimize the training cost. If you are a NTUC Union Member then you can get 50% funding (capped at $500 per year) under Union Training Assistance Programme (UTAP).

For more information visit NTUC U Portal – Union Training Assistance Program (UTAP)

Steps to Apply UTAP

  • Log in to your U Portal account to submit your UTAP application upon completion of the course.

Note

  • SSG subsidy is available for Singapore Citizens, Permanent Residents, and Corporates.
  • All Singaporeans aged 25 and above can use their SkillsFuture Credit to pay. For more details, visit www.skillsfuture.gov.sg/credit
  • An unfunded course fee can be claimed via SkillsFuture Credit or paid in cash.
  • UTAP funding for NTUC Union Members is capped at $250 for 39 years and below and at $500 for 40 years and above.
  • UTAP support amount will be paid to training provider first and claimed after end of class by learner.

Appeal Process

  1. The candidate has the right to disagree with the assessment decision made by the assessor.
  2. When giving feedback to the candidate, the assessor must check with the candidate if he agrees with the assessment outcome.
  3. If the candidate agrees with the assessment outcome, the assessor & the candidate must sign the Assessment Summary Record.
  4. If the candidate disagrees with the assessment outcome, he/she should not sign in the Assessment Summary Record.
  5. If the candidate intends to appeal the decision, he/she should first discuss the matter with the assessor/assessment manager.
  6. If the candidate is still not satisfied with the decision, the candidate must notify the assessor of the decision to appeal. The assessor will reflect the candidate’s intention in the Feedback Section of the Assessment Summary Record.
  7. The assessor will notify the assessor manager about the candidate’s intention to lodge an appeal.
  8. The candidate must lodge the appeal within 7 days, giving reasons for appeal 
  9. The assessor can help the candidate with writing and lodging the appeal.
  10. he assessment manager will collect information from the candidate & assessor and give a final decision.
  11. A record of the appeal and any subsequent actions and findings will be made.
  12. An Assessment Appeal Panel will be formed to review and give a decision.
  13. The outcome of the appeal will be made known to the candidate within 2 weeks from the date the appeal was lodged.
  14. The decision of the Assessment Appeal Panel is final and no further appeal will be entertained.
  15. Please click the link below to fill up the Candidates Appeal Form.

Job Roles

Job Roles

  • Power Platform Developer
  • Software Developer
  • Application Developer
  • Systems Analyst
  • Data Analyst
  • Business Intelligence Developer
  • IT Consultant
  • Solutions Architect
  • Database Developer
  • CRM Developer
  • Cloud Developer
  • Full Stack Developer
  • Mobile App Developer
  • Front End Developer
  • Back End Developer

Review

Customer Reviews (1)

will recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
. (Posted on 8/26/2024)

Write Your Own Review

You're reviewing: WSQ - Microsoft Power Platform Functional Consultant (PL-200)

How do you rate this product? *

  1 star 2 stars 3 stars 4 stars 5 stars
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment