Power Apps for Beginners

This section will provide you with an overview of the Power Apps maker environment. By the end of the section, you should understand what features and functions are available.

In this lecture, you will learn how to access the Power Apps maker studio as well as discover the available functions on the landing page.

In this section, we will explore the starting point for where you build your apps from. You will learn about the different app types and ways to start building Apps.

In this section, you learn where to find applications that have been shared with you or created by you.

In this section, you will learn about solutions and how they can be used to package application changes and migrate to other environments.

In the lecture, you will learn about Flows and what they can be used for.

In this lecture, you will learn about data tables.

In this lecture, you will learn about Dataflows and how this feature can be used to extract, transform and load data into your Dataverse.

In this final lecture, we will discuss some miscellaneous features available within the Power Apps maker studio.

The Power Apps design studio is the platform used for building Canvas Apps, and section 3 provides an orientation of it.

In this lecture, I will provide an orientation of the left navigation panel in Power Apps Design Studio.

The focus of this lecture is to provide insight into the design area, which is the space where you build your Apps.

In this lecture, you will learn about object properties and how to make changes to get the ideal look and feel that fits your design.

In this lecture, you will learn about the formula bar and how it is used to change object behaviour.

For our final lecture of section three, we will cover additional features before proceeding to build our first App.

In this short video, we will review what will be covered in this section.

In this lecture, I will show you how to automatically create an app using data in an Excel file.

In this lecture, I will show you how to create a simple SharePoint site and a list, then using the list we will automatically create an app.

In this lecture, you will learn how to automatically create an app using an existing data table within your Dataverse.

In this lecture, you will learn how to create a simple expense tracking app using Microsoft Copilot.

Welcome to Section 5, from here onwards all the exercises will be hands-on, so I encourage you to follow along and do as I do, this will help you get a feel for each of the tools.

Over the next few sections, we will be focusing on the types of objects that can be added to your app and what each of them does.

In this lecture, you will learn how to add new screens to your app either using layouts or templates.

Lecture Version: February 24

In this lecture, we will be importing the exercise template I have created for you that you will use throughout sections 5 and six.

In this lecture, we will be working with labels. You will learn how to display static and dynamic text.

In the lecture, you will learn the basics of working with buttons. By the end of the lecture, you will know how to;

• Add buttons

• Change the theme

• Use expressions to update the state of a button

• Use expressions to hide and show objects

• Use buttons to navigate between screens.

In this lecture, we will explore the following input types

• Text input

• Number input

• Dropdown

• Combo

• Date picker

• List box

• Checkbox

• Radio

By the end of the lecture you will be familiar with the properties and typical use cases for each.

In this lecture, we will explore the following input types

• HTML Text

• Rich Text Editor

• Pen Input

• Toggle

• Slider

• Rating

By the end of this lecture, you will understand the use cases and how to implement them into your apps.

In this lecture, you will learn how to user containers to hide and show groups of objects by creating two different forms that enable a user to select which form they need.

In this lecture, you will learn how to work with the timer control by creating a simple app that records time intervals and stores each entry to a temporary data collection. By the end of this lecture you will have learnt not only how to work with the time control but also how to use context variables to update object properties.

In this lecture, we will be exploring the address input control by building a simple Excel database to capture leads. In this lecture, you will learn not only how the control works but also the basics of working with collections to save data temporarily.

In this lecture, we will be working with forms, however, for this exercise, you will be configuring forms for three different database types, Excel. Dataverse and SharePoint.

The object of this lecture is to learn how to configure forms for different data sources.

In this lecture, you will learn how to use the image control. By the end of this lecture, you will know how to upload image directly into your application as well as to display image from external data sources such as OneDrive, SharePoint and Dataverse storage.

In this lecture, you will learn about controls, the microphone and audio control. In addition, you will also learn how to use Power Automate to save audio recordings to SharePoint.

In this lecture, you will learn the basics of icons and their use. In addition, you will also learn how to configure the spinner control to hide and show when an icon is clicked.

In this lecture, you will learn about the add picture control. In addition, to understanding how the control works, you will also learn to use a Patch function to save the image to a Dataverse database.

In this lecture, you will learn about the formatting of Power Fx functions and how similar they are to Excel formulas. By the end of the lecture, you should be familiar with the basic syntax of power Fx expressions.

In this lecture, you will learn how to use the navigate function which includes the standard screen transition and conditional transition. By the end of this lecture, you should be able to configure app screen transitions with ease.

In this lecture, you will learn about the three types of variables, Global, Context and Collections. By the end of the lecture, you will understand the difference between them as well as the typical use cases.

