We may earn an affiliate commission when you visit our partners.
Course image
Henry Habib

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?

Read more

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 overview

  • Introduction - learn what this course is about, solution formula, and how to succeed

  • SharePoint Crash Course - learn about SharePoint, its features, and how to use it to create Lists

  • Power Automate Crash Course - learn about Power Automate, its features, and how to automate tasks

  • Power Apps Crash Course - learn about Power Apps, its features, and how to build user interfaces

  • Connect Power Apps to SharePoint - forms, validations, custom inputs, galleries, filters, and modals

  • Connect SharePoint to Power Automate - custom alerts, http requests, notifications, approvals, lookups

  • Connect Power Automate to Power Apps - transfer data and images, response procedures, concurrent functions

  • Third party interactions - external input forms, syncing, HTTP requests We're looking forward to having you in the course and hope you earn the certificate.

    Music: Bensound

Enroll now

What's inside

Learning objectives

  • 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

Syllabus

Introduction
What is this course?
Example of solution formula
What is Power Apps?
Read more
What is Power Automate?
What is SharePoint?
Course roadmap
Who am I?
Ways to reach out
Keys to success
Leave a rating
Watch in 1080p
SharePoint Crash Course
Introduction to SharePoint
Reference material
Setting up your environment 1
Setting up your environment 2
Site layout
Create a new Document Library
Benefits of Document Library 1
Benefits of Document Library 2
Pages
Pages with file viewer
SharePoint Lists - create a new list and add columns
SharePoint Lists - add rows from excel
SharePoint Lists - importing rows from excel
SharePoint List Benefit - public records
SharePoint List Benefit - new columns
SharePoint List Benefit - form and column validation
SharePoint List Benefit - formatting
SharePoint List Benefit - alerts
Power Automate Crash Course
Introduction to Power Automate
Features of Power Automate
Environment setup
What is a flow?
Types of flows
Create your first flow
Flow details
Dynamic content
Expressions
Flow conditions 1
Flow conditions 2
Automated cloud flows 1
Automated cloud flows 2
Approvals 1
Approvals 2
Approvals 3
Parallel branches
Clipboard
Power Apps Crash Course
Introduction to Power Apps
Development environment
Dynamic assignment
Actions and navigate
Variables
Functions and formulas
If statements
Setting up data
Connecting to data
Data tables
Galleries 1
Galleries 2
View forms and galleries
Edit Forms 1
Edit Forms 2
Filter and search
Save and deploy
CPI - Power Apps to SharePoint
Adding users to SharePoint
Adding data to gallery
Conditional formatting in galleries
Adding a view
Edit form mode 1
Edit form mode 2
Note on references
Locking edit cells
Adding records
Creating default locked values in new forms
Adding a cancel edit and cancel new button
Making input forms and data cards conditional
Form validation 1
Form validation 2
Form validation 3
Form validation propagation
Adding new columns and updating schemas
Adding custom inputs - sliders
Adding custom inputs - data cards
Adding custom inputs - visual inputs
Adding custom inputs - using the update property
Adding custom inputs - making it work in view mode
Adding custom inputs - clean up
Refreshing data
Deleting records
Deleting records the easy way
Deleting records the better way 1

Good to know

Know what's good
, what to watch for
, and possible dealbreakers
Covers Power Apps, Power Automate, and SharePoint, which are in high demand in the industry
Provides a comprehensive overview of the Power Platform, including its components and how they interact
Taught by instructors with extensive experience in the field
Offers hands-on labs and interactive materials to enhance learning
Develops foundational knowledge in Power Apps, Power Automate, and SharePoint, making it suitable for beginners
May require additional prerequisite knowledge or experience in related technologies

Save this course

