Build Solutions with Power Apps, Power Automate & SharePoint

Build Powerful Apps with the PowerApps, Power Automate, and SharePoint

Start Now See Other Courses

What is Power Apps, Power Automate, and SharePoint?

Microsoft Power Apps: A low-code, cross-platform app development solution that allows businesses to create applications tailored to their unique needs. Power Apps connects to various data sources, streamlining information access and providing users with mobile-friendly apps that work seamlessly across devices, ultimately improving the user experience.
Microsoft Power Automate: It features an intuitive interface that enables easy, code-free workflow automation. With pre-built connectors that integrate with popular apps, it effectively reduces manual and repetitive tasks, leading to increased productivity and driving growth and innovation within businesses.
Microsoft SharePoint: Thise serves as a centralized collaboration hub with seamless integration with other Microsoft tools, enhancing teamwork and communication. SharePoint ensures data security through customizable settings that control access to sensitive information and is highly scalable, making it suitable for organizations of all sizes, from small teams to large enterprises.

What you will learn

Build Enterprise Applications with Power Platform

Gain a thorough understanding of how to create enterprise-grade applications and solutions using Power Platforms
Create User Interface Integrations

Learn how to design and develop chatbots, phone applications, and other user interface integrations, empowering you to become a well-rounded Power Platform expert.
Boost Productivity with no-code App Development

Discover the solution formula, a powerful method that empowers you to create any solution or application, including a complete end-to-end Uber-like application.

Why learn Power Apps, Power Automate, and SharePoint to build solutions and applications?

Microsoft Ecosystem: Seamless integration within the Microsoft environment, offering a similar user experience to popular tools like Word, Excel, and PowerPoint.
No-Code Functionality: Drag-and-drop systems and user-friendly interfaces that require only Excel-like formulas and functions.
Thousands of Connectors: Integrate your application or solution with external tools and services like Outlook, Gmail, Trello, and more.
Full Control and Customization: Tailor-made solutions with control over app creation, task automation, and data storage.
Powerful Reach and Scalability: Suitable for all organization sizes, from self-employed individuals to large corporations.
Extensions and Versatility: Connect to any other platform, even if proprietary, using HTTP requests and API tools.

Course curriculum

