Schița de curs
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 into 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 case of Power Virtual Agents
- Saving the files that we want the bot to locate users to, on SharePoint
- Downloading the Power Virtual Agents app within Microsoft Teams
- Creating our very first Power Virtual Agent/Copilot!
- Overview of the Canvas of Power Virtual Agents within Microsoft Teams
- Building out 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 with Topic with a survey before we publish 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 out our first Automated Flow
- Adding Conditions into your Trigger
- Adding in Conditions into your Flow
- Utilizing Templates to build out a similar Flow
- Building out our first Instant Cloud Flow using an Excel Spreadsheet
- Building out 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't's
- Building out our first App and first screen the “Welcome Screen”
- Utilizing ChatGPT with PowerApps for the formula
- Connecting to our first Data Source - ProjectList on SharePoint!
- Adding our first “Button” to Power Apps
- Building out the main screen withn 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 the 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 in the ability to add photos in the App
- Adding the camera control into the App ad 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 nice visually 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
Cerințe
Who this course is for:
- Business Analysts: Looking to automate routine tasks and processes, interested in creating custom applications without extensive coding knowledge & aiming to improve data visualization and reporting capabilities.
- IT Professionals: Seeking to streamline business operations through automation, wanting to integrate different systems and services seamlessly & desiring to support their organization in digital transformation initiatives.
- Entrepreneurs and Small Business Owners: Aiming to develop cost-effective solutions to manage their business processes, interested in leveraging technology to gain competitive advantages & looking to enhance customer engagement and operational efficiency.
- Students and Graduates: Aspiring to gain skills in one of the most in-demand areas of technology, looking to add practical, hands-on experience with industry-standard tools to their resume & wanting to build a strong foundation in low-code/no-code development.
- Project Managers: Seeking to improve project workflows and task management, interested in automating repetitive tasks to focus on strategic planning & looking to provide their teams with efficient tools for better collaboration and productivity.
- 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 & looking to enhance the overall employee experience through efficient digital solutions.
- Anyone Interested in Automation and App Development: 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 & looking to solve real-world problems with practical, easy-to-implement solutions.
Mărturii (1)
Am crezut că formatorul a fost foarte atrăgător și a fost foarte rapid în picioare pentru a răspunde la întrebări legate de munca noastră și a adaptat cu adevărat predarea la nevoile noastre și a mers mai sus și mai departe pentru a le satisface. Nu l-aș putea recomanda suficient pe Shaun!
Tom King - Complete Coherence
Curs - Microsoft Power Platform Fundamentals
Tradus de catre o masina