Transform business processes by harnessing the full capabilities of Microsoft Power Platform. Build, test, and enhance custom solutions that go beyond low-code limitations, using traditional code where needed to tackle complex scenarios. Automate tasks, streamline workflows, and connect data seamlessly across your organisation. Gain hands-on experience designing and troubleshooting solution components through real-world use cases, unlocking the platform’s powerful extension points to drive efficiency, innovation, and agility at scale.
Key Takeaways
At the end of this programme, you will be able to:
Discover the value and key features of Dataverse
Explore sample model-driven template apps
Create a model-driven app
Types of tables that are available in Dataverse
Enabling attachments within a table
Learn what a column is in Dataverse
Add a column to a table
Identify restrictions that are associated with columns
Create an alternate key
Explore the standard choices
Why should you segment data that is used by your solutions into many tables
How to build relationships between tables
Define business rules in Dataverse
Learn about security roles and apply them to users in an environment
Understand security concepts in Dataverse
Create a custom role
Learn how to configure Dataverse teams for security
Explore how Power Apps can make your business more efficient
Learn about the different ways to build an app in Power Apps
Change the layout of a gallery
Change the order in which fields appear
Explore controls on each screen of an app
Colour prices based on their values
Learn how to view and restore app versions
Learn about what environments are, how to create them, and how to manage security
Understand how navigation works in a canvas app
Understand the different ways these functions can be invoked
Use personalisation in a canvas app
Understand how to use controls in a canvas app
Understand how Galleries and Forms related to controls
Identify and discuss optimisation tools and performance tuning
Understand imperative vs. declarative development
Understand when to utilise each of the three different types of variables
Use the Concat function to combine text from multiple records
Perform math operations on data in a table
Understand how the Defaults function is used to create new records with Patch
Determine whether to use Clear and Collect or ClearCollect in their scenario
Use relational data to improve an app user's experience in Power Apps
Understand and use action-based connectors
Use Power Automate with Power Apps
Understand the custom connector lifecycle
Create a flow that automatically saves email attachments
Create and process approval requests
Create a business process flow with conditions
Learn about the difference between a workflow and a business process
Learn about branching logic
Discover how to use instant flows with business process flows
Use one or more functions to create expressions
Explain what solution components exist within Microsoft Power Platform
Explain what Azure solution elements relate to Microsoft Power Platform
Navigate the Developer Guide successfully in support of their Microsoft Power Platform development efforts
Work with the Configuration Migration tool
Leverage Solution Packager to isolate features
Identify which elements architecturally comprise Microsoft Power Platform
Discover different approaches to common business scenarios with respect achieving extensibility through configuration versus code
Perform basic operations against Microsoft Power Platform, such as create/read/update/delete operations
Write a client script to perform common actions as listed in the module units
Learn about Power Apps component framework architecture
Create a custom Power Apps component
Test and debug a code component
Use the formatting API in a Power Apps component
Discover the portal components that are available to display and interact with Dataverse data on the portal
Display a list of data and an associated drill-down for details
Trigger classic Dataverse workflows from the portal
Employ portal application lifecycle management for Power Apps portals
Use Cascading Style Sheets (CSS) to address specific portal development requirements
Discover how custom web templates can be built by using HTML, Cascading Style Sheets (CSS), Liquid, and JavaScript
Learn how to embed custom CSS and JavaScript into web templates
Interact with the Dataverse Web API by using Postman.
Use OData to query data
Write a Service Bus Event Listener that consumes Dataverse events
Learn about the value and key features of model-driven apps
Learn about model-driven app design
Tables in Dataverse
Creating a custom table
Which licensing requirements apply to use each type of table
Learn about the types of columns that are available in Dataverse
Learn what a primary name column is in Dataverse
Create an auto-numbering column
Learn about choices
Create a new choice or modify an existing one
Why you need to relate one table to another
How to select the proper relationship type when you are building solutions with Dataverse
Create and manage business rules in Dataverse
Create a rollup column
Create a calculation column
Learn how to add users to an environment
Identify default security roles
Create a custom security role and assign it to entities and users
Learn how to configure Dataverse group teams for security
Learn how to use different technologies to perform different tasks in Power Apps
Create your first app from data in an Excel workbook
Change the data that a control will show
Change the control with which a user provides information
Format a number as a price
Explore formulas in a generated app
Explore how to share an app, including permissions and notifications.
Find more information about Power Apps
Use the Navigate and Back functions
Understand the basics of building the UI through themes, icons, control customisation, and images
Understand the differences between the Tablet and Mobile form factors
Use the different types of controls
Learn about the different types of test plans and components of a good test plan
Learn about the benefits of documenting your application
Understand the variables in Power Apps
Utilise formulas that process multiple records
Utilise the Countrows, CountIf and ForAll
Use the Patch function to update your data
Utilise the Remove and RemoveIf functions to delete records
Understand relational data
Understand how to use relational data in Microsoft Dataverse
Integrate user information and user-profile information into a canvas app
Understand custom connectors and the basics of how to build one
Use Postman with a custom connector
Learn how to create a button flow to send yourself a reminder
Build a flow that runs at recurring time intervals
Discover why standardizing business process flows is important and valuable to an organisation.
Find out about how business process flows are used within Microsoft Power Platform and Dataverse
Create additional fields and a main form to enhance the business process flow
Enhance immersive business process flows by using advanced techniques
Use functions to retrieve data, change data, evaluate data, and more
Explain key components of Microsoft Dataverse and the Common Data Model
Explain what AI Solutions exist as they relate to Microsoft Power Platform
Install NuGet packages available for Microsoft Power Platform development
Work with Package Deployer
Run the Plugin Registration Tool
Learn about the areas of extensibility that are available to customise Microsoft Power Platform through code
Explain what functions can be executed against Microsoft Power Platform via Microsoft Power Platform SDKs.
Learn how to extend plug-ins.
Automate business process flow actions by using JavaScript/TypeScript API methods.
Learn about Power Apps component tooling.
Create a code component solution package.
Learn key concepts of Dataverse auditing
Use Dataverse web API in a Power Apps component.
Identify the various features of the portal components.
Configure a table form to access individual records.
Discover where software development can resolve particular portal feature requirements.
Apply JavaScript code to portal assets
Learn about the relationship between web templates, page templates, and webpages
Use Liquid template language to build and structure web templates
Learn how to reference other web templates in a web template
Authorize against Dataverse with OAuth
Publish Dataverse events to Microsoft Azure Service Bus
Who Should Attend
Please refer to the job roles section.
The PL-400: Microsoft Power Platform Developer certification is designed for individuals with existing software development experience, particularly those working with .NET technologies like C#, JavaScript, JSON, and TypeScript, who are looking to build and extend solutions on the Microsoft Power Platform. It's suitable for developers, IT professionals, and technical consultants who need to create, configure, and customise Power Apps, automate processes with Power Automate, and integrate with other services like Azure.
Prerequisites
As a participant, you must have previous software developer experience using code techniques with modern programming languages such as C# and JavaScript. You must also have a foundational understanding of Microsoft Power Platform and have hands-on experience with the following:
Developing a data model in Microsoft Dataverse
Creating tables, columns, and relationships in Microsoft Dataverse
Building Power Apps canvas apps
Building Power Apps model-driven apps
Building Power Automate cloud flows
In this programme, you will learn to build solutions using Visual Studio and Visual Studio Code that include the following: Microsoft Power Platform services, JavaScript, JSON, TypeScript, C#, HTML, RESTful Web APIs, and Microsoft Azure
This programme will cover the following topics:
Use imperative development techniques for canvas apps in Power Apps
Perform custom updates in a Power Apps canvas app
Use Dataverse choice columns with formulas
Reduce complexity in your data model with Dataverse table relationships
Work with relational data in a Power Apps canvas app
Work with data source limits (delegation limits) in a Power Apps canvas app
Complete testing and performance checks in a Power Apps canvas app
Optimize app load time
Use Monitor to troubleshoot Power Apps
Use Power Apps Instrumentation with Application Insights
Get started with Power Automate
Introduction to expressions in Power Automate
Use Dataverse triggers and actions in Power Automate
Introduction to Microsoft Power Platform developer resources
Use developer tools to extend Power Platform
Introduction to extending Power Platform
Work with Dataverse Web API
Perform common actions with client script in Power Platform
Automate business process flows with client script
Get started with Power Apps component framework
Build a Power Apps component
Introduction to Dataverse for developers
Extend plug-ins in Power Platform
Integrate Dataverse Azure solutions
Explore Azure Functions
Develop Azure Functions
Get started with custom connectors in Microsoft Power Platform
Discover and use Web APIs with Power Apps
Configure custom connectors with authenticated APIs in Microsoft Power Platform
Configure custom connectors with authenticated APIs in Microsoft Power Platform
Create Microsoft Power Platform OpenAPI custom connectors
Manage solutions in Power Apps and Power Automate
Introduction to solutions for Microsoft Power Platform
Full Fee
Full programme fee
S$2800
9% GST on nett programme fee
S$252
Total nett programme fee payable, including GST
S$3052
NOTE
This programme does not include the certification exam. If you are interested in taking the certification exam after completing this programme, please email digitalacademy@trainocate.com.