Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
What is the Microsoft Power Platform and what is its purpose?
- What is the goal of this course and how will we use the Power Platform tools?
- Introduction to the Power Platform and how the tools work collectively
Explanation of the processes we have been tasked with automating!
- The Task in Hand: Automating the Drawdown process of our Loans
Power Virtual Agents
- What is Power Virtual Agents and using them externally on websites
- Real Life Case Study - External and Internal use cases for Power Virtual Agents
- Saving the files that we want the bot to locate for users on SharePoint
- Downloading the Power Virtual Agents app within Microsoft Teams
- Creating our very first Power Virtual Agent/Copilot!
- Overview of the Canvas for Power Virtual Agents within Microsoft Teams
- Building our first topic
- Utilizing Variables in Topics
- Redirecting to another separate topic within Power Virtual Agents
- Touching on the Call to action node and what this is
- Ending the Topic with a survey before publishing the Bot
- Publishing the Bot within Microsoft Teams
Power Automate
- What is Power Automate (Cloud version) and how can it help us?
- What is a Manual Process?
- Power Automate Cloud vs Power Automate Desktop
- Building our first Automated Flow
- Adding Conditions into your Trigger
- Adding Conditions into your Flow
- Utilizing Templates to build a similar Flow
- Building our first Instant Cloud Flow using an Excel Spreadsheet
- Building an Automated Approval process using Forms & Approvals within Teams
Power Apps
- What is Power Apps and how can it help us?
- When to consider Power Apps
- Power Apps Canvas
- Power Apps Templates - The Do's and Don'ts
- Building our first App and first screen, the 'Welcome Screen'
- Utilizing ChatGPT with PowerApps for formulas
- Connecting to our first Data Source - ProjectList on SharePoint!
- Adding our first 'Button' to Power Apps
- Building the main screen of our App, the 'UpdateTasks' screen
- Connecting our second Data Source
- Filtering within Power Apps
- Using 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 more controls to our gallery
- Using Patch for the first time to save data back to SharePoint
- Checking our results after Submitting the Tasks
- Adding a Hidden Toggle which we will use to Filter the Patch Function
- Using Patch with a condition/filter applied
- Checking our results after applying the filter to the Patch Function
- Creating our Final Screen - The 'Success Screen'
- Publishing your App
Additional Material: Adding the ability to add photos in the App
- Adding the camera control into the App and adding the column into SP to store data
Additional Material: Connect the App to Power BI to generate automated emails
- Connecting your data from SharePoint to Power BI
- Setting up your table in Power BI and Publishing Report to Power BI Service
- Generating the Power BI Query to connect to Power Automate
- 'Run a Query Against a Dataset' action in Power Automate and Building out flow
- Using the columns in the table in Power BI in your Power Automate flow
- Fully Building out the automated flow to occur every 2 weeks dynamically
- Formatting the table so it looks visually appealing in the email
Additional Material: Using 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 data down in an Excel spreadsheet from the user
Summary and Next Steps
Requirements
Who This Course Is For:
- Business Analysts: Who want to automate routine tasks and processes, interested in building custom applications without extensive coding expertise, and aiming to enhance data visualization and reporting capabilities.
- IT Professionals: Who aim to streamline business operations through automation, seek seamless integration of different systems and services, and desire to support their organization's digital transformation initiatives.
- Entrepreneurs and Small Business Owners: Who wish to develop cost-effective solutions for managing business processes, are interested in leveraging technology for competitive advantage, and look to improve customer engagement and operational efficiency.
- Students and Graduates: Who aspire to acquire skills in a highly sought-after area of technology, want to add practical, hands-on experience with industry-standard tools to their resumes, and aim to build a strong foundation in low-code/no-code development.
- Project Managers: Who seek to enhance project workflows and task management, are interested in automating repetitive tasks to focus on strategic planning, and want to provide their teams with efficient tools for better collaboration and productivity.
- HR Professionals: Who aim to automate HR processes such as onboarding, leave management, and employee feedback, are interested in creating custom applications to manage employee data and analytics, and look to enhance the overall employee experience through efficient digital solutions.
- Anyone Interested in Automation and App Development: Who are enthusiastic about learning how to automate tasks and create applications without deep coding knowledge, keen to explore the capabilities of Power Virtual Agents, Power Automate, and Power Apps, and want to solve real-world problems with practical, easy-to-implement solutions.
7 Hours
Testimonials (2)
We did quite complex examples, so we could get a feeling of how the real work with Power Automate Desktop can look like in the real world scenario.
Michal Strnad - MicroNova AG
Course - Microsoft Flow/Power Automate
Dynamic, adaptive, and informative