1. What is this course?
2. Example of solution formula
3. What is Power Apps?
4. What is Power Automate?
5. What is SharePoint?
6. Course roadmap
7. Who am I?
8. Keys to success
1. Introduction to SharePoint
2. Setting up your environment 1
3. Setting up your environment 2
4. Site layout
5. Create a new Document Library
6. Benefits of Document Library 1
7. Benefits of Document Library 2
8. Pages
9. Pages with file viewer
10. SharePoint Lists - create a new list and add columns
11. SharePoint Lists - add rows from excel
12. SharePoint Lists - importing rows from excel
13. SharePoint List Benefit - public records
14. SharePoint List Benefit - new columns
15. SharePoint List Benefit - form and column validation
16. SharePoint List Benefit - formatting
17. SharePoint List Benefit - alerts
1. Introduction to Power Automate
2. Features of Power Automate
3. Environment setup
4. What is a flow?
5. Types of flows
6. Create your first flow
7. Flow details
8. Dynamic content
9. Expressions
10. Flow conditions 1
11. Flow conditions 2
12. Automated cloud flows 1
13. Automated cloud flows 2
14. Approvals 1
15. Approvals 2
16. Approvals 3
17. Parallel branches
18. Clipboard
1. Introduction to Power Apps
2. Environment setup
3. Development environment
4. Dynamic assignment
5. Actions and navigate
6. Variables
7. Functions and formulas
8. If statements
9. Setting up data
10. Connecting to data
11. Data tables
12. Galleries 1
13. Galleries 2
14. View forms and galleries
15. Edit forms 1
16. Edit forms 2
17. Filter and search
18. Save and deploy
1. Introduction
2. Adding users to SharePoint
3. Adding data to gallery
4. Conditional formatting in galleries
5. Adding a view
6. Edit form mode 1
7. Edit form mode 2
8. Note on references
9. Locking edit cells
10. Adding records
11. Creating default locked values in new forms
12. Adding a cancel edit and cancel new button
13. Making input forms and data cards conditional
14. Form validation 1
15. Form validation 2
16. Form validation 3
17. Form validation propogation
18. Adding new columns and updating schemas
19. Adding custom inputs - sliders
20. Adding custom inputs - data cards
21. Adding custom inputs - visual inputs
22. Adding custom inputs - using the update property
23. Adding custom inputs - making it work in view mode
24. Adding custom inputs - clean up
25. Refreshing date
26. Deleting records
27. Deleting records the easy way
28. Deleting records the better way 1
29. Deleting records the better way 2
30. Form and modal popup 1
31. Form and modal popup 2
32. Adding filters 1
33. Adding filters 2
34. Advanced filters
35. Counting number of rows in gallery
36. Create a PowerApp with data in seconds
37. Search
1. Introduction
2. Connect SharePoint List to Power Automate
3. Simple alert and notification systems
4. Custom alerts based on column changes 1
5. Custom alerts based on column changes 2
6. Custom alerts based on specific column changes
7. HTTP requests to SharePoint lists 1
8. HTTP requests to SharePoint lists 2
9. HTTP requests to SharePoint lists 3
10. Customize who received alerts
11. Daily digest notifications - ODATA
12. Daily digest notifications - running the flow
13. Daily digest notifications - subtracting date columns
14. Daily digest notifications - finishing up and conversions
15. Data and list manipulation
16. Data and list manipulation with batch update
17. Mixing in approvals
18. Testing approvals
19. Multiresponse approvals and comments
20. Multiresponse approvals and comments testing
21. Using automate to lookup between different tables
22. Using automate to lookup between different tables - test
23. Parse emails to load data to SharePoint List
1. Introduction
2. Run Power Automate workflow from Power Apps
3. Transfer data from Power Apps to Power Automate
4. Transfer condition variables from Power Apps to Power Automate
5. Transfer user variables based on gallery selection
6. Transfer images and files from Power Apps to Power Automate
7. Transfer images and files with file name
8. Transfer signatures workshop
9. Two way communication - strings
10. Two way communication - add two numbers and return sum
11. Two way communication - return two outputs from Power Apps
12. Two way communication - multiple outputs
13. Two way communication - response and respond function
14. Two way communication - transfer data table array records from Power Automate to Power Apps
15. Concurrent functions 1 - set up
16. Concurrent functions 2 - full examples
17. Concurrent functions 3 - with Power Automate
18. Transfer single record information
19. Transfer multiple record information
1. Introduction
2. Using forms as an input UI 1
3. Using forms as an input UI 2
4. Using forms as an input UI 3
5. Use Power Automate to parse emails
6. Use Excel online as a data source 1
7. Use Excel online as a data source 2
8. Sync data with Power Automate
9. Sync data with Power Automate - Add
10. Sync data with Power Automate - Modify
11. Sync data with Power Automate - Delete
12. Power Automate to sync Forms with Trello 1
13. Power Automate to sync Forms with Trello 2
14. API and how to use them
15. REST API example 1
16. REST API example 2
17. REST API example 3
18. Connect REST API to Power Apps
1. Introduction
2. Using a chatbot
3. Setting up the chatbot flow
4. Chatbot and parse JSON
5. Chatbot with the slice function
6. Chatbot and putting it all together
7. Adaptive cards
8. Adding adaptive cards from workflows
9. Creating dynamic adaptive cards
10. Adaptive cards with actions
11. Adaptive cards with inputs
12. Apps on your phone 1
13. Apps on your phone 2
1. Introduction to Dog Walkers United
2. Create the dogs data schema
3. Fill the dog data
4. Create the trips schema
5. Fill the trips schema
6. Add photos
7. Add booking lists
8. Create title page
9. Set up the dogs page
10. Create the dogs gallery
11. Add functionality to dogs gallery
12. Add dog profile page
13. Add dog trips 1
14. Add dog trips 2
15. Add dog trips 3
16. Make visibility of dog trips conditional
17. Create navigation on dog page
18. Create trips page layout
19. Create trips gallery
20. Add photos to trips 1
21. Add photos to trips 2
22. Set up dogwalker filter 1
23. Set up dogwalker filter 2
24. Set up dogwalker filter 3
25. Set up dogwalker filter 4
26. Add trip order
27. Finish trip order logic
28. Add trip information page
29. Add functionality to dog profile
30. Add form functionality
31. Auto increment title
32. Add slider into form
33. Add rating into form
34. Add attachments to form
35. Create form modal functionality
36. Create back button
37. Test form functionality
38. Toggle between photos and attachments
39. Edit modal screen
40. Trip menu navigation and refresh
41. Booking page setup
42. Create future bookings
43. Make future booking clean
44. Your next booking
45. Booking refresh
46. Your next booking logic 1
47. Your next booking logic 2
48. Power automate flows for emails 1
49. Power automate flows for emails 2
50. Google maps launch
51. Create an email invoice flow
1. Congratulations
2. Conclusion and next steps
3. Certificate
1. Bonus

