Microsoft Power Apps and Power Automate: Build Business Apps

In this lesson, we discuss the essential resources needed to start building apps with PowerApps.

Topics covered include:

• Required resources: Computer with a browser and internet access

• Necessity of a corporate or school email account with an office license

• Options for obtaining an account: Using an existing corporate account or creating a Microsoft trial account/subscribe to a plan

• Accessing the PowerApps interface via make.powerapps.com or through Office apps

• Importance of having access to PowerApps for this course

In this lesson, we explore the Power Apps interface and its basic functionalities.

Topics covered include:

• Overview of the constantly changing home interface

• Explanation of the new Power Apps experience toggle

• Introduction to the 'plans' tool for app construction guidance

• Basics of creating a Power App: blank app, data source-based app

• Different types of Power Apps: Canvas app, Model-driven app, Power Pages sites

• Exploring the 'create tab' and various starting points for app creation

• Utilizing the 'learn tab' for accessing Microsoft documentation and modules

• Overview of app planning and creation process within the 'plans' section

• Viewing and managing apps: personal, shared, and company-wide

• Introduction to AI and template options for app creation

• Sample apps and their functionality

• Additional platform features: AI hubs, tables, flows, solutions, connectors

• Concept of environments in Power Apps for productivity and mission-critical apps

In this lesson, Rudy walks us through the process of creating a blank canvas app within the development environment. He navigates to the create tab, selects 'Blank App,' and names it 'App 0001.'

Rudy explains the importance of choosing between tablet and phone formats based on the app's end-use, noting that while the format can be changed later, it's more complex to adapt afterwards.

He selects the tablet format for more space to demonstrate controls. Rudy then shows the app interface, highlighting the canvas in the middle where various controls will be inserted. He concludes by previewing the next lesson, which will explore the interface and its components in detail.

In this lesson, we explore the interface of Power Apps, focusing on the top bar and its functionalities.

Topics covered include:

• Identifying the two parts of the top bar: the modern comment bar and actions menu

• How the top bar changes based on the selected element

• Inserting and modifying controls, such as buttons and text

• Changing properties like font weight, background color, and background images

• Using shortcuts for undo, redo, copy, cut, and paste

• Connecting to data and creating new screens

• Enabling and using the properties pane

• Saving and auto-saving the app

• Using the app checker to find and resolve problems

• Sharing and publishing the app

• Simulating the app on different devices and orientations

• Using the settings panel to configure auto-save

Next, we will dive into the control properties and the properties pane in detail.

In this lesson, we explore the properties of controls within Power Apps.

Topics covered include:

• Inserting various controls from the insert dropdown (text labels, forms, buttons, calendar pickers, etc.)

• Adding and positioning a button control on the Canva

• Toggling and understanding properties pane for the button

• Customizing the button's properties (text, display mode, visibility, position, size, padding, color, border radius)

• Differences between classic and modern controls in Power Apps

• Inserting and customizing an image control (selecting images, positioning, transparency)

• Advanced properties, action properties, data properties, and style properties

• Using the top left dropdown and formula bar to edit properties.

In this lesson, we explore the differences between classic and modern controls within Power Apps and demonstrate how to enable and use them.

Topics covered include:

• Inserting classic and modern controls from the insert dropdown.

• Enabling modern themes and controls via settings.

• Differences in properties and customization options for classic and modern controls.

• Accessing and editing properties such as text, icon, layout, and color palettes.

• Accessing data from text inputs using classic and modern controls.

• Switching between classic and modern controls for various uses.

• Changing the app's color scheme using themes.

In this lesson, we explore the app authoring menu in Power Apps.

Topics covered include:

• Importance of saving your app and enabling auto-save

• Overview of the tree view to see all controls inside the app

• Adding new screens and using templates with headers and galleries

• Introduction to the insert menu for inserting controls

• Understanding the data tab and connecting to various data sources

• Variables and collections for storing data

• Using the search tab to find and rename elements within the app

• Changing themes and adding custom themes

• Managing and uploading media files, including images and videos

• Introduction to Power Automate for automating tasks

• Overview of advanced tools like live monitor and automated testing

In the next lesson, we will cover saving and sharing your app with others.

In this lesson, we explore the process of saving, publishing, and sharing apps in PowerApps.

Topics covered include:

• Saving the app and enabling Auto Save for automatic backups every two minutes

• Previewing versus playing the app from make.powerapps.com

• Publishing the app to make changes available to users

• Editing the app and saving changes without publishing

• Adding version notes and restoring previous versions of the app

• Handling common errors, such as restoring while the app is in edit mode

• Publishing restored versions to make them live

In this lesson, we explore how to share the app you've built with other users in Power Apps.

Topics covered include:

• Accessing the share feature from the app interface and app edit interface

• Sharing the app with individual users and configuring access levels

• Using the classic sharing interface vs. the new sharing interface

• Sending email notifications and adding custom messages and images

• Understanding user permissions (player vs. co-owner)

• Removing user access

• Sharing the app with groups, including Azure Entra ID security groups

• Managing app access and permissions

