Power Apps for Beginners from Udemy

What's inside

Learning objectives

Build mobile applications for android and apple devices.
Build web-based business applications.
Automate business processes and integrate with microsoft cloud services
Working with different data types
Integrate office 365 products such as onedrive and outlook with your apps
Write expressions using power fx
Creating forms, columns and views
Creating data tables

How to use basic tools to design and plan applications
Create business rules
Create business processes
Deployment
System and user administration
Security
Show more
Show less

Build mobile applications for android and apple devices.
Build web-based business applications.
Automate business processes and integrate with microsoft cloud services
Working with different data types
Integrate office 365 products such as onedrive and outlook with your apps
Write expressions using power fx
Creating forms, columns and views
Creating data tables
How to use basic tools to design and plan applications
Create business rules
Create business processes
Deployment
System and user administration
Security
Show more
Show less

Syllabus

In this module we will cover the basics of what the Power Platform is and what are the components with the platform.

Throughout this course, we will be covering three of the four main components of the Power Platform, PowerApps, Power Automate, and Power Virtual Agents. you will learn how to create a database using Microsoft Excel and also learn how to interact with the common data service now known as Dataverse.

Information regarding the recent change for trial registration that only affects users who do not have a paid Microsoft Office license such as a Work or Personal Office 365 account.

In this lecture, we will cover setting you up with your own 30-day trial environment which will be used throughout this course. If you do not finish the course within 30 days you may need to register for a new trial environment.

In this section, we will discuss what a canvas app is, the different types and some use cases.

Understanding the concept of model-driven applications and their use cases.

Understanding the concept of background automation and how we can use Power Automate to automate processes.

Understanding what the Dataverse is and its uses.

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.

Traffic lights

Read about what's good

what should give you pause

and possible dealbreakers

Covers Power FX expressions, which are similar to Excel formulas, enabling learners to leverage existing spreadsheet knowledge for app development

Explores integration with Microsoft cloud services, such as OneDrive and Outlook, which is useful for learners working within the Microsoft ecosystem

Requires a 30-day trial environment, which may necessitate re-registration if the course is not completed within the trial period

Teaches the use of Dataverse, which is now the standard data storage service for Power Apps, and is essential for building robust applications

Focuses on Power Apps and Power Automate, two of the four Power Platform tools, which may require learners to seek additional training for comprehensive platform knowledge

Includes hands-on exercises using Excel as a database, which is a practical starting point but may require transition to more scalable data sources like Dataverse for real-world applications

Reviews summary

Comprehensive power apps beginner guide

According to learners, this course is a largely positive and comprehensive introduction to Power Apps and Power Automate for absolute beginners. Many students found the lectures clear and easy to follow, praising the instructor's ability to explain complex topics simply. The course provides a solid foundation, covering essential concepts like Canvas and Model-driven apps, Power FX formulas, and Dataverse. Some reviewers noted that while the core content is excellent, keeping up with the rapid updates in the Power Platform can lead to some outdated demonstrations, which required them to find workarounds or supplementary information. Overall, it's considered a strong starting point for professionals aiming to build business applications.

Covers a wide range of beginner topics.

"The course covers a broad range of topics from Canvas apps to Dataverse and Power Automate."

"I liked that it didn't just stick to one type of app but introduced different components."

"Good overview of the ecosystem for a beginner."

"It touches on many important features you need to know when starting out."

Practical demos and exercises are helpful.

"The hands-on exercises are crucial and really help solidify the concepts."

"I appreciated building along with the instructor in the practical sections."

"Doing the demos myself made a big difference in my learning."

"The practical examples were very useful for understanding how things work."

Course provides a good basis for beginners.

"It covers the essential basics needed to get started with building applications."

"This course gave me a solid foundation in Power Apps and Power Automate."

"I feel confident now to start building simple apps after taking this course."

"A great starting point for anyone completely new to the Power Platform."

Instructor provides clear, simple explanations.

