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

About this course

233 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