• Preparing to build and share your own app.

This class provides a practical introduction to Power Fx, showing how to use simple formulas to build app behavior in a clear and efficient way. In just a few minutes, you learn core concepts such as summing values, displaying notifications, and navigating between screens, with a focus on the logic behind the most common expressions used in everyday scenarios. The lesson is straightforward and accessible, ideal for getting started without complexity.

This lesson builds on the basics of Power Fx and user interface navigation covered previously. The focus is on understanding how to read inputs from various controls in a Canvas app. The script explains how to read values from text input controls, rename controls for clarity, and use these values in formulas. Key properties, such as updating triggers, are discussed to reflect changes in the app. The lesson emphasizes practical application by demonstrating how to display input values in real time and outlines steps for configuring the controls' properties.

The lesson discusses different types of input controls used in app development, starting with number inputs. The instructor demonstrates how to collect and validate numerical inputs, explaining the properties and configurations such as minimum, maximum, and step values. The script also covers how to read the input and use it in other components, like dynamically resizing an avatar image. Next, the instructor introduces checkboxes as a way to capture binary responses (yes/no or true/false). An example shows how to conditionally enable a submit button based on the checkbox's state, inviting the viewer to apply their knowledge before revealing the solution in the following lesson.

This lesson expands on the previous one by introducing more useful controls in Power Apps: the toggle control and the radio button control. It begins with inserting a toggle button below an existing checkbox and adjusting its properties to ask a yes/no question. It explains how to read the toggle's value and use it to show or hide other elements in the app, similarly to a checkbox. The lesson then moves on to the radio button control, demonstrating how to set its items property to provide a list of special assistances that the user can select. The lesson provides detailed instructions on how to read the selected value of a radio button and explains the importance of understanding arrays and tables in Power Apps. It concludes by stating that the next lesson will cover dropdown controls.

This lesson covers the dropdown control in Power Apps, specifically focusing on the combo box as a more feature-rich alternative. You'll learn how dropdown controls use a table structure with an items property, how to populate them with data like department names, and the difference between the Selected and SelectedItems properties for reading values. The lesson demonstrates practical implementation by creating a department selector and explains why combo boxes are preferred over standard dropdowns for production applications.

In this lesson, you’ll learn how Power Apps dropdowns and combo boxes really work when they’re connected to tables. We’ll break down how the Items property defines the data structure, why Selected returns an entire record instead of a single value, and how to correctly access columns like IDs or codes. You’ll also see how the Fields property controls what users actually see, how to reset dropdowns using the Reset function, and how to configure DefaultSelectedItems so controls return to a predefined value. These patterns apply not only to static tables, but also to SharePoint, Excel, Dataverse, and other data sources—making this a foundational skill for building reliable Power Apps.

This lesson explains how to use the Date Picker control in Power Apps, including how to read the selected date, format it correctly, set default values like today’s date, restrict selectable date ranges, and reset the control. It also introduces key date functions such as Text, DateAdd, and DateDiff to format dates, add or subtract time, and calculate differences between dates, helping you handle common real-world scenarios like validations, filters, and follow-up dates in your apps.

This lesson focuses on user contexts in Power Apps, specifically how to personalize user experiences by retrieving user information such as email, full name, profile image, and unique ID (Microsoft Entra ID). The video demonstrates how to use the 'User' function to display this information within an app, stresses the importance of the unique identifier for accurately managing user data, and provides practical steps for incorporating these details into the app interface. Finally, it highlights the benefits of such functionalities for user identification and management.

In this lesson, the focus is on understanding states in Power Apps, specifically how the app remembers values through variables. The script explains the difference between global and context (local) variables, and how to use each. Global variables can be accessed across all screens in an app, while context variables are limited to the screen they are created on. The lesson features practical examples of setting and using these variables in Power Apps, including a demonstration of how to handle user input and manage the display of pop-ups through variable states.

This lesson teaches how to use collections in Power Apps to temporarily store multiple records (tables with rows and columns) in memory before submitting to a data source. The instructor demonstrates building a simple to-do list application where users can add tasks with text and completion status to a collection using the collect() function. Key concepts covered include: creating collections with named columns using curly braces, viewing collection data in the variables panel, displaying collections using tables, clearing inputs after adding data with the reset() function, removing all collection data with clear(), and using clear collect() to replace collection contents. The lesson emphasizes that collections can be manipulated like data sources (SharePoint lists, databases) and previews the gallery control for more flexible data display in the next lesson.

In this lesson, the instructor introduces the importance of galleries in Power Apps and demonstrates how to create and customize a gallery to display data from a collection. Unlike tables which have fixed visuals and are often in preview mode, galleries offer flexibility for custom visuals and are stable for use in real-life applications. The instructor guides through inserting a vertical gallery, connecting it to a local data collection, and customizing it with various controls like images, texts, and buttons. The lesson also covers how to display task statuses with icons and dynamically manage control visibility using properties and logical conditions. Finally, the instructor presents a challenge for students to update a task status using checkboxes, urging them to explore functions like Patch, Update, and UpdateIf before the next lesson.

