Build Solutions with Power Apps Power Automate SharePoint

Create enterprise applications with the Power Platform (PowerApps, Power Automate, and SharePoint), and master PL-900
Build Solutions with Power Apps Power Automate SharePoint
File Size :
9.49 GB
Total length :
22h 4m



Henry Habib


Last update




Build Solutions with Power Apps Power Automate SharePoint

What you’ll learn

Create enterprise grade applications and solutions using the Power Platform
Learn and master Power Apps, Power Automate, and SharePoint
Learn how to transfer data and interact between Power Apps, Power Automate, and SharePoint
Connect Power Platform to third party applications and services using connectors, HTTP requests, and APIs
Create user interface integrations, such as chatbots or phone applications
Become a Power Platform champion
Learn how to use the solution formula to create any solution and application
Create a complete end-to-end Uber-like application
Take Dynamics 365 to the next level
Get the PL-900 certification

Build Solutions with Power Apps Power Automate SharePoint


This course goes starts from the beginner level, so no prerequisites are required. Come hungry to learn!
Familiarity with Microsoft applications (Word, Excel, Outlook) is desired but not required
Familiarity with Office 365 applications (Power Automate, Power Apps, SharePoint) is desired but not required
Willingness to learn
Computer with web browser and internet


Do you know Power Apps but want to extend your knowledge and integrate other Power Platform features (Power Automate and SharePoint), including with PL-900?Do you want to build full enterprise solutions and applications for your organization and don’t know where to start? Do you want to upgrade from using Dynamics 365 to Power Platform?Do you know to know how to interact and transfer data between Power Platform applications, like Power Apps, Power Automate, SharePoint?Do you want to learn PowerApps, Power Automate, SharePoint in one integrated course, and help master PL-900?This is the course for you. Learn from more than 20 hours of relevant instructional video content, with the only course that will teach you how to use Power Apps, Power Automate, and SharePoint (Power Platform) to create a full solution beginner to end. We leverage the Power Platform to its full potential, and surpass Dynamics 365.First you will learn the basics of Power Apps, Power Automate, and SharePoint (Power Platform). Then, you will learn how to interact and transfer data between these platforms, and how to communicate with third party applications and user interfaces using HTTP requests and APIs. Finally, we will put our knowledge together and create a full end-to-end real-life enterprise application.In this course, we will rely on the solution formula: Full solution = User Interface (PowerApps) + Workflows (Power Automate) + Data (SharePoint)This is the only complete guide to building enterprise solutions using Microsoft’s framework – you won’t need another course. This course is not only comprehensive (it covers everything you need to know right from the start / beginner level) but is also instructional in nature, meaning that as we learn new concepts, we are also integrating them in our solution. Don’t just learn concepts, learn how to actually apply them. That also means that whether you are a beginner or expert, there’s something for you in this course.This course is also for those students who know either PowerApps, Power Automate, and SharePoint, but want to take their solutions to the next level by integrating all three platforms together. Students in this course will be experts at the Power Platform. Students can also take this course for the PL-900 certification, and to go beyond Dynamics 365.Again, we also go through a full solution at the end of the course, where you build and deploy a real-life enterprise application with the Power Platform (PowerApps, Power Automate, and SharePoint).What is this course all about?In this course, we learn about Power Apps, Power Automate, and SharePoint and take these platforms to the next level by building complete applications and solutions. We learn how data and information is transferred between these three platforms, and how you can extend these platforms through third party and user interface integrations. We discuss how you deploy, monitor, and improve your application and solution. Finally, we take all that we learn, and build a full complete application from start to finish.This is the course if you want to build a complete enterprise application, and want to use the solution formula and the Power Platform to do it.What is the solution formula?The solution formula is the three elements you need to create full applications and solutions for your organization. You need:User Interface (Power Apps)Workflow system (Power Automate)Data storage (SharePoint)What in Power Apps, Power Automate, and SharePoint?Microsoft Power Apps – PowerApps is Microsoft’s platform to build fully functional and cross-platform applications with little to no code. Think of PowerApps as Microsoft Word, but instead of building documents you are building real-life applications.Microsoft Power Automate – Power Automate is a platform to automate any and all tasks. You can streamline anything, including your emails, calendars, and business processes. Users have seen more than a 15% increase in productivity after using Power Automate for only a week!Microsoft SharePoint – SharePoint is a platform that organizations use to create internal websites (called team sites) that empower teamwork and improve collaboration. SharePoint allows organizations to seamlessly organize, share, manage, and access content and knowledge across their businesses.Why learn Power Apps, Power Automate, and SharePoint to build solutions and applications?Microsoft ecosystem – these platforms are similar to other Microsoft applications. They use the same ribbon and design functionality like commonly used tools, such as Word, Excel, and Power Point. They also interact and integrate well with each other, because they are part of Microsoft’s Power Platform.Easy to use (no-code platform) – No coding necessary or even required. Similar to other Microsoft applications, these platforms are a drag-and-drop system which makes things easy, and has an amazing user-friendly interface. The most complex code you will write are Excel-like formulas and functions.Connectors – Microsoft has built thousands of connectors for these platforms to extend them outside the Power Platform environment. For example, your application and solution can interact with Outlook, Gmail, Trello, Twitter, Airtable, Zapier, and so much more.Full control and customization – these platforms give you full control in what you want to create (PowerApps), what tasks you want to automate (Power Automate), and what data you want to store (SharePoint). All Power Platforms are built with customization in mind.Powerful reach and scaling – these platforms are used in self-employed organizations and for individual employees, all the way to large 100,000+ employee corporations and organizations.Extensions – If Microsoft does not already have a connector, these platforms have HTTP requests and API tools, enabling you to connect your application and solution to any other platform, even if it’s proprietary.Why choose this course?Complete guide – this is the 100% start to finish, zero to hero, basic to advanced guide on building full solutions and applications using Power Apps, Power Automate, and SharePoint. It also goes through crash courses on each platform. There is no other course like it that teaches you everything from start to finish. It contains over 20 hours of instructional content!Solution formula – we cover the solution and application formula in detail. This theory tells us that in order to build an application, we need to create a user interface (Microsoft Power Apps), a workflow management system (Microsoft Power Automate), and a database (Microsoft SharePoint). We also needs to learn how information and data is transferred between these applications.Structured to succeed – this course is structured to help you succeed. We first go through a crash course on PowerApps, Power Automate, and SharePoint so that everyone is on the same footing, and then we discuss how to create cross platform interactions, and third party integrations. We then create a full complete end-to-end solution and applications for our company, Dog Walkers United.Fully instructional – we not only go through important concepts, but also apply them as we are building our application so that we can solidify them. This is not only a walkthrough of the all the features and theoretical concepts, but a course that actually builds applications with you. This also helps with PL-900.Step by step – we go through every single concept in a sequential order (from learning about the platforms independently, to seeing how they connect together, and then to create a complete end-to-end solution). This improves your probabilities of learning these platforms to build solutions rather than going haphazardly through each feature.Learn to learn – during the latter parts of the course, we go through situations where we encounter new features or errors, and work through how we would use the documentation to resolve them. In this way, you not only learn about these platforms and how they interact inside and out, but learn how to resolve your own issues as they come up.Teacher response – if there’s anything else you would like to learn, or if there’s something you cannot figure out, I’m here for you! Look at the ways to reach out video.Reference material – follow along! I provide all reference material directly to you so you can follow along in your learning journey. This is also great reference material for PL-900.Course overviewIntroduction – learn what this course is about, solution formula, and how to succeedSharePoint Crash Course – learn about SharePoint, its features, and how to use it to create ListsPower Automate Crash Course – learn about Power Automate, its features, and how to automate tasksPower Apps Crash Course – learn about Power Apps, its features, and how to build user interfacesConnect Power Apps to SharePoint – forms, validations, custom inputs, galleries, filters, and modalsConnect SharePoint to Power Automate – custom alerts, http requests, notifications, approvals, lookupsConnect Power Automate to Power Apps – transfer data and images, response procedures, concurrent functionsThird party interactions – external input forms, syncing, HTTP requests, REST APIsUser Interface Interactions – chatbots, adaptive cards, apps on your phoneMonitor, Deploy, and Process Improvement – deploy solutions, monitor logs, see errorsSolution Build – Dog Walkers United – build a complete enterprise application for an Uber for Dog WalkersConclusion – earn your online certification, and read about next stepsIf you want to learn how to create enterprise-grade applications and solutions using the Microsoft Power Platform (Power Apps, Power Automate, and SharePoint), then this is the course for you. We’re looking forward to having you in the course and hope you earn the certificate.Music: Bensound