"The instructor does a great job of explaining complex topics in a simple and easy-to-understand manner."

"His explanations are very clear and concise, perfect for someone new to Power Apps."

"I found the lectures easy to follow and the concepts were broken down well."

"The way he explains things makes it very accessible, even if you have no prior coding experience."

Challenges reported with trial environments.

"Getting the trial environment set up was a bit tricky and caused some delays."

"The process for the 30-day trial seems to have changed, making it confusing to follow the initial setup lecture."

"Ran into issues with accessing certain features in the trial, which wasn't covered."

"It took me longer than expected to get the necessary environment working to start the exercises."

Some parts need updates due to platform changes.

"Some parts of the course are a bit outdated due to the frequent updates in Power Apps."

"Had to figure out some changes on my own because the interface looked different than the video."

"Keeping up with the platform changes seems to be a challenge for the course content."

"Certain demos didn't work exactly as shown because the Power Platform had been updated."

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Power Apps for Beginners with these activities:

Review Excel Formulas and Functions

Show steps

Reinforce your understanding of Excel formulas and functions, as Power Apps often uses similar logic for data manipulation and calculations.

Browse courses on Excel Formulas

Show steps

Review basic arithmetic and logical operators in Excel.
Practice using common functions like SUM, AVERAGE, IF, and VLOOKUP.
Complete online tutorials or exercises focused on Excel formulas.

Review 'Microsoft Power Platform Enterprise Architecture Guide'

Show steps

Gain a broader understanding of the Power Platform ecosystem and how Power Apps fits into larger enterprise solutions.

View Putting Knowledge to Work on Amazon

Show steps

Read the sections related to Power Apps architecture and governance.
Identify key considerations for designing scalable Power Apps solutions.
Summarize the main architectural components and their interactions.

Build a Simple Contact Management App

Show steps

Apply the concepts learned in the course by building a practical application that involves data input, storage, and display.

Show steps

Design the app interface with screens for listing, viewing, and editing contacts.
Connect the app to a data source like Excel, SharePoint, or Dataverse.
Implement CRUD (Create, Read, Update, Delete) operations for managing contacts.
Add search and filtering capabilities to the contact list.

Four other activities

Expand to see all activities and additional details

Show all seven activities

Document Your App Building Process

Show steps

Reinforce your understanding by documenting the steps you took to build a Power App, including design choices, formulas used, and challenges faced.

Show steps

Choose a Power Apps project you've worked on.
Describe the app's purpose and functionality.
Document the data sources used and how they are connected.
Explain the key formulas and expressions used in the app.
Reflect on the challenges you encountered and how you overcame them.

Follow Advanced Power FX Tutorials

Show steps

Deepen your understanding of Power Fx by exploring advanced tutorials that cover complex formulas, data manipulation, and custom functions.

Show steps

Find online tutorials or courses focused on advanced Power Fx topics.
Practice implementing complex formulas for data filtering, sorting, and aggregation.
Experiment with creating custom functions to reuse logic across your apps.

Create a Presentation on Power Apps Best Practices

Show steps

Solidify your knowledge and share your expertise by creating a presentation on best practices for designing, building, and deploying Power Apps.

Show steps

Research best practices for Power Apps development.
Organize the presentation into sections covering design, development, testing, and deployment.
Include real-world examples and case studies to illustrate the best practices.
Practice delivering the presentation to an audience or recording a video.

Contribute to a Power Apps Community Project

Show steps

Enhance your skills and collaborate with other developers by contributing to an open-source Power Apps project.

Show steps

Find an open-source Power Apps project on platforms like GitHub.
Review the project's documentation and contribution guidelines.
Identify areas where you can contribute, such as bug fixes, new features, or documentation improvements.
Submit your contributions through pull requests and participate in code reviews.

Career center

Learners who complete Power Apps for Beginners will develop knowledge and skills that may be useful to these careers:

Citizen Developer

