Microsoft 365 PowerApps from Udemy

This course introduces the user to Microsoft PowerApps, a tool that allows you to create forms and gather data. PowerApps is part of the Microsoft 365 suite and is the successor to InfoPath. In this course, you will learn how to modify SharePoint List Forms using PowerApps as well as how to work with PowerApp formulas. This course will also review some of the more advanced features of InfoPath, such as working with data sources. Finally, you will look at how to distribute your PowerApp, including how to share, embed, and export your app.

This course aligns with the CAP Body of Knowledge and should be approved for 4.5 recertification points under the Technology and Information Distribution content area. Email info@intellezy.com with proof of completion of the course to obtain your certificate.

With nearly 10,000 training videos available for desktop applications, technical concepts, and business skills that comprise hundreds of courses, Intellezy has many of the videos and courses you and your workforce needs to stay relevant and take your skills to the next level. Our video content is engaging and offers assessments that can be used to test knowledge levels pre and/or post course. Our training content is also frequently refreshed to keep current with changes in the software. This ensures you and your employees get the most up-to-date information and techniques for success. And, because our video development is in-house, we can adapt quickly and create custom content for a more exclusive approach to software and computer system roll-outs. Check out all Intellezy has to offer with our award-winning video content.

What's inside

Learning objectives

Modify sharepoint list forms work with formulas
Review advanced features of infopath

How to share, embed, and export your app

Modify sharepoint list forms work with formulas
Review advanced features of infopath
How to share, embed, and export your app

Syllabus

Introduction

Getting Started with PowerApps

Introduction to PowerApps

Exploring the PowerApp Studio

Canvas Vs Model-Driven Apps

Creating Forms for a SharePoint List

Creating a PowerApp Using Data

Creating a PowerApp from a Template

Creating a Blank PowerApp

Editing a PowerApp or SharePoint Form

Saving and Publishing a PowerApp

Modifying SharePoint List Forms Using PowerApps

Modifying a SharePoint List Form in PowerApps

Modifying the Form Object

Reordering Fields

Hiding Fields

Adding a Label

Adding an Image

Changing the Background Fill or Image

Setting Default Values

Using the App Checker

Introduction to PowerApp Formulas

Introduction to Power Formula

Unlocking a Control to Alter Properties

Inheritence and References in Properties and Formulas

Using Date Functions

Using Text Functions

Using Table Functions

Using Action Functions

Using the If Function

Concatenating Text Strings

Using the Set Function

Using the Collect Function

Using the Visible Property

Using the ThisItem Property

Using the Default and DefaultDate Properties

Working with PowerApps

Changing App Name and Icon

Changing Screen Size and Orientation

Turning on Advanced Settings

Working with Screens

Working with Data Sources

Filtering Data Sources in PowerApps

Creating Navigation Between Screens

Adding and Modifying a Gallery

Adding and Modifying a Table

Adding and Modifying a Form

Adding and Modifying Labels and Buttons

Adding and Modifying Controls

Adding and Modifying Media

Adding and Modifying Icons

Distributing your PowerApp

Sharing your PowerApp

Embedding a PowerApp on a SharePoint Site

Embedding a PowerApp on Other Web Pages

Exporting and Importing a Package

Conclusion

Course Recap

Final Assessment Quiz - Microsoft 365 PowerApps

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Covers PowerApps, which is part of the Microsoft 365 suite, making it highly relevant for organizations already invested in the Microsoft ecosystem

Explores modifying SharePoint List Forms using PowerApps, which is useful for streamlining data collection and workflow automation within SharePoint environments

Reviews advanced features of InfoPath, which can help those migrating from InfoPath to PowerApps understand the evolution and differences between the two tools

Teaches how to share, embed, and export PowerApps, enabling users to distribute their applications across various platforms and integrate them into existing workflows

Focuses on PowerApp formulas, which are essential for creating dynamic and interactive applications, and unlocks a control to alter properties, which is useful for customization

Requires access to Microsoft 365 and SharePoint, which may be a barrier for learners who do not have a subscription or access to these platforms

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 Microsoft 365 PowerApps with these activities:

Review SharePoint Lists

Show steps

Reviewing SharePoint Lists will help you understand the data source that PowerApps often uses, making it easier to modify forms and work with data within PowerApps.

Browse courses on SharePoint Lists

Show steps

Review the structure of SharePoint Lists, including columns and data types.
Practice creating and modifying SharePoint Lists.
Familiarize yourself with different types of SharePoint List columns.

Review 'Beginning PowerApps'

Show steps

Reviewing this book will provide a solid foundation in PowerApps concepts and techniques, helping you to better understand the course material.

View Putting Knowledge to Work on Amazon

Show steps

Read the introductory chapters to understand the basics of PowerApps.
Focus on chapters that cover topics you find challenging.
Try out the examples and exercises in the book.

Read 'Microsoft PowerApps Cookbook'

Show steps

Reading this book will provide practical examples and solutions to common PowerApps challenges, enhancing your ability to build and customize apps effectively.