About this course

226 lessons
22 hours of video content

About the Instructor

Henry Habib

Productivity Educator

[email protected]

As a manager at one of the world's top management consulting firms, he advises F500 companies on growth strategy, operation, and analytics. He runs a publication called The Intelligent Worker, which teaches people how to be more productive at work with AI, automation, no-code, and other technologies. As a professor, Henry is passionate about teaching students on how to succeed, on work productivity topics (AI, automation, no-code, etc.). His courses have been purchased by over 200K students.

Testimonials

“Great course covering a lot of material and concepts. Well organized, explanations are clear. Examples for hands on exercises to develop skills are easy to follow and practical. Thank you!”

Lindsay H.

“Henry you made learning easy and interesting at my age, I have not done any IT related studies in my whole life and still i got a glimpse and confidence out of this course. Already using your linktree offers.”

Suresh W.

“Extraordinary! Amazing course for a brief introduction (for those that have very litlle or no knowledge of the platforms), with a teacher very easy-going and clearly focused on what is needed to explain, show, and generate curiosity and the need for more. Brilliant!”

Hector N.

“I liked how the course went through a quick tutorial on each software program and then showed how to connect and utilize them together creating a functional app”

Brendan B.

“I loved the info nuggets, videos just long enough to give you clear explanations/instructions, without losing interest or focus. Very useful stuff for someone who is just starting out with this type of work, will surely be useful even later on when a refresher will be needed :)”

Andreea B.

“Thank you. It was a great course! I have learnt a lot and I will use this knowledge at work. All the materials were clear, and the content was carefully selected. I especially liked the practical examples. It helped me to understand variables and functions concept. This course is an investment in the future.”

Kamil W.

FAQ

What is this course all about?

We will explore the potential of Power Apps, Power Automate, and SharePoint, as we build complete applications and solutions. We will learn how data and information are transferred between these platforms and discover ways to extend their capabilities through third-party and user interface integrations. Our discussions will cover deploying, monitoring, and improving our applications and solutions. Ultimately, we will apply our collective knowledge to build a full, complete application from start to finish.
Who is this course for?

This course is designed for managers and employees who are seeking to enhance their organization's internal processes by building applications and solutions using Power Apps, Power Automate, and SharePoint. It also caters to individuals looking to streamline tasks and automate processes to increase efficiency and optimization within their teams. It is also ideal for those aiming to develop enterprise-grade applications and solutions utilizing the Power Platform and seeking Power Platform certifications (e.g., PL-100). Additionally, this is for Power Platform users who wish to become experts in solution and application building or Dynamics 365 users transitioning to the Power Platform.
What are the requirements of this course?

To make the most of this course, a basic understanding of Microsoft applications such as Word, Excel, and Outlook can be beneficial, although it is not a prerequisite. Similarly, prior knowledge of Office 365 applications like Power Automate, Power Apps, and SharePoint may be helpful but is not mandatory. The most essential requirement is a willingness to learn and a desire to explore the capabilities of these platforms. Additionally, ensure access to a computer with a web browser and a stable internet connection for a smooth learning experience.
Is there a money back guarantee?

Yes! Email us within 7 days of purchase and we will give you your money back, no questions asked.

Join 200,000+ students

Get started now

Start Now

The Intelligent Worker