A Citizen Developer uses low-code or no-code platforms to build applications without extensive programming expertise. This course will help a future Citizen Developer learn to confidently build applications using the Power Platform. The course offers step-by-step instructions on how to build both mobile and desktop applications, as well as how to set up background automation using Power Automate. Also, the course covers integrating with common Office 365 products like Outlook and OneDrive, which are must-haves for building solutions that work within a typical business environment. Those who are interested in becoming a Citizen Developer can find this course to be an ideal primer on the Power Platform.

See salaries and explore the career path for Citizen Developer

Application Developer

An Application Developer designs, builds, and deploys applications, often working with specific platforms or technologies to meet business needs. This course can help a prospective Application Developer build a foundation in the Power Platform, learning to develop both mobile and web-based applications. It provides hands-on experience with tools like Power Apps and Power Automate, which are essential for building business applications and automating workflows. The course's focus on integrating Office 365 products like Outlook and OneDrive is particularly helpful for building applications that work with commonly used business tools. The course will give you the confidence to design, develop, and deploy applications within an organization.

See salaries and explore the career path for Application Developer

Solutions Developer

A Solutions Developer creates software solutions that address specific business needs, often working with various technologies and platforms. This course will help a Solutions Developer learn how to build applications on the Power Platform, as well as setup automation using Power Automate. The courses provides hands-on experience in building mobile and web based applications and integrating with Microsoft cloud services. This is a great course for a Solutions Developer looking to expand their skills and become familiar with the Power Platform.

See salaries and explore the career path for Solutions Developer

Automation Specialist

An Automation Specialist designs and implements automation solutions to improve business processes. This course can help an Automation Specialist learn how to use Power Automate to automate a variety of business tasks. The course teaches how to set up background automation, and how to integrate different Microsoft cloud services. This course is perfect for an Automation Specialist looking for a step-by-step guide on how to use the Power Platform to achieve automation goals. It provides an introduction to the Power Automate tool and its uses in automating processes within the Power Platform.

See salaries and explore the career path for Automation Specialist

IT Consultant

An IT Consultant advises organizations on how to best use information technology to meet their business objectives. This course may help an IT Consultant by providing hands-on experience with the Power Platform, and demonstrating how to build applications and automate processes within the platform. This includes mobile and web applications, as well as integrations with Office 365. The course material includes details on how to design, build, and deploy applications, which are all relevant to an IT Consultant who recommends technology solutions. This course is useful for consultants looking to use the Power Platform as a tool in their recommendations.

See salaries and explore the career path for IT Consultant

Solutions Architect

A Solutions Architect designs IT solutions to meet specific business problems, often requiring a broad understanding of various technologies. This course may help a Solutions Architect gain hands-on experience with the Power Platform, focusing on how specific business problems can be solved with the platform, and how to automate business processes. The course materials provide experience with the fundamentals of Power Apps and Power Automate. The course begins with an orientation to the Power Platform and also provides insights into the different app types with use cases, which is helpful for understanding the capabilities of the platform and how to best apply it as a solution.

See salaries and explore the career path for Solutions Architect

Business Analyst

A Business Analyst identifies business needs, develops requirements, and helps implement solutions. This course may help a Business Analyst gain a deeper understanding of how applications are built via the Power Platform. Through hands-on practice with Power Apps and Power Automate, a Business Analyst can better understand what is possible and how to communicate with developers. The course covers designing, building and deploying applications, as well as integrating with Microsoft cloud services, all relevant topics for a Business Analyst who needs to understand technical solutions. Understanding how business processes can be automated is also highly useful in identifying areas for improvement within a company.

See salaries and explore the career path for Business Analyst

IT Support Specialist

An IT Support Specialist provides technical assistance to users, troubleshooting various software and hardware issues. This course may be helpful for an IT Support Specialist who wants to expand their knowledge of application development. The course teaches learners how to build mobile and web applications using the Power Platform, as well as how to automate business processes using Power Automate. An IT Support Specialist who understands how to design, build, and deploy applications using this platform can provide a higher level of support to end users. The skills learned in this course can provide a better understanding of the applications being used within their organization.