This is a Power Apps tutorial lesson demonstrating how to update collection records when a checkbox is marked in a gallery control. The instructor explains the Patch function with three arguments (data source, record to update, and values to change), then implements it in the OnCheck property of a checkbox. The lesson includes a challenge for viewers to implement a delete function with confirmation popup. The video contains platform-specific intro and outro sections for both Udemy and YouTube distribution.

This Power Apps tutorial demonstrates how to implement item deletion from a gallery with user confirmation. The lesson covers:

• Adding a delete button with trash icon to gallery items

• Using the Remove() function to delete records from a collection

• Implementing the Confirm() function to show confirmation popups

• Customizing popup properties (title, subtitle, button text)

• Using conditional logic (If statement) to handle user confirmation responses

• Updating Power Apps version to access newer features

In this lesson, we integrate a WhatsApp formula into a button on the contact screen using previously learned methods. The process involves copying the formula, adapting it to fetch the phone number and name from the selected contact in the gallery, and sending a predefined message. The tutorial also addresses potential errors from special characters in phone numbers, with a promise to rectify this in the next lesson.

This script provides a step-by-step guide on how to clean phone numbers by removing special characters in Power Apps. It details the process of using the 'with' function to simplify complex formulas and introduce local variables such as 'phoneNumber' and 'message'. Additionally, it explains the utilization of the new User Defined Functions feature in Power Apps to create reusable logic. The guide also includes instructions on enabling necessary settings and using provided code snippets to clean phone numbers for WhatsApp integration.

The script details the completion of a phone app feature that allows users to open a phone number directly in the phone app. It explains using the launch function with a simplified formula to achieve this. It incorporates the 'sanitize phone number' function for clean data. After implementing the formula, the script demonstrates the app working on a smartphone by selecting a contact and launching the phone app to make a call. The script concludes by congratulating the users on completing their first app and hinting at more advanced features in the next module.

Planning Your Time Entry App: Essential Features, Data Structures, and Mockups

In this episode, we emphasize the importance of planning before building an app. We discuss identifying key features and creating a solid data structure to avoid future complications. Using a time entry app as an example, we demonstrate creating a mockup to present to potential users before full development. We explore the main screens, necessary lists, and data columns for the app, including project and task lists, and approver validations. The episode concludes with a look ahead to creating the SharePoint lists needed for our project.

In this video, we walk through the process of creating a SharePoint site and lists to serve as our dataset for a Power Apps application. The steps include accessing SharePoint from the App Launcher, creating a new team site, configuring its settings to be private, and adding members with specific permissions. The tutorial emphasizes the importance of adding users to SharePoint to ensure they have access to the app's underlying data. The session concludes with a plan to create lists in the next lesson.

This video tutorial guides viewers through the process of creating a SharePoint list to store project data for a time entry app. The tutorial starts by reviewing a Miro mockup and then demonstrates how to create a new 'Projects' list in SharePoint. The video outlines how to add standard columns such as ID and Title, and how to create a custom 'Project Status' column with predefined choices. It also shows how to add sample records to the list, detailing the functionality of each column. Finally, it previews additional interface features, such as editing in grid view and adding attachments.

In this video, the instructor walks through the process of creating a tasks list in SharePoint for tracking project tasks. They begin by identifying necessary columns such as Task Date, Worked Hours, Description, Project ID, Approval Status, and Creator. The instructor details each column's purpose and configuration, including setting data types and configuring properties like default values and character limits. They also demonstrate how to add, edit, and remove columns, and populate the list with example data. Finally, they hint at the next step: creating an approvers list to manage task approvals.

This video tutorial guides users through the process of creating an 'Approvers' list in SharePoint. The instructor demonstrates how to add a column for storing approvers' emails, and then manage the left-side navigation pane by editing and organizing it for easier access to lists such as Projects, Tasks, and Approvers. The video concludes by previewing the next segment, which will cover the concept of solutions for professional app development.

The video script discusses the concept of environments and solutions within Power Apps, essential for application development for companies. It explains the purpose of different types of environments (Dev, Test, and Production) and the role of solutions in migrating apps between these environments. The script takes viewers through the interface of Power Apps, demonstrating how to create a new solution and publisher. It emphasizes the importance of using solutions to package and manage apps, facilitating the migration process and making use of premium resources within a development environment. Finally, it provides instructions on setting up a developer environment and creating a new app within a solution.

This lesson outlines the initial steps to build a Timesheet App in PowerApps using a tablet format layout. The instructor starts by selecting the tablet format and naming the app. They then demonstrate how to connect to a SharePoint data source by creating or selecting an existing connection. Following that, the script covers adding a company logo to the app and enabling modern themes and controls in settings. Key differences between classic and modern controls are highlighted, particularly the differences in property access. The script concludes with saving these initial configurations and preparing to build the first home screen in the next lesson.

