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?
- The objective of this course and how we will utilize the Power Platform tools for government.
- Introduction to the Power Platform and an overview of how the tools work together.
Explanation of the processes we have been tasked with automating for government.
- The Task at Hand: Automating the Drawdown process of our Loans for government.
Power Virtual Agents
- What is Power Virtual Agents and how can they be used externally on websites for government?
- Real-life case study - External and internal use cases of Power Virtual Agents in a government setting.
- Saving files that the bot will locate users to, on SharePoint for government.
- Downloading the Power Virtual Agents app within Microsoft Teams for government.
- Creating our first Power Virtual Agent/Copilot for government.
- Overview of the Canvas of Power Virtual Agents within Microsoft Teams for government.
- Building out our first topic for government.
- Utilizing variables in topics for government.
- Redirecting to another separate topic within Power Virtual Agents for government.
- Exploring the Call to Action node and its purpose for government.
- Concluding a topic with a survey before publishing the bot for government.
- Publishing the bot within Microsoft Teams for government.
Power Automate
- What is Power Automate (Cloud version) and how can it assist in government operations?
- Understanding manual processes for government.
- Comparing Power Automate Cloud with Power Automate Desktop for government use.
- Building out our first automated flow for government.
- Adding conditions to your trigger for government.
- Incorporating conditions into your flow for government.
- Utilizing templates to build similar flows for government.
- Building out our first instant cloud flow using an Excel spreadsheet for government.
- Constructing an automated approval process using forms and approvals within Teams for government.
Power Apps
- What is Power Apps and how can it benefit government operations?
- When to consider using Power Apps in a government context.
- Overview of the Power Apps Canvas for government.
- Best practices for using Power Apps templates in government.
- Building out our first app and creating the “Welcome Screen” for government.
- Utilizing ChatGPT with PowerApps to develop formulas for government.
- Connecting to our first data source - ProjectList on SharePoint for government.
- Adding our first “Button” to Power Apps for government.
- Building out the main screen of our app, the “UpdateTasks” screen for government.
- Connecting our second data source for government.
- Filtering within Power Apps for government.
- Using a gallery within Power Apps for the first time for government.
- Creating our first variable in Power Apps for government.
- Adding our third and final data source for government.
- Filtering our gallery for government.
- Adding more controls to our gallery for government.
- Using Patch for the first time to save data back to SharePoint for government.
- Checking results after submitting tasks for government.
- Adding a hidden toggle to filter the Patch function for government.
- Using Patch with a condition/filter applied for government.
- Checking results after applying the filter to the Patch function for government.
- Creating our final screen - The “Success Screen” for government.
- Publishing your app for government.
Additional Material: Adding the ability to add photos in the App for government.
- Adding the camera control to the app and creating a column in SharePoint to store data for government.
Additional Material: Connecting the App to Power BI to generate automated emails for government.
- Connecting your data from SharePoint to Power BI for government.
- Setting up your table in Power BI and publishing the report to Power BI Service for government.
- Generating the Power BI query to connect to Power Automate for government.
- Using the “Run a Query Against a Dataset” action in Power Automate and building out the flow for government.
- Utilizing columns in the table in Power BI in your Power Automate flow for government.
- Fully building out the automated flow to occur every two weeks dynamically for government.
- Formatting the table so it looks visually appealing in the email for government.
Additional Material: Using Power Automate within Power Virtual Agents for government.
- Using Power Automate to send data back to the user from a SharePoint list for government.
- Using Power Automate to save data in an Excel spreadsheet from the user for government.
Summary and Next Steps for government.
Requirements
Who this Course is For:
- Business Analysts: Those seeking to automate routine tasks and processes, interested in developing custom applications without extensive coding knowledge, and aiming to enhance data visualization and reporting capabilities for government.
- IT Professionals: Individuals looking to streamline business operations through automation, desiring to integrate different systems and services seamlessly, and supporting their organization in digital transformation initiatives for government.
- Entrepreneurs and Small Business Owners: Aiming to develop cost-effective solutions to manage business processes, interested in leveraging technology to gain competitive advantages, and looking to enhance customer engagement and operational efficiency for government.
- Students and Graduates: Aspiring to gain skills in one of the most in-demand areas of technology, seeking to add practical, hands-on experience with industry-standard tools to their resume, and wanting to build a strong foundation in low-code/no-code development for government.
- Project Managers: Seeking to improve project workflows and task management, interested in automating repetitive tasks to focus on strategic planning, and providing their teams with efficient tools for better collaboration and productivity for government.
- HR Professionals: 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 enhance the overall employee experience through efficient digital solutions for government.
- Anyone Interested in Automation and App Development: Enthusiasts eager to learn 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 looking to solve real-world problems with practical, easy-to-implement solutions for government.
7 Hours
Testimonials (2)
I thought the trainer was really engaging and was very quick on his feet to answer questions that were related to our work and really tailored the teaching towards our needs and went above and beyond to meet them. I could not recommend Shaun enough!
Tom King - Complete Coherence
Course - Microsoft Power Platform Fundamentals
I really admire Trainer's patience for all the people who were asking him to repeat something 4-5 times. I also believe that he has great knowledge about the topic, but like said above, we didn't spend enough time on this. Moreover, it was good it was hands-on training, where we could practice in real time what we're taught, but again, I'd like to know more about the PowerApps, not about SharePoint, as I'm really familiar with that one, and if I wanted to learn more, I'd probably just choose a training for the SharePoint, not PowerApps.