Section 1: Introduction

Lecture 1 What is this course?

Lecture 2 Example of solution formula

Lecture 3 What is Power Apps?

Lecture 4 What is Power Automate?

Lecture 5 What is SharePoint?

Lecture 6 Course roadmap

Lecture 7 Who am I?

Lecture 8 Ways to reach out

Lecture 9 Keys to success

Lecture 10 Leave a rating

Lecture 11 Watch in 1080p

Section 2: SharePoint Crash Course

Lecture 12 Introduction to SharePoint

Lecture 13 Reference material

Lecture 14 Setting up your environment 1

Lecture 15 Setting up your environment 2

Lecture 16 Site layout

Lecture 17 Create a new Document Library

Lecture 18 Benefits of Document Library 1

Lecture 19 Benefits of Document Library 2

Lecture 20 Pages

Lecture 21 Pages with file viewer

Lecture 22 SharePoint Lists – create a new list and add columns

Lecture 23 SharePoint Lists – add rows from excel

Lecture 24 SharePoint Lists – importing rows from excel

Lecture 25 SharePoint List Benefit – public records

Lecture 26 SharePoint List Benefit – new columns

Lecture 27 SharePoint List Benefit – form and column validation

Lecture 28 SharePoint List Benefit – formatting

Lecture 29 SharePoint List Benefit – alerts

