Course Overview
This course will teach you to use Microsoft Power Platform solutions to simplify, automate, and empower business processes for organizations in the role of a Functional Consultant. A Microsoft Power Platform Functional Consultant is responsible for creating and configuring apps, automations, and solutions. They act as the liaison between users and the implementation team. The functional consultant promotes utilization of solutions within an organization. The functional consultant may perform discovery, engage subject matter experts and stakeholders, capture requirements, and map requirements to features. They implement components of a solution including application enhancements, custom user experiences, system integrations, data conversions, custom process automation, and simple visualizations. This course may contain a 1-day Applied Workshop. This workshop will allow you to practice your Functional Consultant skills by creating an end-to-end solution to solve a problem for a fictitious company. The solution will include a Microsoft Dataverse database, Power Apps canvas app, and Power Automate flows.
Course Content
- Describe the business value of the Microsoft Power Platform
- Identify foundational components of Microsoft Power Platform
- Create and manage environments in Dataverse
- Create tables in Dataverse
- Create and manage columns within a table in Dataverse
- Working with choices in Dataverse
- Create a relationship between tables in Dataverse
- Create and define calculation or rollup columns in Dataverse
- Load/export data and create data views in Dataverse
- Get started with security roles in Dataverse
- Use administration options for Dataverse
- How to build your first model-driven app with Dataverse
- Get started with model-driven apps in Power Apps
- Configure forms, charts, and dashboards in model-driven apps
- Use specialized components in a model-driven form
- Customize the command bar
- Get started with Power Apps canvas apps
- Customize a canvas app in Power Apps
- Navigation in a canvas app in Power Apps
- Create formulas to change behaviors in a Power Apps canvas app
- Connect to other data in a Power Apps canvas app
- Introduction to Power Apps cards
- Core components of Power Pages
- Access Dataverse in Power Pages websites
- Explore Power Pages design studio
- Integrate Power Pages websites with Dataverse
- Integrate Power Pages with web-based technologies
- Explore Power Pages design studio data and security features
- Set up Power Pages security
- Authentication and user management in Power Pages
- Best practices for error handling in Power Automate flows
- Use Dataverse triggers and actions in Power Automate
- Introduction to expressions in Power Automate
- Define and create business rules in Dataverse
- Set up low-code plug-ins
- Use common low-code plug-in scenarios
- Get started building with Power BI
- Introduction to solutions for Microsoft Power Platform
- Use Microsoft 365 services with model-driven apps and Microsoft Dataverse
- Use Microsoft Word and Excel templates with Dataverse
- Validate your Power Platform Functional Consultant skills
Who should attend
A Microsoft Power Platform Functional Consultant is responsible for creating and configuring apps, automations, and solutions. They act as the liaison between users and the implementation team. The functional consultant promotes utilization of solutions within an organization. The functional consultant may perform discovery, engage subject matter experts and stakeholders, capture requirements, and map requirements to features. They implement components of a solution including application enhancements, custom user experiences, system integrations, data conversions, custom process automation, and simple visualizations.
Certifications
This course is part of the following Certifications: