This course is divided into four main sections.

The first section provides an overview and sets learning expectations.

The second section offers an interface overview for newcomers to Power Apps, which can be skipped by experienced users.

The third section focuses on creating a contact agenda app using Excel, while the fourth section involves building a timesheet app connected to SharePoint, introduced specifically for the Udemy for Business program.

The course covers topics like Excel and SharePoint connections, navigation, notifications, variables, galleries, forms, filters, containers, popups, aggregation, modern features, and the patch function.

Feedback is encouraged for course improvements, with a dedicated section for ideas and inputs.

In this lesson, Rudy introduces himself and his professional background.

He shares his journey from being a mechatronics engineer to developing apps with Power BI and Power Apps since 2018.

Rudy started his YouTube channel called 'Apps in English' to teach Power Apps development online. He encourages viewers to subscribe for tips and updates and provides a link to his resources.

The next lesson will cover course goals and tips for better viewing.

In the final introductory lesson, the instructor reviews the goals of the Power Apps course, such as familiarizing students with development environments, key concepts, and resources. Tips include watching videos at increased speed and adjusting video quality. The script addresses the Q&A section for lesson-specific questions, refund policies for dissatisfied students, the importance of positive feedback for maintaining course quality, and the provision of additional YouTube resources for extended learning.

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.

How well do you know the Power Apps interface?

This quiz will test your understanding of key navigation areas, including the Home page, app authoring menu, tree view, insert menu, data tab, variables, themes, media management, and automation tools.

Strengthen your foundation before moving on to building and sharing your first app!

Test your knowledge on how galleries function and how to manipulate and display records effectively.

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.