View Putting Knowledge to Work on Amazon

Show steps

Select recipes relevant to your PowerApps projects.
Follow the step-by-step instructions to implement the recipes.
Adapt the recipes to fit your specific needs.

Four other activities

Expand to see all activities and additional details

Show all seven activities

Practice Power Fx Formulas

Show steps

Practicing Power Fx formulas will solidify your understanding of how to manipulate data and control app behavior, which is crucial for creating dynamic and interactive PowerApps.

Show steps

Create simple PowerApps with basic formulas.
Experiment with different functions and operators.
Debug and troubleshoot formula errors.

Build a Simple Inventory App

Show steps

Building a real-world app will allow you to apply your PowerApps skills in a practical context, solidifying your understanding of the entire development process.

Show steps

Design the app's user interface and data structure.
Implement the app's functionality using Power Fx formulas.
Test and refine the app based on user feedback.

Create a PowerApps Tutorial

Show steps

Creating a tutorial will force you to deeply understand a specific PowerApps concept and explain it clearly to others, reinforcing your own learning.

Show steps

Choose a specific PowerApps topic to focus on.
Create a step-by-step guide with screenshots and explanations.
Share your tutorial with others and gather feedback.

Create a Data Visualization Dashboard

Show steps

Creating a data visualization dashboard will allow you to practice connecting PowerApps to various data sources and presenting data in a meaningful way.

Show steps

Identify a relevant dataset to visualize.
Design the dashboard layout and choose appropriate charts and graphs.
Connect PowerApps to the data source and implement the visualizations.

Career center

Learners who complete Microsoft 365 PowerApps will develop knowledge and skills that may be useful to these careers:

SharePoint Administrator

A SharePoint Administrator manages and maintains SharePoint environments. This course on Microsoft 365 PowerApps is directly relevant as it teaches how to create and customize forms within SharePoint. The course’s focus on modifying SharePoint List Forms using PowerApps, along with manipulating data and distribution of apps is specifically pertinent to this role. A SharePoint Administrator needs to develop and manage applications, so the course's coverage of PowerApp formulas, working with data sources, and distributing apps are highly relevant. The skills learned in this course will enable a SharePoint Administrator to better manage the SharePoint platform.

See salaries and explore the career path for SharePoint Administrator

Application Developer

An Application Developer designs, builds, and maintains software applications. This course on Microsoft 365 PowerApps directly supports the development of custom business applications. The course content on creating forms, working with data sources, and using formulas directly translates to skills used in application development. By learning how to modify SharePoint List Forms and distribute PowerApps, a future Application Developer builds a foundation for creating tailored solutions, which is very beneficial for an organization. This course helps one to understand how to create and manipulate applications, which is core to this field.

See salaries and explore the career path for Application Developer

Solutions Architect

A Solutions Architect designs and oversees the implementation of IT solutions. The knowledge of creating and deploying custom applications using Microsoft 365 PowerApps, gained in this course, helps with designing solutions. The skills taught here, such as modifying SharePoint List Forms, working with data sources, and using PowerApp formulas, are necessary in building custom solution. This course also reviews how to distribute a PowerApp, including sharing, embedding, and exporting options, which is highly relevant. The ability to create a solution architecture is built upon the ability to develop applications, which this course will help with.

See salaries and explore the career path for Solutions Architect

Business Analyst

A Business Analyst identifies business needs and translates them into technical requirements. The ability to create custom applications and forms using PowerApps, learned in this course, directly applies to gathering and managing data for analysis. The course covers how to modify SharePoint List Forms, work with data sources, and create user interfaces, all of which are essential for a Business Analyst to create efficient business solutions. By understanding how the application creation process works, a Business Analyst can better communicate with technical teams to implement changes. The course also highlights practical skills like using PowerApp formulas and distributing apps that are useful for a Business Analyst.

See salaries and explore the career path for Business Analyst

Data Analyst

A Data Analyst interprets data to identify trends and insights. This course enhances those skills by providing a method for developing custom forms that assist in data collection and organization. The skills to modify SharePoint List Forms using PowerApps, work with data sources, and the use of PowerApp formulas taught in this course are directly relevant to improving data processes. The data analyst will also be able to create front end data collection tools for others. Learning how to filter data sources and create user interfaces are also very beneficial when working with data. Through this course, a Data Analyst learns how to develop applications that streamline data handling.

See salaries and explore the career path for Data Analyst

Software Trainer

A Software Trainer provides instruction and guidance on using software. The ability to use Microsoft 365 PowerApps to create applications will help a Software Trainer teach the toolset to others. The skills learned in this course, such as modifying SharePoint List Forms, working with data sources, and using PowerApp formulas, can be used to create example applications, which is highly relevant to the work of a Software Trainer. Knowing the process of sharing, embedding, and exporting a PowerApp will be useful for training end users. This course may be useful for a Software Trainer to help understand the features that they teach.

See salaries and explore the career path for Software Trainer

