Companies Home Search Profile

Learn the Microsoft Power Platform Fundamentals in a Day

Focused View

4:56:34

0 View
  • 1. What is the goal of this course & how will we use the Power Platform tools.mp4
    02:30
  • 2. Introduction into the Power Platform & how the tools work collectively..mp4
    03:53
  • 1. The Task in Hand Automating the Drawdown process of our Loans..mp4
    07:43
  • 1. What is Power Virtual Agents & Using them externally on websites..mp4
    04:50
  • 2. Real Life Case Study - External & Internal use case of Power Virtual Agents.html
  • 3. Saving the files that we want the bot to locate users to, on SharePoint..mp4
    04:49
  • 4. Downloading the Power Virtual Agents app within Microsoft Teams..mp4
    00:54
  • 5. Creating our very first Power Virtual AgentCopilot!.mp4
    01:39
  • 6. Overview of the Canvas of Power Virtual Agents within Microsoft Teams..mp4
    07:10
  • 7. Building out our first topic!.mp4
    03:32
  • 8. Utilizing Variables in Topics..mp4
    02:44
  • 9. Redirecting to another separate topic within Power Virtual Agents!.mp4
    05:53
  • 10. Touching on the Call to action node & what this is!.mp4
    02:18
  • 11. Ending with Topic with a survey before we publish the Bot!.mp4
    02:36
  • 12. Publishing the bot within Microsoft Teams..mp4
    02:27
  • 1. What is Power Automate (Cloud version) & how can it help us.mp4
    03:52
  • 2. What is a Manual Process.mp4
    03:53
  • 3. Power Automate Cloud Vs Power Automate Desktop..mp4
    06:53
  • 4. Building out our first Automated Flow!.mp4
    09:42
  • 5. Adding Conditions into your Trigger!.mp4
    03:17
  • 6. Adding in Conditions into your Flow..mp4
    04:44
  • 7. Utilizing Templates to build out a similar flow!.mp4
    11:08
  • 8. Building out our first Instant Cloud Flow using an Excel Spreadsheet!.mp4
    11:22
  • 9. Building out an Automated Approval process using Forms & Approvals within Teams!.mp4
    14:52
  • 1. What is Power Apps & how can it help us.mp4
    03:26
  • 2. When to consider Power Apps!.mp4
    03:36
  • 3. Power Apps Canvas..mp4
    02:51
  • 4. Power Apps Templates - The Dos & Donts!.mp4
    03:26
  • 5. Building out our first App & first screen the Welcome Screen!.mp4
    06:17
  • 6. Adding controlsfeatures to our Welcome Screen!.mp4
    02:40
  • 7. Utilizing ChatGPT with PowerApps for the formula!.mp4
    03:49
  • 8. Connecting to our first Data Source - ProjectsList on SharePoint!.mp4
    04:25
  • 9. Adding our first Button to Power Apps!.mp4
    05:17
  • 10. Building out the main screen within our App, the UpdateTasks screen.mp4
    03:44
  • 11. Connecting our second Data Source!.mp4
    04:02
  • 12. Filtering within Power Apps!.mp4
    04:16
  • 13. Using a Gallery within Power Apps for the first time..mp4
    01:36
  • 14. Creating our first variable in Power Apps!.mp4
    09:08
  • 15. Adding our Third & Final Data Source!.mp4
    06:08
  • 16. Filtering our Gallery!.mp4
    02:39
  • 17. Adding more controls to our gallery..mp4
    07:38
  • 18. Applying one last filter to our gallery!.mp4
    03:25
  • 19. Using Patch for the first time to save the data back to SharePoint..mp4
    08:42
  • 20. Checking our results after Submitting the Tasks!.mp4
    02:25
  • 21. Adding a Hidden Toggle which we will use to Filter the Patch Function!.mp4
    02:46
  • 22. Using Patch with a conditionfilter applied!.mp4
    02:34
  • 23. Checking our results after applying the filter to the Patch Function!.mp4
    01:59
  • 24. Creating our Final Screen - The Success Screen!.mp4
    05:21
  • 25. Publishing your App!.mp4
    01:16
  • 1. Adding the camera control into the App & adding the column into SP to store data.mp4
    08:08
  • 1. Connecting your data from SharePoint to Power BI!.mp4
    09:59
  • 2. Setting up your table in Power BI & Publishing Report to Power BI Service..mp4
    11:51
  • 3. Generating the Power BI Query to connect to Power Automate!.mp4
    03:16
  • 4. Run a Query Against a Dataset, action in Power Automate & Building out flow!.mp4
    01:59
  • 5. Using the columns in the table in Power BI in your Power Automate flow!.mp4
    05:32
  • 6. Fully Building out the automated flow to occur every 2 weeks dynamically!.mp4
    03:35
  • 7. Formatting the table so it looks nice visually in the email!.mp4
    07:53
  • 1. Using Power Automate to send data back to the user from a Sharepoint list!.mp4
    07:06
  • 2. Using Power Automate to save data down in an Excel spreadsheet from the user!.mp4
    08:56
  • 3. It worked, I promise! ) & a big thank you for undertaking the course!.mp4
    01:25
  • 1. Summary & Thank You!.mp4
    00:47
  • 1.1 Power Platform in a Day - Fundamentals.pdf
  • 1. Course Slides.html
  • 2.1 Scope of Project - Current processes Vs the Goal.pdf
  • 2. Scope of ProjectCase Study.html
  • 3.1 Inspection Photo - Completed Unit.pdf
  • 3.2 Inspection Photo - Mid Phase Walls Up.pdf
  • 3.3 Inspection Photo - Preparing for Roof Install.pdf
  • 3.4 Inspection Photo - Site Excavation.pdf
  • 3.5 Loan Agreement - Lucy (1).pdf
  • 3.6 Lucy 1 - Floor Plans.pdf
  • 3.7 Lucy 1 - Sales Contract.pdf
  • 3.8 Lucy Original Budget - 7.2.24.xlsx
  • 3. Power Virtual Agents - Documents.html
  • 4.1 Project Tracker - Power Automate.xlsx
  • 4. Power Automate - Spreadsheet for Excel Flow.html
  • 5.1 budget builder logo.zip
  • 5.2 ProjectsList - Power Apps.xlsx
  • 5.3 TasksList - Power Apps.xlsx
  • 5.4 UnitsList - Power Apps.xlsx
  • 5. Power Apps - Data Sources & Budget Builder Logo.html
  • 1.1 Useful Resources.docx
  • 1. Useful Links.html
  • Description


    Learn Power Virtual Agents to create bots, Power Automate to automate processes and Power Apps to build internal apps!

    What You'll Learn?


    • Define the purpose & use cases of each of the Power Platform tools - Power BI, Power Automate, Power Apps & Power Virtual Agents
    • Learn how to create your own Power Virtual Agent (Copilot) within Microsoft Teams which can be published at the organization level
    • Learn how to build 'Flow's in Power Automate with other 365 tools such as Microsoft Forms, Outlook & also Power BI to drastically reduce manual work
    • Learn how to Build a full Power App which will be used to store progress on projects & stores the data on Sharepoint, which we then connect to Power BI!
    • Learn how to utilize ChatGPT to help with the majority of the formula used in Power Apps - enabling you to save huge amounts of time learning the formula
    • Learn how to use all the Power Platform tools collectively to transform & automate processes!

    Who is this 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.
  • What You Need to Know?


  • Access to these tools (Power Virtual Agents, Power Automate, Power Apps & also Power BI) should be free once the user has a Microsoft 365 license. If this is not the case, users will need to contact their M365 Admin to grant them access.
  • Access to ChatGPT is highly recommended to best follow the course - especially the Power Apps section.
  • Everything else will be taught in the course!
  • More details


    Description

    This course gives a basic understanding of  the fundamentals of Power Virtual Agents, Power Automate & Power Apps as well as touching on Power BI at a very high level. (Power BI is covered on a separate course I am currently building out).


    The course is built around a process that I used to manually complete for a previous employer where we will build a Power App using Microsoft Power Apps to track tasks on houses that are being built (store the data on SharePoint for simplicity) and then utilize Power Virtual Agents to show users how to enable the bots (within Microsoft Teams) to point users to the location of documents that may be scattered across different SharePoint sites such as loan documents, budgets and sales contracts (in the course of example). I see a huge use for these bots within HR & IT teams specifically to handle repetitive questions.


    I then show you can set up simple flows in Power Automate to save down attachments from specific senders (in the course example - saving down the attachments of the inspections the bank has organized of the units) as well as some other simple flows saving data from Microsoft Forms again on SharePoint & building out fully automated processes using the approvals app within Microsoft Teams.


    Once the app, bot & flow are complete, the final step is then creating a simple Power BI report and utilizing Power Automate to send a snapshot of the table with the latest tasks completed every 2 weeks to a specific sender (the bank in this example) requesting a draw with the date the tasks were completed and the budget amounts of those tasks (all collected in the app).

    Finally, this course is very high level, and I suggest to all learners to utilize ChatGPT for the more technical stuff such as the coding element/formula in a Power Apps, but this is covered on the course where I demonstrate how to utilize ChatGPT to the best of it's ability to help with the formula in Power Apps.


    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.

    User Reviews
    Rating
    0
    0
    0
    0
    0
    average 0
    Total votes0
    Focused display
    Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.
    • language english
    • Training sessions 60
    • duration 4:56:34
    • Release Date 2024/11/18