Power Apps Intermediate Pathway 2: Power Automate + Power BI Integration
Take your Microsoft PowerApps skills up a level
All courses are available in-person or remotely.
To attend remotely, select "Remote Online" as your location on book now.
Take your Task Management app to the next level by integrating Power Automate and Power BI with Power Apps and SharePoint. You’ll work hands-on to assign users via flows, generate and save PDFs to SharePoint, send critical task reports by email, and embed a Power BI report for visual insights and dashboard-style reporting.
This pathway mirrors a structured, step-by-step build: prepare SharePoint and the app, create and install flows, pass parameters between Power Apps and Power Automate, format and send email reports, generate PDFs from app screens, and embed Power BI tiles with optional URL filtering. You’ll leave with reusable patterns for real business apps not just demos.
By the end of this course, you will be able to:
Intermediate Excel and basic Power Apps Canvas app skills (or Power Apps Beginner / Intermediate Pathway 1). SharePoint Lists helpful.
We currently have no public courses scheduled. Please contact us to register your interest.
We currently have no public courses scheduled. Please contact us to register your interest.
We currently have no public courses scheduled. Please contact us to register your interest.
We currently have no public courses scheduled. Please contact us to register your interest.
We currently have no public courses scheduled. Please contact us to register your interest.
We currently have no public courses scheduled. Please contact us to register your interest.
We currently have no public courses scheduled. Please contact us to register your interest.
We currently have no public courses scheduled. Please contact us to register your interest.
Power Apps BeginnerThis beginner Power Apps training course teaches you how to build custom business apps using Microsoft’s low-code platform.
Power Apps Intermediate (Building Smarter, Scalable Apps)In this intermediate Power Apps pathway, you’ll build a Task Management app connected to SharePoint while improving performance with collections and mastering Patch, variables, and delegation-aware filtering.
Power Apps AdvancedOur advanced Power Apps training course covers model-driven apps, Common Data Service (CDS), and portal development for enterprise use.
SharePoint Integration & App Preparation
Check locale settings
Check SharePoint list settings
Import list data from Excel
Import the MSAPP file
Allow connections to be established
Add a SharePoint connection
Explore the app features, layout, and formulas
Create screens
Update SharePoint via Power Automate (Assign Users)
Create Instant Flow: Assign users to task
Add flow inputs
Split multiple emails into an array
Map emails into a Claims object (Person field format)
Update SharePoint items via Power Automate
Pass values from the trigger
Add multiple emails to one Person field
Respond to Power Apps with a text output message
Install the flow in the app and bind a button to run it
Power BI Integration
Create a Power BI report
Add a stacked column chart
Add a pie chart
Use a URL query filter
Embed a Power BI tile in Power Apps
Filter the report from the gallery (dynamic filtering)
Share the Power BI report with app users separately
Filter & Manage Data with Power Automate (Critical Tasks)
Create responsive screen layout
Add nested containers
Add a gallery and controls to a container
Customise gallery data
Create Instant Flow: Critical tasks
Use Filter Query
Sort records
Initialise integer and string variables
Build and format an HTML table
Reshape table data and use HTML codes for formatting
Send emails from Power Automate
Pass flow output parameters back to the app
Generate PDFs & Save to SharePoint
Create Instant Flow: Create PDF (file input)
Convert time zone from UTC to local
Create files in SharePoint via Power Automate
Enable the PDF function in app settings
Generate a PDF from the task container
Send the PDF to the flow
Set gallery size dynamically
UI & UX Enhancements (Components)
Intro to Components
Create a sidebar component
Enable app scope access
Set width and height
Add icons, user image, and labels
Create custom properties
Bind controls to custom properties
Add components to app screens
What is PowerApps?
PowerApps is a Microsoft application that allows anybody to create an App using a point-and-click approach. It empowers users to create apps to solve problems and improve processes in the workplace without the need for IT developers. We are a market leader in PowerApps training.
What is Remote Training?
Remote training at Nexacu means our experienced trainers will deliver your training virtually. With remote learning, students can access our usual classroom training courses via video conferencing, ask questions, and participate in discussions as if they were in the room.
Which courses are available if I am working from home?
All of our Public Courses are available to be delivered remotely. Book any course as normal and you will receive login details and instructions the evening before your course.
How are PowerApps used in the workplace?
How PowerApps is used is as varied as Microsoft's customer base. A common use of PowerApps is as a data collection tool. Workers in the field collect data via the app on their own devices which is then collated in the cloud. The combined data can be analysed using Power BI to make data-driven decisions. The government of NSW are using PowerApps data collection to help reduce the level of homelessness, Priceline is using PowerApps to better serve customers and Virgin Airlines has included PowerApps in their safety compliance procedures. Our PowerApps course will empower you to create innovative solutions for your workplace problems.
How long does it take to learn PowerApps?
After our one-day PowerApps beginner course, you will be able to create a professional app that you can share within your organisation. You can continue on our intermediate course to advance your knowledge and capability within PowerApps. Learning how to integrate PowerApps with Power Automate and Power BI will open up lots more possibilities. Our Power Apps training can also be completed as part of one of our packages, which culminates in a Microsoft certification.
I previously attended a course with Excel Consulting, will the training be similar?
Yes, we rebranded from Excel Consulting in October 2019. The business quickly outgrew its original name. Our new brand Nexacu better reflects our direction, continued innovation and commitment to delivering next-level learning. We have always refined and continue to update our courses but retain our excellent trainers and deliver the same high-quality content.
Power Apps Training in Brisbane
View Dates
Power Apps Training in Melbourne
View Dates
Power Apps Training in Sydney
View Dates
Power Apps Training in Adelaide
View Dates
Power Apps Training in Perth
View Dates
Power Apps Training in Parramatta
View Dates
Power Apps Training in Canberra
View Dates
Power Apps Training in Remote Online
View Dates Power Apps BeginnerThis beginner Power Apps training course teaches you how to build custom business apps using Microsoft’s low-code platform.
Power Apps Intermediate (Building Smarter, Scalable Apps)In this intermediate Power Apps pathway, you’ll build a Task Management app connected to SharePoint while improving performance with collections and mastering Patch, variables, and delegation-aware filtering.
Power Apps AdvancedOur advanced Power Apps training course covers model-driven apps, Common Data Service (CDS), and portal development for enterprise use.
Power Apps Training in Brisbane
View Dates
Power Apps Training in Melbourne
View Dates
Power Apps Training in Sydney
View Dates
Power Apps Training in Adelaide
View Dates
Power Apps Training in Perth
View Dates
Power Apps Training in Parramatta
View Dates
Power Apps Training in Canberra
View Dates
Power Apps Training in Remote Online
View Datesat Nexacu, we're proud to be the trusted training partner for hundreds of leading organisations accross Australia and New Zealand. From government departments to top corporates, we help teams upskill and succeed everyday
Students
4 & 5 Star Reviews
Google Reviews
Businesses Trust Nexacu
Custom workbook included with a step by step exercises
Resit your course for free within 6 Months
