
Explore the solution formula that links user interface, data, and workflows using Power Apps, SharePoint, and Power Automate. Build, deploy, and monitor full solutions with third-party connectors and APIs.
Explore the solution formula—integrating user interfaces, data storage, and workflows—and see how Airbnb uses apps or websites, data tables, and trigger-action workflows to connect UI, data, and automation.
Explore Power Apps, a no-code UI platform to build sophisticated applications. Connect to thousands of data sources like Excel, Google Sheets, SQL servers, and SharePoint lists, and deploy across devices.
Discover how Power Automate automates routine tasks with no-code workflows driven by triggers and actions, featuring drag-and-drop design, thousands of connectors, and powerful workflow management.
Explore SharePoint as a no-code data solution and internal site for organizing content, lists, permissions, collaboration, and integration with Power Apps and Power Automate.
Navigate the three-part roadmap—basics, building blocks, and end-to-end solutions—for enterprise apps using SharePoint, Power Apps, and Power Automate, including cross-platform interactions, third-party and UI integrations.
Henry introduces his background as a management consultant and business intelligence expert, focusing on using data to gain insights. He highlights dashboards, reports, and tools that simplify and automate workflows.
Reach out to the instructor via Udemy Q&A, direct messages, and link tree, and join the email list for updates on new courses and opportunities.
Practice along with the instructor through guided experiential learning; do, not just watch. Explore broadly, ask questions, and engage the Q&A community to master Power Apps, Power Automate, and SharePoint.
Rate this course to help develop new courses for the Henry family and give you first access, and please share feedback, ask questions, message me, and have fun.
Click the gear icon in the video player and select 1080p to use the highest available resolution and avoid auto or 720p for a distortion-free learning experience.
Explore how SharePoint Online serves as a web-based intranet and one-stop shop for storing files, sharing news, and managing data with lists and metadata, plus automating workflows with Power Automate.
Set up your SharePoint development environment by starting an Office 365 E5 trial, and creating an administrator account to access Power Apps and Power Automate.
Access the admin portal and office.com, sign in to SharePoint, and create a team site (for example Toronto) to organize users, documents, and workflows.
Explore the SharePoint site environment, using the search bar, account, settings, and help to view sites and news, then edit the front page widgets and add documents, lists, and pages.
Create a new document library in SharePoint, name it, and build a folder hierarchy for expenses, accounting, and marketing, uploading files to mimic OneDrive or Google Drive.
Explore document library features, including metadata, versioning, and check-in/check-out, to track who edited files, view version history, and edit concurrently in the browser.
Explore how metadata in a SharePoint document library replaces folder hierarchies, enabling efficient search, filtering by department and category, and easy export for Power Apps and Power Automate workflows.
Create a SharePoint page from a blank canvas, add a title, image, text, and web parts, then publish a call-to-action linking to the expenses page and update navigation.
Learn to add web parts for document libraries and file viewers on SharePoint pages, create department-based views, and keep pages updated as underlying documents change.
Create a brand new SharePoint list, add columns such as first name, last name, and age, and use a customer type dropdown to classify records.
Learn how to add rows to a SharePoint list from an Excel file by copying the title, first name, last name, and age columns into edit grid view, then save.
Learn how to import rows from an Excel table into a SharePoint list by formatting the table as an Excel table, uploading the file, and mapping columns to SharePoint types.
Explore how a SharePoint list creates public shareable customer profiles with version history, comments, and easy shareable links for cloud access and team collaboration.
Learn how a SharePoint list unlocks advanced columns like choice dropdowns, person fields, and calculated values. See how lookups, location mapping, hyperlinks, and workflows support salesperson notifications for new customers.
Explore form and column validation in SharePoint lists, enforcing rules such as age over 18 to ensure clean data, and compare old settings with PowerApps for robust validation.
Explore how to format SharePoint lists to report data in multiple views, apply conditional formatting and color coding, and use grouping, sorting, and gallery or compact list layouts.
Learn to create SharePoint list alerts that email you when changes occur, choose change types and daily or weekly summaries, and integrate alerts with Power Automate for broader workflows.
Discover how Power Automate automates tasks—from simple alerts to complex workflows with conditions and approvals—using connectors to SharePoint, Outlook, Teams, and desktop flows for non-connector apps.
Explore Power Automate features, including no-code design, thousands of connectors, and scalable workflows with conditions, loops, and approvals, plus desktop flows and rest APIs integration.
Set up your power automate environment with an organizational account and the correct test environment. Explore flow types and templates, focusing on creating from scratch rather than using templates.
Explore what a flow is in Power Automate, identifying triggers and actions, with examples like tweet triggers email, button triggers Slack, and recurring time-based flows.
We cover automated cloud flows, instant cloud flows, and schedule cloud flows, plus desktop flows for apps without connectors, noting business process flows are rarely used.
Create your first flow in Power Automate by triggering an instant flow with a button, connect to Microsoft Teams, and post a flow bot message to a chat or channel.
Save flows before testing, use Flow Checker for errors, and review history for inputs and outputs. Test manually or automatically, inspect iterations, and debug flows across Teams and SharePoint connectors.
Learn to add inputs to a Power Automate flow and use dynamic content produced by triggers and actions to personalize messages in Teams and SharePoint.
Explore expressions in Power Automate, turning inputs into outputs with dynamic content and string functions. Combine messages and apply two upper for text transformations using trigger body content.
Explore how to implement conditional logic in Power Automate using the condition control, with a yes/no input, branching flows, and posting different messages to Teams based on the outcome.
Test a flow condition by evaluating a boolean true/false; when true, the yes path runs, otherwise the no path. The lesson reinforces building blocks for adding conditions inside workflows.
Create an automated cloud flow triggered by new items in the SharePoint list customers from file, then post a Teams message alerting the team.
Set up an automated cloud flow that triggers when a SharePoint list item is created, sending a Teams message with dynamic content like first name, last name, and customer ID.
Explore how to build an approvals flow with Power Apps, Power Automate & SharePoint that uses human intervention to approve or deny a new customer item, updating the list accordingly.
Shows triggering a flow on item creation in a SharePoint list and prompting approvals in the Teams app, with first-time provisioning delaying the approval before subsequent fast runs.
Trigger a Power Automate flow from a new SharePoint list item, route approvals via email and Teams, and update the workflow as customers are approved or denied.
Explore parallel branches in Power Automate to run two workflows simultaneously after a trigger—teams messages and approvals—boosting speed and resilience when one path errors.
Use the clipboard in Power Automate to copy and paste actions across steps and flows. Save actions with copy to clipboard, including properties, and rearrange or move items between flows.
Explore Power Apps as a no-code development platform within the Microsoft ecosystem, with hundreds of connectors to SharePoint lists and data sources, running everywhere to build fully customized business apps.
Sign into office.com, access the power ups environment, and set up a simple canvas app connected to data, preparing to mix Power Apps, Power Automate, and SharePoint.
Create a canvas app in Power Apps studio, choose tablet layout, and learn how controls, properties, and the formula bar shape a responsive interface for web deployment.
Bind a label’s text to a text input to reflect user input in real time, and use dot notation to access properties like color for dynamic updates in Power Apps.
Explore how actions differ from properties, and learn to use navigation actions with on select and on change to move between screens in Power Apps, including using the navigate function.
Master variables in Power Apps by using the set function to store text input in a variable and display it in a label after pressing a button.
Explore Power Apps functions and formulas via the formula reference to learn string, logic, math, navigation, and set, and apply upper, lower, and proper to text input.
Use if statements in Power Apps to create conditional logic with a dropdown of upper, lower, and proper, replacing multiple buttons with a single submit action.
Connect Power Apps to data with an Excel file as the underlying database on OneDrive. Upload the file, make it a table, and map fields like customer name and agent.
Create a canvas app in Power Apps and connect to Excel Online for business via OneDrive for business using connectors, enabling live data updates and tables, galleries, and forms.
Learn to configure the Power Apps data table: connect a data source, pick fields such as first name and date joined, and compare it with galleries for selection.
Create a vertical gallery as a repeating group, bind it to a data source, and customize fields like first name, location, and VIP level to display and navigate customers.
Learn to build a dynamic Power Apps gallery by concatenating first and last names, adjusting wrap counts, and using the gallery's selected item to drive profile editing via forms.
Create a Power Apps interface with a gallery to select records and a display form bound to a data source, then navigate between screens to view each customer's profile.
Convert a display form to an editable Power Apps form, connect to table one, and enable edits for first name, last name, location, VIP level, and agent name.
Use the edit form function to switch a view form to edit mode, update fields, and submit to update the underlying database, then reset back to view mode.
Learn to filter a gallery by location and implement a search field in Power Apps, using the filter and search functions on table one with a text input and dropdown.
Save your Power Apps project to the cloud, manage versions, and revert changes as you deploy and share the app with your organization via links, Teams, or SharePoint.
Master cross-platform interactions among the Power Apps UI, SharePoint data, and Power Automate workflows to enable data transfer, front-end filtering, searching, and adding, deleting, and modifying records with form validations.
Add a new user in the admin portal, assign licenses, and create a SharePoint list from an Excel file to power your Power Apps with expenses data.
Learn to display a SharePoint expense list in a Power Apps vertical gallery with titles, dates, and descriptions, apply conditional formatting for status, and manage expenses with custom forms.
Learn to apply conditional formatting in Power Apps galleries by using if statements to color status values (submitted, approved, paid) and control status icons with visibility rules.
Add a view in Power Apps by condensing a gallery and using a right-hand detail form in view mode, with conditional formatting for status and descriptions.
Switch expense report forms from view to edit mode in Power Apps by adding an edit button that calls the edit form function on form one.
Learn to switch a form to edit mode, manage a form status variable, and submit and reset the form to return to view mode, updating the underlying SharePoint data.
Consult the reference guide to explore form functions—add form, new form, submit form, reset form, and view form—and learn how form modes switch and submitting saves to the SharePoint list.
Lock specific fields in SharePoint forms by forcing data cards to view mode, preventing edits like receipt date and status, and apply dynamic rules based on date or amount.
Learn to add new records in Power Apps using a single screen with a new form, set status, submit to create records, and implement basic validation.
Explore how to create locked values for a new form in Power Apps, using a lookup to set status to submitted while keeping status read-only in view and edit modes.
Add an X cancel icon that appears in edit or new mode and hides the plus button in view mode. On click, reset form and set the status to view.
Fix the receipt date for new records by setting a conditional default. Use today() and display mode rules to allow edits only in new form mode.
Create custom form validations in Power Apps to prevent blank fields by using on change logic to set a form error and display an error message.
Implement form validation by trimming whitespace and enforcing a minimum length of ten characters; handle multiple errors and update the error message and checkmark accordingly.
Enforce title form validation by using visibility rules and an and-condition to hide the checkmark until no errors exist, preventing invalid submissions in Power Apps and SharePoint.
Propagate the title field validation, including required and greater-than-ten-characters, to remaining fields by validating the receipt date against today with a date diff function, and update form errors and checkmarks.
learn to add new input types in Power Apps and update the SharePoint schema by creating a yes/no urgent column and exposing a toggle in forms.
Learn to add a slider as a custom input for urgency levels in Power Apps forms, set 1–5 min/max, and compare with text and rating inputs in SharePoint.
Learn to create custom inputs in Power Apps by configuring data cards and their update properties, enabling fields like a 1–5 urgency level linked to the underlying database.
Build a visual input UI in Power Apps by turning a text field into five urgency buttons, wiring a variable, and using conditional fill to show the selection.
Learn to merge custom inputs with data cards in Power Apps by using the update property to set the urgency level from a variable, ensuring correct submission to SharePoint.
Learn to make custom inputs work in view mode by updating a gallery's selected urgency level into a variable, and ensure data cards refresh to reflect correct SharePoint data.
Clean up customer input by editing in the formula bar, zeroing out error message height, and verifying edits in both view and edit modes, with real-time updates after submission.
Discover how to refresh a SharePoint data source in Power Apps using the refresh function, a refresh icon, and screen visibility to keep users seeing the latest updates.
Learn easy and hard methods to delete records in Power Apps with SharePoint, using trash deletion and soft delete with a delete flag and confirm popup.
Delete records the easy way by adding a trash can icon that uses Power Apps remove to delete the selected gallery item from the expense submissions data source.
Implement a delete field workflow in Power Apps and SharePoint by adding a delete field and a trash icon to set it to delete, then submit and refresh the data.
Learn to filter records with the is blank function, distinguishing blank from empty string. Implement an edit-then-delete workflow to keep a trace.
Create a Power Apps popup for SharePoint forms that validates actions with a delete confirmation dialog showing name, amount, and category, using a semi-transparent overlay.
Set up a form pop up controlled by a boolean variable, triggered by a trash icon and back button, and enforce status rules to prevent deleting approved or paid items.
Learn to implement user filtering in Power Apps by adding a dropdown to filter records by status, and understand the challenge of a SharePoint choice column.
Use the choices function to populate a dropdown from the expense submissions status lookup, returning values like submitted, approved, and paid, then filter the gallery by status.value equals the dropdown.
Learn to implement advanced filters in Power Apps by adding a status toggle and a dropdown to filter the gallery to non-deleted records when enabled, showing approved, paid, or submitted.
Learn to build dynamic gallery filters in Power Apps by adding a status checkbox, locking controls, and using conditional formulas to show all records or only non-deleted items.
Create a Power Apps canvas from a SharePoint list in seconds, building a standardized three-screen app. View, search, filter, add, modify, and delete records quickly with a customizable user interface.
Add a search filter in Power Apps by using a text input and dropdown to search expense reports by title, applying the built-in search function to a gallery.
Explore cross-platform interactions between SharePoint lists and Power Automate to trigger workflows from data changes, transfer first name, last name, and email, and enable alerts, approvals, and document library automation.
Create a SharePoint list with email as the title and basic fields, then build a Power Automate flow to post a Teams notification when a new item is added.
Create a Power Automate flow that triggers on SharePoint item creation or modification and posts alerts to Teams, using dynamic data like title, first name, and last name.
Learn to create custom alerts in Power Automate for SharePoint that trigger only when specific columns change, using version history, get changes for an item, and conditional actions.
Learn how to build custom alerts in Power Apps, Power Automate, and SharePoint that trigger on column changes, test flows, and notify teams when office or brand fields update.
Create custom alerts and notifications that trigger when a specific column changes to a target value, such as office name changing to New York City, using Power Automate and SharePoint.
Learn to use Power Automate to make HTTP requests to SharePoint lists with the REST API, retrieving item data and previous versions via the SharePoint egress API.
Build a http request to a SharePoint list item to fetch its previous version using the SharePoint connector in Power Automate, using version ID rather than the label.
Learn how to use http requests to SharePoint lists in Power Automate, convert responses with parse JSON, and extract fields like office location from the body to trigger workflows.
Learn to customize alert recipients by adding sales contacts in SharePoint, then use Power Automate flows to post updates to the corresponding Teams chat.
Create time-based alerts with a daily digest using a scheduled cloud flow, retrieving filtered SharePoint items and sending a Teams message with the list of new customers.
Run a power automate flow to filter SharePoint data where field four equals New York City, test flow, and deliver daily digest notifications of customers updated within the last hour.
Calculate the age of records in SharePoint by subtracting the modified date from today and show chart messages for items modified within one day, using calculated columns.
Create a daily digest by converting SharePoint's 'how old is this record' from string to float, compare to 0.0416 for one hour, and post updates to Teams or other connectors.
Learn to manipulate data and lists with SharePoint and Power Automate, including automatic updates to a status column and sales notifications via Teams.
Create a batch update flow from Power Automate to SharePoint using an instant flow with manual trigger to fetch items, update values, apply to each item, and notify via Teams.
connect power automate with sharepoint to create an expense submission approval workflow; trigger on item creation, route by category (technology to Bob, travel to Sarah), and update the status.
Test a Power Apps workflow end-to-end by submitting an expense report, then approve or reject in Teams with Power Automate, view it in SharePoint, and track outcomes.
Extend the expense approval workflow by adding a multi-option approval using custom responses and saving approver comments to SharePoint, updating the item with the chosen expense type and comments.
Test and demonstrate multiresponse approvals and comments testing using Power Automate and SharePoint, capturing approver comments and creating custom approval experiences for expense reports.
Link two lists with a SharePoint lookup to relate categories to managers. Create a Power Automate flow that retrieves the category manager by title and routes approvals to that email.
Demonstrate how to use Power Automate to lookup between different tables and route approval requests in a SharePoint list, using an event marketing example to show dynamic internal approvals.
Automate ticket creation by parsing incoming emails with Power Automate, converting HTML to text, and creating SharePoint list items in the Tickets list with attachments.
Learn to build cross-platform interactions between Power Apps and Power Automate, transferring simple and complex data, enabling two-way communication, concurrent workflows, and integration with SharePoint and Teams.
Connect Power Apps to Power Automate by triggering an instant cloud flow from a canvas app button, and post a Teams message with the auto message workflow.
Learn to transfer data from Power Apps to Power Automate by passing a user-entered message as a variable, triggering a Power Automate flow to post in Teams.
Transfer condition variables from Power Apps to Power Automate by wiring a toggle to a boolean value that controls message formatting.
Learn to transfer user profiles and gallery-selected items into a Power Automate workflow from Power Apps, enabling dynamic recipients and message content using SharePoint lists and user profile data.
Transfer images and files from Power Apps to Power Automate by handling binary data, converting to json, and saving to a SharePoint document library via a flow.
Build a dynamic image uploader that transfers Power Apps images to SharePoint via Power Automate, using the add media button file name and a text input for the file name.
Learn how to transfer images and signatures from Power Apps to SharePoint using a Power Automate flow, including uploading receipts and signatures to a document library and handling image data.
Create two-way communication between Power Apps and Power Automate by sending text, processing it in a flow, and returning a string to display in the app.
Build a two-way communication workflow between Power Apps and Power Automate to add two numbers and return the sum. Configure inputs and outputs to ensure a numeric result.
Explore two-way communication in Power Apps by returning two outputs (sum and difference) from a flow, wiring them to variables, and handling type conversion and debugging.
Learn to return an object from a Power Apps flow to access multiple outputs, avoiding double runs by setting a single return object and referencing sum and difference.
Learn the two-way response workflow in Power Automate and Power Apps, including building a JSON payload, generating a schema from a sample, and returning complex data.
Demonstrates two-way communication by transferring table records from Power Automate to Power Apps via the response connector, building a JSON array from SharePoint data and displaying it in a table.
Explore concurrent functions in power apps to run processes in parallel, reducing translation time. See how a translator function and a refreshed data source demonstrate multi-language translation.
Copy and paste to create a concurrent workflow, replacing semicolons with commas so functions run together. Non-dependent steps run in parallel, yielding up to five times faster results.
Explore the concurrent function in Power Automate to run multiple flows in parallel, reducing total time when flows have no dependencies, illustrated with 5/2 and 1/2 flows.
Transfer a single selected record from Power Apps to Power Automate by passing the record ID, then update the corresponding SharePoint item or trigger email actions.
Filter a customer list in Power Apps, collect matching IDs as JSON, and pass it to Power Automate to update office field on multiple SharePoint records.
Explore third party interactions that extend Power Apps, Power Automate, and SharePoint by connecting to data sources like Excel, Google Sheets, and SQL using REST APIs.
Learn how to build a public input form using Microsoft Forms to feed a SharePoint list, and automate the transfer with Power Automate for seamless data capture.
Learn to connect a Microsoft form to SharePoint via Power Automate, retrieving response details and dynamic answers to populate fields and optionally send email or Teams notifications.
Learn how to populate a SharePoint date field from forms via Power Automate, selecting the DOB field and using pass date time and other formatting expressions for nonstandard inputs.
Create an automated cloud flow in Power Automate that triggers on ticket emails, parses the body into title, complaint, and urgency, and creates a SharePoint ticket with attachments.
discover how to use excel online as a data source for power apps and power automate by uploading to OneDrive, converting to a table, and building a quick app.
Use Power Apps to connect to Excel Online as your data source, add, edit, delete records, and refresh, and swap to other sources like Google Sheets or Salesforce.
Sync data between SharePoint and Excel with Power Automate to keep both sources in sync, using a flow that automates updates between SharePoint lists and Excel tables.
Create automated cloud flows with Power Automate to sync SharePoint items to Excel online by adding a row to an Excel table when a vendor is created in SharePoint.
Set up an automated cloud flow to update an Excel row when a SharePoint item is modified. Use the title as the key and test the flow manually.
Set up a Power Automate cloud flow to delete rows in Excel Online when a SharePoint item is deleted, syncing data between SharePoint and Excel and testing with Verizon.
Power Automate links forms to Trello, automatically creating bug cards with descriptions and priority. Configure a form and an automated flow that transfers responses to Trello tasks.
Power Automate connects form submissions to Trello by using a switch control to map priority to label IDs (red, yellow, green) and create bug cards for streamlined tracking.
Learn how to connect RESTful and non RESTful APIs to Power Automate, Power Apps, and SharePoint using API calls, including listing users and posting data.
Explore how to use power automate connectors first, then http requests and rest APIs, with an ftp workflow example and notes on desktop flows as alternatives.
Build a Power Automate flow that calls a REST API with http get, parses the JSON list of customers, and posts each customer's name and email to a Teams chat.
See a REST API workflow in action as a flow sends an HTTP request, uses JSON, and posts customer data from SharePoint to Teams via API requests.
Connect rest api to Power Apps by building a Power Automate instant flow that pings the api, passes JSON, and returns data to Power Apps for display in data table.
Explore how to integrate your app into Teams and mobile devices, building chat bots with adaptive cards, and deploying Power Apps, Power Automate, and SharePoint solutions for seamless user experiences.
Build a no-code chatbot in Microsoft Teams with Power Automate to pull SharePoint and Power Apps data via slash get, delivering customer details such as name, office, and brand.
Create an automated cloud flow in Power Automate that triggers on new Teams chat messages, uses a forward slash gets command, and fetches message details from the body.
Master passing and parsing JSON in power automate by generating a schema from a sample, initializing a variable, and extracting the plain text content to drive a flow.
Build a Power Automate flow that triggers on /get messages, strips the name, uses slice to extract it, and searches a list to return the office and brand.
Build a chatbot by wiring Power Apps, Power Automate, and SharePoint to fetch items, filter by field underscore zero, and post results in a Teams chat.
Discover how adaptive cards, as embedded UI modules in teams, let users read data, input details like tasks, notes, and due dates, and drive workflows in Power Automate and SharePoint.
Turn chat bot results into an adaptive card via a workflow, posting the card in a Teams group chat using the same conversation ID and adaptive card JSON.
Create dynamic adaptive cards in Microsoft Teams using a guided UI to generate JSON, test triggers, and display customer details like name, office, and brand.
Extend adaptive cards by editing JSON to add text blocks and open URL actions that navigate to SharePoint records. Use schema explorer and link to item to populate URLs.
Create adaptive cards with inputs to trigger a cloud workflow from a selected message in Teams, capture due date and description, and auto-create Planner tasks via Power Automate.
Create a mobile power apps demo by starting a blank canvas app for phone, add a label and counter button that increments, and a reset, then run on your phone.
Download the power apps mobile app, sign in with the same credentials used to create apps, and access all apps from the all apps list on iOS or Android. Open phone demos, try landscape mode, and interact with touch features like pinch and swipe.
Explore a Dog Walkers United end-to-end app built on SharePoint lists for iPad, with bookings, trips, dog profiles, owner emails, Google Maps directions, and invoicing workflows.
Create and populate a dogs data schema in SharePoint by building a dogs list with fields for name, owner, email, location, breed, gender, and notes.
Import dog data into a SharePoint list by replacing address with a single line text field and pasting from the Dogs Excel file (50 dogs), then set up TRIPS schema.
Create and configure the trips schema in SharePoint by adding fields for trip title, dog reference, walker, trip length, behavior rating, photos, and notes to track dog walks.
Add 3 to 5 quick trip records by entering titles, dog names, walk durations in minutes, and behavior ratings, then save. Add images later if needed.
Create an image column named photo to store dog photos and add a date column for trip dates in Power Apps, then populate with sample dates or leave photos blank.
Create a bookings list to track dog appointments, linking dogs and dates. Enable customers to submit bookings via a form and build a dog-walker app in Power Apps.
Create a title page for a dog walker app in a canvas app, with a banner, company name, and buttons for bookings, trips, and dogs connected to a SharePoint list.
Create a view docs page for dog walkers to view dog profiles and trips. Assemble a three-panel layout with a dog list, dog profiles, and trips, and add a gallery.
Create a dynamic gallery in Power Apps, connect to SharePoint dog data, display each dog's photo, name, and breed, and plan a search to filter results.
Add a search feature to the dogs gallery using a text input and search function, filtering by title and dog attributes like breed and gender.
Build a dog profile page by binding image and details to gallery1.selected, replacing the form with custom labels and images, and adding owner contact buttons.
Configure a right-hand side gallery bound to the SharePoint trips list, show the walk date as title, and the walker display name as subtitle, with length, behavior, and photo.
Add dog trips 2 demonstrates configuring a rating input in the gallery, setting defaults, locking editing, and displaying each walker rating out of five.
Learn to filter trips by the selected dog in Power Apps using the filter function on the trips data to show only that dog's trips and handle no trips found.
Make the trips gallery conditional by binding its visibility to count rows of the trips table, and show a no trips found icon and label when there are zero items.
Add home and back navigation buttons with white icons, using on select to navigate home or return to the previous screen; connect view dog to the dog page.
Learn to design a trips page that lists all trips in a left-hand gallery, lets you view and edit trip details, and add new trips with a plus icon.
Create a vertical trips gallery with a wrap count of three, bound to the trips data source, showing photo, date, dog name, and walker, with a star rating and filters.
Learn to display dog walker photos in a Power Apps and SharePoint trip list by inserting media and binding the image to item fields, while addressing free-trial limitations.
Add and dynamically display photos in Power Apps by assigning media to gallery items, using if statements to show images based on walker display name as circular profile pictures.
Set up a top dogwalker filter in a Power Apps, Power Automate and SharePoint course to filter trips by person and arrange four profile images horizontally with a clear button.
Store the user's dog walker selection in a variable, set it on each image's on select, and update a label to reflect the current filter.
Enhance a Power Apps filter by enabling multi-select borders, custom hover color, and conditional border colors for selections, then add a clear button to reset and update the list.
Showcases a dog walker filter in a gallery by using an if condition to filter trips where the walker display name equals the selected D.W., with clear and sort options.
Add a top dropdown to sort trips by date, rating, or length, with a clear label and styling, preparing for the sorting logic in the next video.
Finish trip order logic by implementing a sort-by-columns function to sort trips by date, length, and behavior via dropdowns, with ascending order and handling spaces in column names.
Add a trip information page that displays trip and dog photos, walker details, date, minutes, and notes, with dynamic titles and a dog profile link and an email invoice button.
Use context variables to display the correct dog profile in Power Apps by setting a dog record from the gallery and binding photo, title, and details.
Create a pop-up form in Power Apps connected to trips data source to add and edit records, set mode to new, customize fields, and implement a submit action in modal.
Auto increment the title by defaulting to the maximum title plus one, achieved by sorting titles in descending order, taking the first record, and adding one.
Add a slider to a Power Apps form data card, unlock the text box, set min 15, max 180, default 30 minutes, show the value, and bind updates to slider.value.
Add a rating to the form by inserting a rating control, default three, max five, and link its value to the data card update; adjust notes, date, and behavior fields.
Enable attachments on a SharePoint form in Power Apps, using the photo column when available and falling back to attachments otherwise, with a guided attach workflow.
Create a modal form in Power Apps by grouping the form and button, toggling visibility with a show model variable, and handling submit, reset, and refreshing trips data source.
Add a back button to close the modal, submit a new record with date, length, and attachment, and verify the entry appears in SharePoint.
Test form functionality by creating auto-incremented records, assigning dates and durations, and attaching images, then learn to display attachments on records or fall back to the photo image when absent.
Toggle between photos and attachments in a gallery using a has attachments boolean and conditional logic in Power Apps, Power Automate, and SharePoint.
Click the edit icon to open a modal and edit a trip; switch the form to edit mode, bind the selected item, and refresh trips to update the model.
Deliver a functional trip management screen with home and back navigation, a refresh trips button, and synchronized trips and dogs data via Power Apps and Power Automate.
Create a dog walker bookings page by adding records to the SharePoint bookings list and displaying next booking and future bookings on a single screen.
Create a table-style bookings view in a Power Apps canvas app by configuring a gallery with walker, dog, owner, date and time fields, photos, and SharePoint bookings data.
Clean up future bookings by copying and pasting a rectangle, repositioning and resizing the gallery, and bringing elements to front to reveal all bookings.
Create a next booking view by setting a selected booking variable with a button, then display dog details and trip owner information across screens.
Refresh the SharePoint bookings data by using the refresh icon across screens to update future bookings and ensure newly added records appear in the app.
Simulate the logged-in user, filter bookings by the walker display name, sort by date ascending, and select the first record after today for the next booking.
Add date-based filters to show only future bookings, customize the gallery to display the current user's bookings, and connect these updates to Power Automate flows.
Power automate flows for emails use a button to launch mailto or modal email form, with to, subject, and message fields and defaults such as dog record email and Blondie.
Create an instant cloud flow triggered by Power Apps to simulate email delivery via Teams. Collect a subject and message, save, test, and integrate the flow into the app.
Use a launch function in the app to open Google Maps or a URL with a route address, enabling directions and map view on phones or in a browser.
Create an instant Power Automate flow that generates a Trello to-do card with invoice details and emails the invoice, integrating Power Apps, Trello, and SharePoint for automated billing.
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, REST APIs
User Interface Interactions - chatbots, adaptive cards, apps on your phone
Monitor, Deploy, and Process Improvement - deploy solutions, monitor logs, see errors
Solution Build - Dog Walkers United - build a complete enterprise application for an Uber for Dog Walkers
Conclusion - earn your online certification, and read about next steps
If 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