This lesson walks through the process of building the home screen for an app using Power Apps. It outlines the components needed based on a mockup, including a logo, app title, two buttons (Time Entry and Time Approval), and an image. The instructor demonstrates how to insert and position the image, add and configure a vertical container for organizing controls, and format the app title and buttons. The lesson concludes with guidance on renaming elements for better organization and saving the progress. The next session will focus on building the second screen for task management.

The video script demonstrates the creation of a new 'Time Entry' screen in an app using preconfigured templates with header, body, and footer containers.

The process involves duplicating the logo from the home screen, inserting and configuring a Home button with an icon, adjusting container sizes, and preparing to add more controls such as filter inputs and a new entry button. The focus is on building the interface first before adding functionality.

In this lesson, we enhance a user interface by adding date pickers and labels into a vertical container. Initially, the script identifies the need to replace drop-downs with date pickers, requiring the insertion of new elements in a vertical container due to the limitations of a horizontal layout. The process involves inserting a vertical container, disabling its flexible width, and adjusting its size. Labels and date pickers are then added and aligned within this container. Padding and alignment adjustments ensure that the elements look visually appealing. The final steps include duplicating the setup for 'end date,' renaming elements for clarity, and preparing for the next lesson, which will focus on adding buttons and configuring spacing.

The script provides a step-by-step guide on creating and customizing a header for a user interface, focusing on adding a 'New Entry' button.

It discusses copying an existing button, adjusting its dimensions and alignment, adding padding, and ensuring all elements within the header are uniformly sized.

The script also explains how to create spacing between elements using a container and adjusting its width and shadow properties. Finally, it concludes with setting appropriate padding for optimal visual alignment and preparing for the next lesson on building a gallery for time entries.

The video provides a step-by-step guide to creating a gallery that displays data from a SharePoint list in PowerApps. It illustrates the process of separating a container into two parts: one for header labels and the other for the gallery. Instructions include inserting a horizontal container for headers, a vertical gallery, connecting to the SharePoint tasks list, and adding text fields for Description, Project ID, Created By, Task Date, Worked Hours, and Approval Status. The script concludes with aligning the fields and preparing to add headers in a subsequent lesson.

In this lesson, I will show you how to create and set up a header for your gallery. You'll learn how to choose and rename containers, add text elements as headers, and use app theme settings to change text colors. I will guide you on adjusting the width of text labels to make everything look aligned and neat.

You'll also see how to copy and paste text controls and rename them to keep everything organized.

At the end of the lesson, you'll get a preview of the next lesson, where I will explain how to create a container that shows the number of rows and total worked hours.

In this lesson, we continue our gallery design by adding a footer below the gallery. The footer will display the number of rows and sum of worked hours. We start by inserting a horizontal container and configuring its properties, including adding text labels and adjusting their width, font size, and padding. Additionally, we add action icons for tasks such as editing, deleting, approving, and rejecting. The lesson concludes with a preview of creating an approval screen and the next steps in completing the gallery's formatting and functionality.

In this lesson, you'll learn how to enhance your gallery design by utilizing the lookup function to display project titles instead of IDs. The tutorial covers adjusting various design elements including text alignment, font properties, and label widths. Additionally, you'll be guided on how to add a user image, calendar icon, clock icon, and status badge to enhance the visual appeal of the gallery. The session concludes with a preview for the next lesson on adding conditional formatting using the if statement.

In this lesson, we learn how to configure a status badge to show different colors based on the task status in a SharePoint list. The video demonstrates adding rows with different statuses (Pending, Approved, and Rejected) to the list, refreshing the data in Power Apps, and writing a formula to assign colors to the badges. The tutorial covers using the if function to test multiple conditions for status values and applying corresponding colors. Finally, it provides a brief overview of the upcoming lesson on developing a new entry screen pop-up for adding or editing tasks.

This lesson provides a detailed guide on creating and editing pop-up forms for tasks. It explains the step-by-step process of setting up a visible container triggered by a button click. The tutorial covers creating an all-screen horizontal container, adding transparency to it, and further adding a vertical container to hold input controls. Various nested containers, both vertical and horizontal, are used to organize different controls like project names, dates, hours worked, and comments. The script also emphasizes using a custom form without a standard form control, setting visible properties, and preparing to add necessary controls and formulas in subsequent lessons.

In this lesson, we continue developing a pop-up for a task management app by adding controls such as a header, dynamic title, close button, and footer with save and cancel buttons.

It covers aligning elements, adjusting container padding, and removing shadows for a clean look. The tutorial then focuses on adding input fields for project selection, task date, worked hours, and comments, ensuring the layout is organized and functional.

Finally, all elements are renamed for clarity, preparing for the next step of adding formulas for interactivity.

This lesson teaches how to implement the logic for closing a popup via various buttons (close, cancel, save) by using local variables and the UpdateContext formula.

The script covers the visibility property configuration for popups based on variable states, and how to apply these changes to different buttons within the app to toggle the popup's visibility.

Additionally, it introduces the creation and logic implementation for a delete confirmation popup, following similar steps. The lesson concludes with a preview of the next steps in building this feature.

This video lesson demonstrates how to create a delete confirmation popup for an app.