Section 3: Power Automate Crash Course

Lecture 30 Introduction to Power Automate

Lecture 31 Features of Power Automate

Lecture 32 Environment setup

Lecture 33 What is a flow?

Lecture 34 Types of flows

Lecture 35 Create your first flow

Lecture 36 Flow details

Lecture 37 Dynamic content

Lecture 38 Expressions

Lecture 39 Flow conditions 1

Lecture 40 Flow conditions 2

Lecture 41 Automated cloud flows 1

Lecture 42 Automated cloud flows 2

Lecture 43 Approvals 1

Lecture 44 Approvals 2

Lecture 45 Approvals 3

Lecture 46 Parallel branches

Lecture 47 Clipboard

Section 4: Power Apps Crash Course

Lecture 48 Introduction to Power Apps

Lecture 49 Reference material

Lecture 50 Environment setup

Lecture 51 Development environment

Lecture 52 Dynamic assignment

Lecture 53 Actions and navigate

Lecture 54 Variables

Lecture 55 Functions and formulas

Lecture 56 If statements

Lecture 57 Setting up data

Lecture 58 Connecting to data

Lecture 59 Data tables

Lecture 60 Galleries 1

Lecture 61 Galleries 2

Lecture 62 View forms and galleries

Lecture 63 Edit Forms 1

Lecture 64 Edit Forms 2

Lecture 65 Filter and search

Lecture 66 Save and deploy

Section 5: CPI – Power Apps to SharePoint

Lecture 67 Introduction

Lecture 68 Reference material

Lecture 69 Adding users to SharePoint

Lecture 70 Adding data to gallery

Lecture 71 Conditional formatting in galleries

Lecture 72 Adding a view

Lecture 73 Edit form mode 1

Lecture 74 Edit form mode 2

Lecture 75 Note on references

Lecture 76 Locking edit cells

Lecture 77 Adding records

Lecture 78 Creating default locked values in new forms