Save Build Solutions with Power Apps, Power Automate & SharePoint to your list so you can find it easily later:
Save

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Build Solutions with Power Apps, Power Automate & SharePoint with these activities:
Watch YouTube Videos on Power Automate Flows
Learn the basics of creating Power Automate flows to automate common tasks and processes.
Browse courses on Power Automate
Show steps
  • Find YouTube videos on Power Automate flows.
  • Watch videos on creating simple and advanced flows.
  • Try out some of the flows you learn about.
Practice Building SharePoint Lists and Forms
Become proficient in creating and managing SharePoint lists and forms to store and organize data.
Browse courses on SharePoint
Show steps
  • Create a new SharePoint list.
  • Add columns and customize the list.
  • Create a form for the list.
  • Add validation and formatting to the form.
Build a Simple Power App with Forms and Galleries
Gain hands-on experience in building a real-world application with Power Apps to display data from SharePoint lists and allow users to interact with it.
Browse courses on Power Apps
Show steps
  • Connect Power Apps to a SharePoint list.
  • Create a form to display and edit list items.
  • Add a gallery to display multiple list items.
  • Implement actions to create, update, and delete list items.
Show all three activities

Career center

Learners who complete Build Solutions with Power Apps, Power Automate & SharePoint will develop knowledge and skills that may be useful to these careers:
Data Analyst
Data Analysts bring structure to data using spreadsheets and databases, and help companies and organizations make better decisions with their collected information. This course is an excellent fit for those who wish to move into this field. It provides a solid foundation in database management with Microsoft's Sharepoint. This course also covers essential tools such as Power Automate and Power Apps, which enable data analysts to automate tasks, create intuitive dashboards, and integrate data from multiple sources.
Data Architect
Data Architects design and manage the data systems that companies and organizations use to store and process data. This course can provide a helpful foundation for this field. It provides a comprehensive overview of data management, including database design with SharePoint, data integration with Power Automate, and data visualization with Power BI.
BI Analyst
BI (Business Intelligence) Analysts gather data, analyze trends, and create reports that help companies understand their operations and performance. This course can be a useful step for those seeking to enter this field. It covers foundational tools such as Power BI and SharePoint, which are widely used in the field. Furthermore, the emphasis on data integration and automation can be helpful for BI Analysts.
IT Business Analyst
IT Business Analysts help companies and organizations analyze, design, and implement new or improved IT systems. This course can provide a strong foundation for this field. It covers essential tools such as Power Apps, Power Automate, and SharePoint, which are commonly used by IT Business Analysts to gather data, automate tasks, and create presentations and reports.
Business Systems Analyst
Business Systems Analysts help companies and organizations analyze, design, and implement new or improved business systems. This course can provide a strong foundation for this field. It covers essential tools such as Power Apps, Power Automate, and SharePoint, which are commonly used by Business Systems Analysts to gather data, automate tasks, and create presentations and reports.
IT Project Manager
IT Project Managers plan, manage, and execute IT projects. This course can be a useful step for those seeking to enter this field. It covers essential tools such as Power Apps, Power Automate, and SharePoint, which are commonly used by IT Project Managers to manage tasks, track progress, and communicate with team members. The emphasis on building end-to-end solutions can be particularly helpful for those managing complex IT projects.
Operations Manager
Operations Managers oversee the day-to-day operations of companies and organizations. This course can be a useful tool for those aspiring to enter this field. It covers essential tools such as Power Apps, Power Automate, and SharePoint, which are commonly used by Operations Managers to manage data, automate tasks, and track progress. The focus on building end-to-end solutions can be especially helpful for those managing complex operations.
Business Analyst
Business Analysts work with companies and organizations to improve their performance and efficiency. This course can provide a helpful foundation for this field. It covers essential tools such as Power Apps, Power Automate, and SharePoint, which are commonly used by business analysts to gather data, automate tasks, and create presentations and reports.
Project Manager
Project Managers plan, organize, and execute projects. This course can be a useful step for those seeking to enter this field. It covers essential tools such as Power Apps, Power Automate, and SharePoint, which are commonly used by Project Managers to manage tasks, track progress, and communicate with team members. The emphasis on building end-to-end solutions can be particularly helpful for those managing complex projects.
Consultant
Consultants provide advice and recommendations to companies and organizations on a variety of topics, including IT, business strategy, and operations. This course can provide a helpful foundation for this field. It covers essential tools such as Power Apps, Power Automate, and SharePoint, which are commonly used by consultants to gather data, automate tasks, and create presentations and reports. The emphasis on building end-to-end solutions can be particularly helpful for those consulting on IT systems and business processes.
Technical Writer
Technical Writers create instruction manuals, user guides, and other documentation that helps people use products and services. This course can provide a helpful foundation for this field. It covers essential tools such as Power Apps, Power Automate, and SharePoint, which are commonly used to create interactive documentation. Additionally, the emphasis on creating user interfaces and user experiences can be helpful for Technical Writers.
Data Scientist
Data Scientists analyze data and use their findings to develop solutions that help companies and organizations improve their operations and performance. This course may be useful for those interested in entering this field. It provides a strong foundation in data management with SharePoint, as well as exposure to data analysis and visualization tools like Power BI.
IT Analyst
IT Analysts help companies and organizations design, implement, and maintain their IT systems. This course can be a useful step for those seeking to enter this field. It provides a foundation in data management with SharePoint, as well as exposure to workflow automation with Power Automate. This course may be especially useful for those interested in IT systems management.
Product Manager
Product Managers plan, develop, and launch new products or features. This course can be a useful tool for those aspiring to enter this field. It covers user interface design with Power Apps, workflow automation with Power Automate, and data management with SharePoint, which are all essential tools for Product Managers. The focus on building end-to-end applications can be especially helpful for those developing new products.
Software Engineer
Software Engineers design, develop, test, and maintain computer software. This course can be a helpful tool for those aspiring to enter this field. It covers the fundamentals of software development, including data management with SharePoint, UI design with Power Apps, and workflow automation with Power Automate. This course may be especially useful for those interested in developing business applications.