The tutorial walks through the process of adding a screen-covering container with a transparent background and a centered container for the popup. Detailed steps for inserting a header with text and icons, configuring buttons for delete and cancel actions, and ensuring the popup remains on top of other screen controls are provided.

The lesson concludes by mentioning the upcoming functionalities that will be added in the next session, including navigation, task management, and filtering.

In this lesson, we explore adding logic to navigate between screens and conditionally show or hide button icons in our app. We start by setting navigation formulas for 'Time Entry' and 'Time Approval' buttons, differentiating by whether certain icons are visible based on context variables.

We go into detail on using global and context variables to manage these transitions and apply conditions to button visibility. We conclude by outlining how these visibility rules toggle icons like 'Edit,' 'Delete,' 'Approve,' and 'Reject' based on user actions or roles.

This tutorial guides you through enabling a time approval button exclusively for registered approvers in Power Apps. You'll learn how to retrieve the current user's email, validate it against a SharePoint approvers list, and use a lookup function to verify the email's existence.

The outcome is stored in a global variable to set button properties, covering the entire process from formula creation and app load variable setting to running code for user status verification. Additionally, the lesson demonstrates controlling the button's display mode based on user status, refreshing the dataset, and updating the app.

An upcoming lesson will focus on sharing the app to compare experiences between approvers and non-approvers.

In this video, we demonstrate testing an app with two different users, Rudimar and Clark, to validate access permissions. Clark is initially not an approver and the app's button is disabled for Rudimar. Clark is added as an approver, given app access, and can see the button enabled. A method to hide a persistent purple navbar is also shared. We confirm the logic works and preview the next lesson on using the patch function to make a new entry popup work.

In this lesson, you'll learn how to utilize the Patch function in Power Apps to create new tasks and manage them using a popup interface.

The lesson covers configuring input fields for task details such as project ID, task date, worked hours, and comments, and setting up dropdown lists for project selection.

The lesson also touches on default field auto-filling, entry verification, and previews upcoming lessons on task editing and deletion.

In this lesson, you will learn how to effectively use PowerApps to manage pop-up forms for creating and editing records in SharePoint lists. The tutorial includes dynamically changing the pop-up title, pre-filling form fields with existing data for editing while ensuring fields start blank for new entries. It also covers troubleshooting steps for resetting form fields to prevent retaining old values, employing the reset function, and ensuring that edits and new entries are handled efficiently.

In this lesson, we finalize our popup by fixing the save formula so it either saves a new task or edits an existing one. We address the issue of always creating a new row and ensure the correct record is edited by adjusting the lockSelectedItem variable in the formula. Demonstrations include creating a new task with details like date and description, and editing an existing task's hours and description. The lesson concludes by preparing to add logic to prevent users from editing approved or rejected records in the next lesson.

In this lesson, you will learn how to disable the Edit and Delete buttons when a record is approved or rejected to prevent users from modifying values post-approval.

The tutorial walks through applying a conditional formula to the DisplayMode property of the buttons, ensuring they remain functional only for records with a 'pending' status.

The same logic is then extended to additional buttons visible to approvers.

In this guide, we implement the delete logic for tasks in a task management app.

We start by explaining the importance of a confirmation popup to prevent accidental deletions. The process involves using the 'remove' function to delete an item from the task list, setting the selected item in a variable, and handling the popup's onSelect event.

A demonstration shows deleting a task, with emphasis on refreshing the list and recovering deleted items via SharePoint’s recycle bin. The lesson concludes by mentioning upcoming features like task filtering and aggregation.

In this lesson, you will learn how to implement aggregations, such as counting the number of tasks and summing total worked hours, directly below the task gallery.

The tutorial guides you through concatenating text with dynamic values using properties like AllItemsCount for tasks and a sum function for worked hours.

You'll see how these values adjust dynamically when filters are applied to the gallery. The upcoming lesson will focus on implementing the filters for the gallery.

In this lesson, we will add date filters to a gallery that adjusts based on selected Start Date and End Date inputs. The tutorial demonstrates how to display all items when no dates are selected, filter items if only the Start Date or End Date is selected, and filter within a date range when both dates are provided. It also covers adding a 'Clear Filters' button to reset date inputs and other filters. The lesson includes implementing these filters within the gallery's item condition and utilizing an OR condition to handle blank dates efficiently. Viewers are encouraged to review and understand these techniques for future projects.

This lesson covers the implementation of start and end date filters in a gallery. It explains how to set the conditions for filtering tasks based on their dates, using logical operators like OR and AND. The lesson demonstrates how to handle blank selections and combine filters to apply date ranges. Additional details include adjusting button sizes and font to match the design, ensuring consistency. Finally, the lesson concludes with a preview of the next topic, focusing on making buttons functional in the time approval screen.

This lesson guides you on adding the functionalities for the approve and reject buttons in the approver view of an app.

It explains how to use the patch function to change the status of tasks from pending to approved or rejected by editing existing records in the TasksList table.

The process involves updating the task status column value using appropriate syntax for choice columns.

The lesson also covers adjusting button colors and briefly mentions the next lesson's focus on adding a checkbox for multi-select task approvals.