Systems Analyst

A Systems Analyst researches and recommends changes to computer systems for business needs. The skills taught in this course on Microsoft 365 PowerApps are useful to the Systems Analyst, as they enable creating custom data collection and display applications. The course’s focus on modifying SharePoint List Forms using PowerApps, working with data sources, and using PowerApp formulas directly supports the development of customized systems. The ability to share, embed, and export a PowerApp can help in the distribution of new system tools. This course can be useful when evaluating a system change.

See salaries and explore the career path for Systems Analyst

Technical Trainer

A Technical Trainer develops and delivers training programs for technical topics. This course is an appropriate choice for a Technical Trainer who plans to teach others how to use Microsoft 365 PowerApps. The course’s focus on modifying SharePoint List Forms using PowerApps, along with manipulating data, formulas, and app distribution is highly relevant. The Technical Trainer may find it helpful to learn how to create the apps themselves. Understanding the various functionalities of PowerApps enables technical trainers to better teach others how to use it.

See salaries and explore the career path for Technical Trainer

Project Manager

A Project Manager oversees project planning, execution, and completion. Though a Project Manager may not develop applications themselves, the ability to create custom forms and applications using PowerApps, as taught in this course, provides value in understanding the technical work being done. A Project Manager will be able to create tools for managing projects and gathering data. The course’s focus on modifying SharePoint List Forms using PowerApps, along with working with data sources and app distribution, is valuable for organizing team workflows. This knowledge helps the Project Manager manage projects more effectively.

See salaries and explore the career path for Project Manager

Database Administrator

A Database Administrator manages and maintains databases. Although this course does not teach specific database administration, the skills in PowerApps that are taught in the course will help a database administrator to create forms for managing databases. Learning how to modify SharePoint List Forms using PowerApps, how to work with data sources, and use PowerApp formulas will improve the ability of a database administrator to work with data. The skills learned here will help a Database Administrator to build applications connected to databases. The ability to share, embed, and export a PowerApp taught in this course enables an administrator to share their work.

See salaries and explore the career path for Database Administrator

Technology Consultant

A Technology Consultant advises organizations on how to use technology to meet their business goals. The ability to create custom applications using Microsoft 365 PowerApps, as taught in this course, will help a Technology Consultant provide organizations with useful solutions. The course's focus on modifying SharePoint List Forms using PowerApps along with working with data sources and using PowerApp formulas will help with creating tailor-made technology solutions. The PowerApps skills, such as sharing, embedding and exporting applications, will improve the communication of the technology consultant’s solutions. This course may be useful for a technology consultant looking to expand their knowledge of Microsoft 365 applications.

See salaries and explore the career path for Technology Consultant

IT Support Specialist

An IT Support Specialist provides technical assistance and troubleshooting to end-users. The course on Microsoft 365 PowerApps helps the IT Support Specialist gain an understanding of custom application development. Specifically, the ability to modify SharePoint List Forms using PowerApps, work with data sources, and the use of PowerApp formulas as covered in the course, can help in creating user solutions. In particular, understanding the process of sharing and exporting applications can help in the distribution of technical support tools. An IT Support Specialist may find this course helpful as it can help expand their knowledge of tools available within the Microsoft 365 suite.

See salaries and explore the career path for IT Support Specialist

Process Improvement Specialist

A Process Improvement Specialist identifies areas of improvement and implements solutions to increase efficiency. Using PowerApps as taught in this course, a process improvement specialist will be able to create custom tools to streamline data collection and process management. The course covers how to modify SharePoint List Forms, work with data sources, and use PowerApp formulas, all of which are valuable for creating impactful business solutions. The ability to share, embed, and export capabilities is useful for process management. This course may help create a strong foundation in developing applications for process improvements.

See salaries and explore the career path for Process Improvement Specialist

Information Architect

An Information Architect designs and organizes information systems to enhance usability. The knowledge of creating custom forms and applications using Microsoft 365 PowerApps can help an Information Architect design systems that are useful for data collection and display. The course's focus on modifying SharePoint List Forms, working with data sources, and using PowerApp formulas, will contribute to the ability to organize and manage information. The capabilities of sharing, embedding, and exporting apps is also relevant to designing and implementing improved systems. This course may be useful for expanding the skill set of an Information Architect.

See salaries and explore the career path for Information Architect

Data Entry Clerk

A Data Entry Clerk is responsible for inputting and updating data. This course may be helpful as it teaches how to create custom forms that help with data collection. The ability to modify SharePoint List Forms using PowerApps and work with data sources is directly applicable to a Data Entry Clerk's work. Learning how to use PowerApp formulas may also be helpful. Through learning the PowerApps tool, a Data Entry Clerk can better understand the tools used for data collection and management. This course may be useful in understanding ways to streamline data collection processes.

See salaries and explore the career path for Data Entry Clerk

Microsoft 365 PowerApps

What's inside

Learning objectives

Syllabus

Good to know

Save this course

Activities

Career center

Reading list

Share

Similar courses