Get in Touch
 Duration 7 hours

Course Outline

Overview of the Microsoft Power Platform and its intended purpose

  • Defining the course objectives and the application of Power Platform tools
  • Introduction to the Power Platform and the collective functionality of its tools

Description of the processes we are tasked with automating

  • The Core Task: Automating the loan drawdown process

Power Virtual Agents

  • Introduction to Power Virtual Agents and their external use on websites
  • Real-world case study - Internal and external use cases of Power Virtual Agents
  • Storing files that the bot will locate for users on SharePoint
  • Downloading the Power Virtual Agents app within Microsoft Teams
  • Creating our first Power Virtual Agent/Copilot
  • Overview of the Power Virtual Agents canvas within Microsoft Teams
  • Building our first topic
  • Implementing Variables within Topics
  • Redirecting to another distinct topic within Power Virtual Agents
  • Introduction to the Call to Action node and its function
  • Concluding a Topic with a survey before publishing the Bot
  • Publishing the Bot within Microsoft Teams

Power Automate

  • Understanding Power Automate (Cloud version) and its benefits
  • Defining a Manual Process
  • Comparing Power Automate Cloud and Power Automate Desktop
  • Constructing our first Automated Flow
  • Incorporating Conditions into your Trigger
  • Adding Conditions to your Flow
  • Leveraging Templates to build similar Flows
  • Creating our first Instant Cloud Flow using an Excel Spreadsheet
  • Establishing an Automated Approval process using Forms and Approvals within Teams

Power Apps

  • Understanding Power Apps and its potential applications
  • Identifying when to consider using Power Apps
  • Exploring the Power Apps Canvas
  • Power Apps Templates - Best practices and pitfalls
  • Building our first App and the initial “Welcome Screen”
  • Utilizing ChatGPT with PowerApps for formula assistance
  • Connecting to our first Data Source - ProjectList on SharePoint
  • Adding our first “Button” to Power Apps
  • Developing the main screen within our App, the “UpdateTasks” screen
  • Connecting our second Data Source
  • Applying Filters within Power Apps
  • Utilizing a Gallery within Power Apps for the first time
  • Creating our first variable in Power Apps
  • Adding our Third & Final Data Source
  • Filtering our Gallery
  • Adding additional controls to our gallery
  • Using Patch for the first time to save data back to SharePoint
  • Verifying results after Submitting the Tasks
  • Adding a Hidden Toggle to Filter the Patch Function
  • Using Patch with an applied condition/filter
  • Verifying results after applying the filter to the Patch Function
  • Creating our Final Screen - The “Success Screen”
  • Publishing your App

Additional Material: Enabling photo uploads in the App

  • Adding the camera control to the App and creating a column in SP to store data

Additional Material: Linking the App to Power BI for automated email generation

  • Connecting SharePoint data to Power BI
  • Configuring your table in Power BI and Publishing the Report to Power BI Service
  • Generating the Power BI Query to connect to Power Automate
  • Utilizing the “Run a Query Against a Dataset” action in Power Automate and Building the flow
  • Incorporating Power BI table columns into your Power Automate flow
  • Fully constructing the automated flow to execute every 2 weeks dynamically
  • Formatting the table for visual appeal in the email

Additional Material: Integrating Power Automate within Power Virtual Agents

  • Using Power Automate to send data back to the user from a SharePoint list
  • Using Power Automate to save user-provided data to an Excel spreadsheet

Summary and Next Steps

Requirements

Who this course is for:

  • Business Analysts: Those aiming to automate routine tasks and processes, interested in developing custom applications without extensive coding knowledge, and seeking to enhance data visualization and reporting capabilities.
  • IT Professionals: Individuals looking to streamline business operations through automation, eager to integrate different systems and services seamlessly, and desiring to support their organization's digital transformation initiatives.
  • Entrepreneurs and Small Business Owners: Business leaders aiming to develop cost-effective solutions for managing business processes, interested in leveraging technology for competitive advantage, and looking to improve customer engagement and operational efficiency.
  • Students and Graduates: Aspirants looking to acquire skills in one of the most in-demand technology sectors, seeking to add practical, hands-on experience with industry-standard tools to their resumes, and aiming to build a strong foundation in low-code/no-code development.
  • Project Managers: Professionals seeking to enhance project workflows and task management, interested in automating repetitive tasks to concentrate on strategic planning, and looking to equip their teams with efficient tools for improved collaboration and productivity.
  • HR Professionals: Individuals aiming to automate HR processes such as onboarding, leave management, and employee feedback, interested in creating custom applications to manage employee data and analytics, and looking to elevate the overall employee experience through efficient digital solutions.
  • Anyone Interested in Automation and App Development: Enthusiasts eager to learn how to automate tasks and create applications without deep coding expertise, keen to explore the capabilities of Power Virtual Agents, Power Automate, and Power Apps, and looking to solve real-world problems with practical, easy-to-implement solutions.

Custom Corporate Training

Training solutions designed exclusively for businesses.

  • Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
  • Flexible Schedule: Dates and times adapted to your team's agenda.
  • Format: Online (live), In-company (at your offices), or Hybrid.
Investment

Price per private group, online live training, starting from 1450 € + VAT*

Contact us for an exact quote and to hear our latest promotions

Testimonials (3)

Upcoming Courses

Related Categories