See salaries and explore the career path for IT Support Specialist

Systems Analyst

A Systems Analyst studies an organization's computer systems and procedures and designs improvements. This course may help a Systems Analyst understand how to build and customize business applications within the Power Platform. The course includes an overview of the Power Platform, as well as how to build mobile and web-based applications and automate processes. Understanding how the Power Platform integrates with Microsoft cloud services can be particularly helpful for a Systems Analyst who works within a Microsoft technology environment. The ability to automate business processes may inform a systems analyst's recommendations for improvement.

See salaries and explore the career path for Systems Analyst

Technical Support Engineer

A Technical Support Engineer provides technical support to customers or internal teams, often involving troubleshooting complex issues. This course may help a Technical Support Engineer understand the technical aspects of application development using the Power Platform. The course teaches the necessary skills to design, build, and deploy applications within the organization, and also provides an exploration of Power Automate for process automation. This course would help a Technical Support Engineer gain a better understanding of the technology used within their organization, and the troubleshooting skills learned can help them address issues relating to the Power Platform.

See salaries and explore the career path for Technical Support Engineer

Technical Trainer

A Technical Trainer develops and delivers training programs on software or technical topics. This course can help a Technical Trainer gain hands-on experience with how to develop applications on the Power Platform. The course offers a step-by-step beginner's guide on building applications using the platform allowing the trainer to develop training content around the technology. This course also provides an overview of the Power Apps maker environment, which is important for any kind of training on the Power Platform. When training others on the Power Platform, this course may be useful as a reference and a source of examples.

See salaries and explore the career path for Technical Trainer

Data Analyst

A Data Analyst collects, processes, and interprets data to provide insights for business decisions. This course may help a Data Analyst understand how data can be used within apps built on the Power Platform. The course briefly touches on working with different data types, data tables and Dataverse, and it covers connecting to various data sources including Excel, which is common for Data Analysts. While this course is not specific to data analysis, those familiar with Power Apps will have a higher level understanding of how data is presented and used within an application.

See salaries and explore the career path for Data Analyst

Business Intelligence Developer

A Business Intelligence Developer designs and develops solutions that enable data analysis and visualization. This course may help a Business Intelligence Professional understand how data is used within the Power Platform, and how applications connect to data sources. The course covers working with different data types and data tables, as well as using features like Dataflows for data transformation. Although the course doesn’t focus on data analysis, it does provide a basic overview of how Dataverse, a database specific to the Power Platform, operates. This would help a Business Intelligence Developer who may need to assist in application development projects on the Power Platform.

See salaries and explore the career path for Business Intelligence Developer

Project Manager

A project manager oversees project planning, execution, and completion within an organization. While the project manager role is not directly related to application development, this course may help a Project Manager better understand the process of application development within the Power Platform. The course teaches fundamentals of building mobile and web-based applications and setting up background automation. The course content would help provide a Project Manager with understanding of the technology used, which could then assist them when they create project plans for the deployment of applications built on the Power Platform.

See salaries and explore the career path for Project Manager

Database Administrator

A Database Administrator manages databases, which can include designing, implementing, and maintaining database systems. This course may help a Database Administrator learn about the Dataverse, a data storage solution within the Power Platform. The course curriculum includes how to create a database using Excel and interact with the Dataverse. While this course is not a deep dive into database administration, The knowledge of how data is used in the Power Platform can be helpful for a Database Administrator when they participate in or support projects which involve applications built on the platform.

See salaries and explore the career path for Database Administrator

Power Apps for Beginners

What's inside

Learning objectives

Syllabus

Traffic lights

Save this course

Reviews summary

Comprehensive power apps beginner guide

Activities

Career center

Reading list

Share

Similar courses