Build Solutions with Power Apps, Power Automate & SharePoint

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.

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.

Explore how a SharePoint list creates public shareable customer profiles with version history, comments, and easy shareable links for cloud access and team collaboration.

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 add inputs to a Power Automate flow and use dynamic content produced by triggers and actions to personalize messages in Teams and SharePoint.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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

Learn to filter records with the is blank function, distinguishing blank from empty string. Implement an edit-then-delete workflow to keep a trace.

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.

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

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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 back button to close the modal, submit a new record with date, length, and attachment, and verify the entry appears in SharePoint.

Toggle between photos and attachments in a gallery using a has attachments boolean and conditional logic in Power Apps, Power Automate, and SharePoint.

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.