In this tutorial, you will learn how to add checkboxes to a gallery in PowerApps allowing an approver to select multiple records at once.

You'll be guided through the steps of inserting and configuring these checkboxes, including resizing and placing them in the right positions. Additionally, you will see how to add a header checkbox to select all items and how to insert and configure buttons for approving or rejecting selected items.

The lesson also covers creating a text label to display the count of selected items and applying visibility rules to these elements. The session ends with a preview of the next lesson focusing on implementing the necessary formulas.

In this lesson, we learn how to implement logic for a header checkbox that selects or deselects all checkboxes within a gallery.

The header checkbox, named chkSelectAll, controls the default value of the individual checkboxes.

The logic is further refined to ensure only items with a 'pending' status are affected, preventing selection of already approved or rejected items.

Additionally, we adapt to interface changes in Power Apps, update item statuses, and adjust the display mode of checkboxes for a more streamlined user experience.

This lesson introduces collections in Power Apps, explaining that they are temporary tables used to store data during app runtime. The instructor demonstrates creating a collection using the collect function, adding records, and viewing rows in the collection.

He also shows how to clear collections with the clear function and combine these actions with the clearcollect function.

The lesson covers visualizing collections in a table control, adding dynamic values from text inputs, and updating records within a collection using the updateif function. The instructor emphasizes the temporary nature of collections and their usefulness for local data manipulation before submitting to the data source.

Learn how to efficiently update multiple records in a SharePoint list using collections. The process covers collecting selected records, updating their status, and using the Patch function to send updates back to SharePoint. You'll also see how to handle data with functions like clear collect, showColumns, and UpdateIf. Additionally, we finalize visibility conditions for containers, ensuring they appear only when necessary, and filter tasks to show only those created by the logged-in user, enhancing overall app functionality.

In this session, you will learn how to refine an application's task management feature to ensure that users can only see their tasks.

Using an example with Clark Kent, the process involves creating new task entries and implementing a filter in the time entry screen.

The filter condition ensures tasks are viewable only by their creators, while approvers can see all tasks. Adjustments are made to the filter formula to include conditions for task dates and user roles.

By the end, the app accurately differentiates between user and approver views, ensuring proper task visibility based on roles. The final app features include a home screen, time entry screen with date filter, an entry pop-up, and an approval screen for task management.

In this lesson, we address the security issues related to a test user, Clark Kent, accessing a SharePoint-connected app. Although the app interface limits his actions to only entering time and viewing his tasks, Clark can still access the SharePoint site and modify tasks or lists through the URL. This module focuses on SharePoint configurations to restrict such access and protect the data, ensuring users cannot view or alter data beyond their designated permissions. It emphasizes the importance of securing the site and suggests practicing these configurations on your site.

This lesson demonstrates how to configure list item permissions in SharePoint to ensure users can only view and edit their own items. The instructor walks through setting up permissions for a Tasks list, a Projects list (where users can read but not edit or delete items), and an Approvers list (where users can only read items). The steps include accessing List Settings, navigating to Advanced Settings, and configuring Item Level Permissions. The lesson concludes with a preview of the next session, which will cover site permissions to prevent users from altering the structure of lists.

In this lesson, we will disable member editing capabilities in SharePoint. Using a test user, Clark Kent, we first demonstrate removing access and then re-establishing it with limited permissions. We navigate through site permissions, create a new user group 'TimesheetAppUsers' with 'Contribute' permission, and update our test user’s permissions. By doing this, users can interact with list items but cannot edit the site structure. The next video will focus on further restricting users from altering data via the SharePoint interface.

This lesson introduces Power Automate, a tool within the Power Platform family used to automate repetitive tasks and integrate systems. The instructor explains how Power Automate can trigger specific actions like sending emails or notifications, generating reports, and performing recurrent tasks without manual intervention. Key features highlighted include the ability to build automations using building blocks, thus eliminating the need for coding, and enhancing productivity. Limitations are also discussed, noting that Power Automate is not suitable for replacing complex systems, performing complex data analysis, or processing real-time events. The lesson concludes with a preview of the next session, which will cover different types of Power Automate flows and their applications.

In this lesson, we explore four types of Power Automate flows: Automated Cloud Flows, Instant Cloud Flows, Scheduled Cloud Flows, and Robotic Process Automation (RPA) flows. We cover how each type functions and provide practical examples for their use. Automated Cloud Flows are triggered by events, like adding a SharePoint item or receiving an email. Instant Cloud Flows are manually triggered, such as sending an email with a button click. Scheduled Cloud Flows run at predetermined times, like sending weekly summaries or performing daily backups. Although RPA flows are not covered in detail in this module, we note they involve automating tasks on a local machine. The next lesson will focus on connecting and using different types of connectors, both standard and premium.

This lesson discusses the use of connectors in Power Automate, similar to those in Power Apps for services like Excel and SharePoint. The script emphasizes the vast number of available connectors, including both standard and premium options, which allow for automated workflows across various platforms. It also highlights the importance of understanding the limitations and licensing requirements of these connectors, recommending users review the documentation for detailed information on usage limits and potential issues.