Lecture 79 Adding a cancel edit and cancel new button

Lecture 80 Making input forms and data cards conditional

Lecture 81 Form validation 1

Lecture 82 Form validation 2

Lecture 83 Form validation 3

Lecture 84 Form validation propagation

Lecture 85 Adding new columns and updating schemas

Lecture 86 Adding custom inputs – sliders

Lecture 87 Adding custom inputs – data cards

Lecture 88 Adding custom inputs – visual inputs

Lecture 89 Adding custom inputs – using the update property

Lecture 90 Adding custom inputs – making it work in view mode

Lecture 91 Adding custom inputs – clean up

Lecture 92 Refreshing data

Lecture 93 Deleting records

Lecture 94 Deleting records the easy way

Lecture 95 Deleting records the better way 1

Lecture 96 Deleting records the better way 2

Lecture 97 Form and modal popup 1

Lecture 98 Form and modal popup 2

Lecture 99 Adding filters 1

Lecture 100 Adding filters 2

Lecture 101 Advanced filters

Lecture 102 Counting number of rows in gallery

Lecture 103 Create a Power App with data in seconds

Lecture 104 Search

Section 6: CPI – SharePoint to Power Automate

Lecture 105 Introduction

Lecture 106 Reference material

Lecture 107 Connect SharePoint List to Power Automate

Lecture 108 Simple alert and notification systems

Lecture 109 Custom alerts based on column changes 1

Lecture 110 Custom alerts based on column changes 2

Lecture 111 Custom alerts based on specific column changes

Lecture 112 HTTP requests to SharePoint lists 1

Lecture 113 HTTP requests to SharePoint lists 2

Lecture 114 HTTP requests to SharePoint lists 3

Lecture 115 Customize who received alerts

Lecture 116 Daily digest notifications – ODATA

Lecture 117 Daily digest notifications – running the flow

Lecture 118 Daily digest notifications – subtracting date columns

Lecture 119 Daily digest notifications – finishing up and conversions

Lecture 120 Data and list manipulation

Lecture 121 Data and list manipulation with batch update

Lecture 122 Mixing in approvals

Lecture 123 Testing approvals

Lecture 124 Multiresponse approvals and comments

Lecture 125 Multiresponse approvals and comments testing

Lecture 126 Using automate to lookup between different tables

Lecture 127 Using automate to lookup between different tables – test

Lecture 128 Parse emails to load data to SharePoint List

Section 7: CPI – Power Automate to Power Apps

Lecture 129 Introduction

Lecture 130 Reference material

Lecture 131 Run Power Automate workflow from Power Apps

Lecture 132 Transfer data from Power Apps to Power Automate

Lecture 133 Transfer condition variables from Power Apps to Power Automate

Lecture 134 Transfer user variables based on gallery selection

Lecture 135 Transfer images and files from Power Apps to Power Automate

Lecture 136 Transfer images and files with file name

Lecture 137 Transfer signatures workshop

Lecture 138 Two way communication – strings

Lecture 139 Two way communication – add two numbers and return sum

Lecture 140 Two way communication – return two outputs from Power Apps

Lecture 141 Two way communication – multiple outputs

Lecture 142 Two way communication – response and respond function

Lecture 143 Two way communication – transfer data table array records from Power Automate to

Lecture 144 Concurrent functions 1 – set up

Lecture 145 Concurrent functions 2 – full examples

Lecture 146 Concurrent functions 3 – with Power Automate

Lecture 147 Transfer single record information

Lecture 148 Transfer multiple record information

Section 8: Third Party Interactions

Lecture 149 Introduction

Lecture 150 Reference material

Lecture 151 Using forms as an input UI 1

Lecture 152 Using forms as an input UI 2

Lecture 153 Using forms as an input UI 3

Lecture 154 Use Power Automate to parse emails

Lecture 155 Use Excel online as a data source 1

Lecture 156 Use Excel online as a data source 2

Lecture 157 Sync data with Power Automate

Lecture 158 Sync data with Power Automate – Add