Reading list

We've selected seven books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in Build Solutions with Power Apps, Power Automate & SharePoint.
Highly-regarded guide to DevOps practices. It is particularly valuable to someone who wants to learn about the principles and practices of DevOps.
Deep dive into how to use Power Automate. It is also useful as a reference guide as it covers many features of Power Automate.
Useful reference for using Microsoft Power Automate. It is particularly valuable to someone who wants to create enterprise workflows.
Provides a collection of practical recipes and solutions for common challenges faced when working with the Microsoft Power Platform. It covers a wide range of topics, from data integration to process automation, making it a valuable resource for those looking to quickly and effectively solve problems.
Provides a hands-on guide to building mobile and web applications using Power Apps. It covers essential concepts, best practices, and real-world examples, making it a valuable resource for those looking to quickly get started with Power Apps development.
Guide to using Visual Studio Code, a popular code editor. It is particularly valuable to someone who wants to use Visual Studio Code to develop cloud-native applications.
Covers Power BI, a solution used for data analysis. It is particularly valuable to those who want to do enterprise reporting.

Share

Help others find this course page by sharing it with your friends and followers:

Similar courses

Here are nine courses similar to Build Solutions with Power Apps, Power Automate & SharePoint.
Use Power Automate & SharePoint to Automate Invoice...
Most relevant
Use Power Platform for Custom & Automated Solutions
Most relevant
Use AI Builder and Power Apps to Process Invoice Data
Most relevant
Automate Approval Process with SharePoint & Power Automate
Most relevant
Automate Doc Review Process with SharePoint & Power...
Most relevant
Generate Reports with the Help of a Flow Inside Power Apps
Most relevant
Automate Equipment Ordering Prep Process with Power...
Most relevant
Microsoft PowerApps & Flow: Build Business Apps Without...
Most relevant
ChatGPT Masterclass - Build Solutions and Apps with...
Most relevant
Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2024 OpenCourser