This lesson introduces request limits and allocations in Power Automate, emphasizing the importance of understanding these limits before creating your own flows. The script explains that each step in an automation flow counts as a request, and there are daily limits based on your license type and usage. It covers different performance profiles, such as low, medium, and high, which correspond to various plans and their capabilities. For instance, basic Office licenses allow up to 10,000 requests per day, while advanced licenses offer more. Detailed documentation is suggested for further reading. The lesson concludes with a preview of the next topic: examining flow components like triggers and actions.

This lesson provides an overview of the two main components of a Power Automate flow: triggers and actions. Triggers are events that start a flow, such as adding a file to a folder or receiving an email. Actions are the tasks that occur as a result of the trigger, including sending emails, updating records, or copying files. The lesson explains how to configure these components and provides examples of how they can be used in practice. The next part of the lesson will cover the different interfaces available in Power Automate.

This script explains the transition between the old and new interfaces of Microsoft Power Automate. It highlights the improvements made in the new design to aid developers and emphasizes the importance of learning the new interface to avoid future adaptation issues. The script also mentions that future lessons will focus on using the new design, despite some features still existing only in the old design.

This lesson introduces the Power Automate interface, beginning with how to access it via the Power Apps interface or directly through make.powerautomate.com. It highlights the home screen features, including learning resources, and outlines the 'Create' tab for various flow types. The script also covers features like 'Describe to Design,' desktop flows, and process mining. It discusses the 'Templates' tab for pre-made flow templates, and the 'Learn' tab for accessing Microsoft documentation. Finally, the 'My Flows' tab is explored, showing how to manage created and shared flows. The upcoming lesson will focus on solutions for creating flows.

In this lesson, we will learn how to create a solution to store flows in Power Automate, which makes them portable for migration between environments. The process involves naming the solution, selecting or creating a publisher, and understanding the benefits of solution-aware flows through Microsoft documentation and real-world examples. The tutorial covers creating a blank solution and setting up a publisher before moving on to creating flows within the solution. The next lesson will focus on creating the first flow and exploring the interface.

In this video, you will learn how to create your first flow in Power Automate. Starting from the solution interface, you will be guided through the process of creating an Instant Cloud Flow with a manual trigger. The video covers how to name your flow, select the trigger, and add steps using connectors and actions. It also explains the different types of connectors available, such as built-in, standard, premium, and custom connectors. Additionally, you will see how to test and save your flow, explore the new interface, and use features like the Copilot and Compose actions. The video concludes with a demonstration of running the flow using the new interface.

In this lesson, we will start creating our first automated flows. First, we need to set up a data structure using a SharePoint list. This list is used to automate tasks such as item creation and daily report generation. The example utilizes a task list from a previous lesson on the Timesheet Management app, which includes columns like ID, task date, worked hours, description, project ID, and approval status. If the list is not already created, it's recommended to review the previous module. The next lesson will focus on creating an automated cloud flow that triggers a notification to approvers when a new task is added. This setup does not require the app; tasks can be added directly through SharePoint for learning purposes.

This lesson guides you through creating an automated Cloudflow in Power Automate that triggers a notification in Teams when a new task is created in a SharePoint list. The process covers setting up the initial flow from within a solution, selecting the appropriate SharePoint trigger, naming the flow meaningfully, and configuring the trigger and action. The instructor demonstrates adding a Compose action to temporarily store data, saving the flow, and testing it by creating a new task in the SharePoint list. The tutorial also emphasizes the importance of using solutions for organization and provides insights into viewing and editing the flow through both old and new Power Automate interfaces.

In this lesson, we demonstrate how to add the 'Send a Notification to Teams' action into a flow using Microsoft Power Automate. The process involves removing unnecessary components, signing in to create a connection with Microsoft Teams, and configuring the posting options for notifications. The example provided describes posting a message to a chat via a flow bot, including specifying recipients, message content, and additional task details. Finally, we test the flow, observe the message in Teams, and outline the next steps to automate recipient updates from an approvers list for dynamic notifications.

In this lesson, we build a flow in Power Automate to send notifications and Teams messages to a dynamic list of approvers sourced from a SharePoint list. The process involves fetching approvers' data using the SharePoint 'Get Items' connector, terminating the flow to test this action, and visualizing the output. We then explore methods to concatenate email values for sending notifications. This tutorial includes building and testing steps, adding examples for better understanding, and setting the stage for more advanced techniques in upcoming lessons.

This lesson explains how to concatenate email addresses from multiple approvers into a single text string using Power Automate. It covers initializing a string variable, iterating through a list of items fetched from a SharePoint list, and using a foreach loop to append each email to the variable. The process tests how the flow works, visualizes the results using a compose action, and demonstrates how to avoid overwriting the variable contents to achieve the goal of sending a single email to all recipients.

This lesson covers how to append strings to an existing variable and use this modified variable in a workflow to send messages and emails. It explains the steps to add semicolons to separate email addresses, configure and test message sending to multiple recipients, and eventually use the concatenated email variable to send a notification email via Office 365 Outlook. The script also discusses debugging and removing unnecessary steps, with a preview of the next lesson on improving email visuals.