Lecture 159 Sync data with Power Automate – Modify

Lecture 160 Sync data with Power Automate – Delete

Lecture 161 Power Automate to sync Forms with Trello 1

Lecture 162 Power Automate to sync Forms with Trello 2

Lecture 163 API and how to use them

Lecture 164 REST API example 1

Lecture 165 REST API example 2

Lecture 166 REST API example 3

Lecture 167 Connect REST API to Power Apps

Section 9: User Interface Integrations

Lecture 168 Introduction

Lecture 169 Using a chatbot

Lecture 170 Setting up the chatbot flow

Lecture 171 Chatbot and parse JSON

Lecture 172 Chatbot with the slice function

Lecture 173 Chatbot and putting it all together

Lecture 174 Adaptive cards

Lecture 175 Adding adaptive cards from workflows

Lecture 176 Creating dynamic adaptive cards

Lecture 177 Adaptive cards with actions

Lecture 178 Adaptive cards with inputs

Lecture 179 Apps on your phone 1

Lecture 180 Apps on your phone 2

Section 10: Solution Build – Dog Walkers United

Lecture 181 Introduction to Dog Walkers United

Lecture 182 Reference material

Lecture 183 Create the dogs data schema

Lecture 184 Fill the dog data

Lecture 185 Create the trips schema

Lecture 186 Fill the trips schema

Lecture 187 Add photos

Lecture 188 Add booking lists

Lecture 189 Create title page

Lecture 190 Set up the dogs page

Lecture 191 Create the dogs gallery

Lecture 192 Add functionality to dogs gallery

Lecture 193 Add dog profile page

Lecture 194 Add dog trips 1

Lecture 195 Add dog trips 2

Lecture 196 Add dog trips 3

Lecture 197 Make visibility of dog trips conditional

Lecture 198 Create navigation on dog page

Lecture 199 Create trips page layout

Lecture 200 Create trips gallery

Lecture 201 Add photos to trips 1

Lecture 202 Add photos to trips 2

Lecture 203 Set up dogwalker filter 1

Lecture 204 Set up dogwalker filter 2

Lecture 205 Set up dogwalker filter 3

Lecture 206 Set up dogwalker filter 4

Lecture 207 Add trip order

Lecture 208 Finish trip order logic

Lecture 209 Add trip information page

Lecture 210 Add functionality to dog profile

Lecture 211 Add form functionality

Lecture 212 Auto increment title

Lecture 213 Add slider into form

Lecture 214 Add rating into form

Lecture 215 Add attachments to form

Lecture 216 Create form modal functionality

Lecture 217 Create back button

Lecture 218 Test form functionality

Lecture 219 Toggle between photos and attachments

Lecture 220 Edit modal screen

Lecture 221 Trip menu navigation and refresh

Lecture 222 Booking page setup

Lecture 223 Create future bookings

Lecture 224 Make future booking clean

Lecture 225 Your next booking

Lecture 226 Booking refresh

Lecture 227 Your next booking logic 1

Lecture 228 Your next booking logic 2

Lecture 229 Power automate flows for emails 1

Lecture 230 Power automate flows for emails 2

Lecture 231 Google maps launch

Lecture 232 Create an email invoice flow

Section 11: Conclusion

Lecture 233 Congratulations

Lecture 234 Conclusion and next steps

Lecture 235 Certificate

Section 12: Bonus

Lecture 236 Bonus

Managers and employees who want to build internal applications and solutions for their organization,Managers and employees who want to automate a process or streamline a task,Managers and employees who want to increase efficiency and optimize a process,Anyone who wants to learn how to build enterprise grade applications and solutions using the Power Platform,Anyone who wants to obtain the Power Platform certifications (e.g., PL-100),Power Platform users who want to take their solution and application building skills to the Expert level,Dynamics 365 users who want to transfer to Power Platform

Course Information:

Udemy | English | 22h 4m | 9.49 GB
Created by: Henry Habib

You Can See More Courses in the Developer >> Greetings from

New Courses

Scroll to Top