Power Apps, Power Automate, and Power BI — Integrated Business Solutions Training Course

This instructor-led, live training in South Africa (online or onsite) targets business analysts aiming to streamline workflows and tasks using Microsoft Flow / Power Automate.

Upon completion of this training, participants will be able to:

• Develop business applications without requiring any developer experience.
• Manage and analyze flows to support business solutions.
• Create flows, define triggers, add actions, and set conditions.

This instructor-led, live training in South Africa (online or onsite) is designed for business personnel, managers, developers, and data analysts who wish to adapt, implement, integrate, and manage Microsoft Power Platform components and features within their organisation.

Upon completion of this training, participants will be capable of:

• Constructing simple applications using Power Apps to develop custom solutions tailored to everyday business requirements.
• Automating workflow processes via Power Automate (previously known as Microsoft Flow) to reduce manual and repetitive tasks.
• Producing data reports and dashboards with Power BI to derive insightful analytics for the business.
• Developing chatbots using Power Virtual Agents to automate and resolve common customer inquiries and issues.

This course provides a foundational overview of the core principles behind Power Virtual Agents, Power Automate, and Power Apps, while also offering a high-level introduction to Power BI. The curriculum is centred around a practical workflow I previously managed manually for a former employer. We will construct a Power App using Microsoft Power Apps to monitor tasks related to house construction, storing the data in SharePoint for simplicity. Subsequently, we will leverage Power Virtual Agents to demonstrate how to enable bots within Microsoft Teams, guiding users to locate documents scattered across various SharePoint sites, such as loan documents, budgets, and sales contracts. I observe significant potential for these bots within HR and IT teams, particularly for managing repetitive inquiries. I will also show you how to configure simple flows in Power Automate to archive attachments from designated senders (in our scenario, the bank's inspection reports for the units). Additionally, we will explore other straightforward flows that capture data from Microsoft Forms back into SharePoint and establish fully automated processes using the approvals app within Microsoft Teams. Once the app, bot, and flow are established, the final step involves creating a straightforward Power BI report. We will utilise Power Automate to send a snapshot of the table containing the most recently completed tasks every two weeks to a specific recipient (the bank in this example). This report will request a drawdown, including the task completion dates and associated budget amounts—all data collected via the app. Finally, as this course remains at a high level, I recommend that learners use ChatGPT for more technical aspects, such as coding or formulas in Power Apps. However, this is also covered in the course, where I demonstrate how to effectively utilise ChatGPT to assist with Power Apps formulas.

This instructor-led, live training in South Africa guides beginner-to-intermediate users in mastering the Microsoft Power Platform. Participants will construct custom apps, automate workflows, and apply governance best practices using Power Apps and Power Automate within a hands-on lab environment.

Participants on this course automate time-consuming and repetitive tasks by using Microsoft Power Automate. They review solution requirements, create process documentation, and design, develop, troubleshoot, and evaluate solutions. Participants work with business stakeholders to improve and automate business workflows. They collaborate with administrators to deploy solutions to production environments, and they support solutions.

The Solution Architect plays a pivotal role in the successful design, implementation, deployment, and adoption of comprehensive solutions. This professional ensures that the delivered solution addresses both the current and future requirements of the client. Through this course, learners will gain insight into the critical decisions made by a Solution Architect during an implementation process, including aspects such as security, integrations, Power Apps architecture, Power Automate architecture, and more. The course is structured to provide a foundational understanding of the Solution Architect role.

This instructor-led, live training in South Africa (online or onsite) is designed for IT professionals at an intermediate level who wish to leverage the Power Platform to effectively automate workflows and gain deeper insights from their data.

Upon completion of this training, participants will be able to:

• Develop and customise applications using Power Apps.
• Manage and analyse data using Dataverse and Power BI.
• Automate complex processes with Power Automate.
• Design and deploy intelligent chatbots using Power Virtual Agents.
• Integrate and optimise workflows across the Power Platform suite.