In this lecture, you will learn how to configure a power Automate Flow to save data captured in by a user in an application. For the exercise, you will work with Power Automate, SharePoint and Power Apps. By the end of the lecture, you will know how to integrate your app with external data sources using Power Automate.

Important announcement for course content update.

Over the next few lectures, we will be covering the Filter function. You will learn how to filter data based on user inputs. For this exercise your will need to create sample data, please check your resources for the link to mokaroo.

Now that you have created your connection to your data source, next we will configure the galleries to display your data.

Now that we have set up the data and galleries, we will now insert the filter expression that will filter the contacts to only display the contacts associated with the account we selected.

In this lecture, we will continue to learn about filtering, we will now filter the account list using a dropdown.

Is this lecture, you will learn how to use the Search expression to filter data to the text entered by a user.

In this lecture, we will display a list of companies, when a company is selected, the user will be able to edit the company record and save the changes. In this exercise, you will be using a few formulas, such as

• Navigate

• SubmitForm

• TemplateFill

In this lecture, we will cover the delete action using the Remove() expression.

Often when a user enters data we want to record which user is making the change. In this lecture, we will map the logged-in user to the CompanyEdit form so that each time a record is saved we can see who was the last person to interact with the customer record.

In this lecture, we will be covering the And, Or & Not operators.

In this lecture, we will explore setting Variables within the APP object so that when our app starts a value stored that can be referenced within the app as a global variable.

In this lecture, we will explore how to use the Sum expression to get the total sales from our sales data source.

In this lecture, we will be accessing the Calendar() object to create a list of months, weekdays and AM/PM dropdown options. Also, we will explore 2 extra functions, Now() and Today() as options for setting the date and time on the user interface.

In this lecture, we will explore the ColorFade expression to create color pallets for our apps.

In this lecture, we explore the Concatenate formula which joins two or more strings into a single string.

In this lecture, we will be exploring the CountRows expression to count the number of rows in a table. I have included in the resources a contacts list which you can download and use for this excercise.

In this lecture, we will be performing two exercises, calculating the number of days between two dates. We will also be doing an exercise using two dates, from and to and setting the to date to 7 days after the start date.

In this lecture, I will be showing a function to initiate a call from a mobile device by clicking on the dial button associated with a contact.

In this lecture, we will explore the download function

Finally, we move onto Model-driven apps. In this section, I will walk you through the basics of a model-driven app and you will create your first basic app.

In the previous lecture, I showed you how to create an app using the legacy experience, in this video, I will show you how to create the same app yet using the modern builder.

In this lecture, we will explore tables and the attributes thereof.

In this lecture, we will be exploring form which are the layouts used by users when capturing or viewing or editing data.

In this lecture, we will discuss the basic of personal and system views.

In this lecture, we will discuss entity/table relationships.

In this lecture, we will be discussing data types and the different options available to you.

In this lecture, we will explore the basics of a business process and how they can be used to guide users through a step by step process.

In this lecture, we will explore the basics of business rules and what they are used for.

Welcome, in this section you will be learning about creating columns and working with data types as well as column validation. This series will be a hands-on practise session, so it would be a good idea to log in to your trial environment before we begin.

Before we begin the data type exercises, we will fish create a solution and a new table for us to practise in. In this lecture, you will learn to

• Create an unmanaged solution

• Create a new table

For your very first column, we will be creating a text column. By the end of this lecture, you will know how to create a text column and add it to a form to be accessed by a user.

In this lecture, we will be creating a multiline text column as well as exploring the various options available.

In this lecture, we will create a few whole number fields, perform basic maths, and test out the number control.

In this lecture, we will explore the options available when working with decimal numbers and how they are different from whole numbers.

In this lecture, we will be exploring the Text Area column. Although the column seems to be exactly the same as a Multiline Text column, there are subtle differences which we will cover in this lecture.

In this lecture, we will be exploring the Yes/No column as well as the various properties available.

In this lecture, we will be exploring the Choice Column and the available attributes that can be confirgured.

In this lecture, we will be exploring the Choices column and how this column is different from the Choice column.

In this lecture, we will be exploring the URL Column and the available properties.

In this lecture, we will be exploring the out-of-box Status and Status Reason columns.

In this lecture, we will explore the Phone Column data type. We will review the available options as well as the related built-in Phone Call Activity.

In this lecture, we will be exploring the Owner column.

In this lecture, we will be exploring the Image Column and how it can be used to set the image of a record.

In this lecture, we will be exploring the Email Column and the related properties.

In this lecture, we will be exploring the Date Only and Date and Time Columns as well as the behavioural properties.

In this lecture, we will be exploring the Lookup Column and how this data type can be used to create a relational connection between records.