In this lesson, we improve the simplistic design of an email by applying HTML and CSS within an automation tool. First, basic text formatting like bold and headings are applied. Then, HTML code is viewed and improved using AI by creating styles for different email elements. The process involves copying generated code from the AI, applying it in the email body, and testing the output. Additionally, the lesson shows how to separate CSS and HTML using 'Compose' actions to facilitate easier updates and reusability. Finally, the same styling techniques are applied to messages in Teams, demonstrating adaptability between platforms.

The script provides a detailed overview of various features available in the Power Automate interface. It covers navigation options such as zooming, fitting the view, and using the mini map. The search function is highlighted for easier location of actions within a large flow. Additional features like sending feedback, version history, saving drafts, and publishing versions are discussed. The newly introduced Copilot feature is demonstrated through an example of adding fields to an email message body. The script also points out the ability to toggle between the new and old interface designs.

In this lesson, you will learn about the remaining two types of cloud flows: scheduled and instant cloud flows. We will build a flow that sends a daily report of tasks from Monday to Friday, formatted as a table, and sent to approvers via email. This process includes concatenating approvers' emails from a SharePoint list to avoid repeating the process for multiple flows. We'll also explore the concept of child flows, reusable flows triggered by parent flows, which helps in organizing and maintaining processes. The lesson will cover how to build an Instant Cloud Flow, which will serve as a child flow for the scheduled cloud flow.

In this tutorial, learn how to build an instant cloud flow using Power Automate to concatenate emails from approvers. The method involves manually triggering a flow, fetching approvers from a SharePoint list, and using the 'Select' data operation for efficiency. The process eliminates the need for loops, reducing execution time significantly. The tutorial also includes a method to join emails using the 'Compose' action and details on adding delimiters. Finally, the flow prepares for the next step: sending automated emails with task summaries.

The script details the process of creating a scheduled cloud flow in Power Automate that runs daily from Monday to Friday. This flow loads tasks from task lists, formats them as a table, and sends them to approvers. It includes configuring the flow schedule, setting recurrence options, and saving the flow. Moreover, it introduces a child flow for retrieving concatenated approvers to ensure reusability. The flow is set to run at 7 PM on business days and is designed to automate daily reporting tasks.

This video tutorial continues the process of querying a dataset, specifically a tasks list from a SharePoint site. The instructor demonstrates how to filter tasks created on the current day using advanced parameters and a filter query. By utilizing the Compose action to generate the start of the day in UTC format, the filtered tasks are obtained. The tutorial also covers running the flow manually, viewing the JSON output, and strategies for improving efficiency by limiting columns and data payload size. Future lessons will focus on formatting the tasks as HTML and addressing time zone issues for accurate date retrieval.

In this tutorial, the process of converting selected tasks into an HTML table for email distribution is explained. It starts with selecting the necessary data fields such as created by, task date, worked hours, approval status, and description. The selected data is then converted into an HTML table using the 'Create HTML table' function. Finally, the process includes sending the generated HTML table via email using Outlook's 'Send email v2' action. The tutorial concludes with a preview of the resulting email and a note on enhancing the table's appearance via CSS in subsequent lessons.

In this lesson, the instructor demonstrates how to style an HTML table in an email using AI-generated CSS. The process includes copying the HTML table output, requesting CSS styling from AI, and applying the CSS to the email content. The instructor further refines the email by adding a header and footer using AI-generated HTML snippets and addresses a minor error caused by not toggling the HTML button. The lesson concludes with the email being ready for approvers, with the promise of covering child flow adaptations in the next session.

This video demonstrates how to integrate a child flow into a parent flow for retrieving approver emails. Initially, there is an error because the child flow does not end with a response action. The speaker modifies the child flow to include a response action that sends concatenated emails back to the parent flow. After fixing the response issue, another error arises related to 'run only user connections.' The speaker resolves this by configuring the child flow to use static connections instead of user-dependent connections. These adjustments enable the parent flow to run successfully, retrieve the approver emails, and send them as part of an email process. Finally, a note about possible date formatting issues due to different time zones is mentioned for future improvement.

In this lesson, Rudi explains how to handle dates and time zones in Power Automate to prevent errors. He demonstrates how to convert the UTC time to the local time zone before processing tasks from a SharePoint list. For instance, he shows how tasks intended to run at 7 PM in Los Angeles might retrieve a wrong date if only using UTC time. By converting to the local time zone and then back to UTC for filtering, he ensures accurate task retrieval across different time zones. Rudi also discusses correctly setting the time zone in SharePoint and using UTC with the 'Z' format to negate local time zone discrepancies.

In this lesson, Rudi demonstrates how to use Scopes to organize actions within a flow better. He shows how to edit the flow, delete unnecessary actions, and group actions related to time conversion and data manipulation into Scopes. This method helps keep the flow organized by collapsing grouped actions, allowing easier management and editing of related tasks.