Build Solutions with Power Apps, Power Automate & SharePoint

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.

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.

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 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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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 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.

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.

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.

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.

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.

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.

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.

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 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.

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 chatbot by wiring Power Apps, Power Automate, and SharePoint to fetch items, filter by field underscore zero, and post results in a Teams chat.

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.

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 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.

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.

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.

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.

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.

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.

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.

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.

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.

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.