Master Microsoft Power Apps Table functions from Udemy

What's inside

Learning objectives

Basic table and database concepts in power apps (record, table, arrays, collection and variables)
Mass insert, delete and update and detailed analysis about available functions in power apps and how to use the efficiently
Working with loops and sequence to process the table items separately
Bridge between behavior and non-behavior functions
Condition and alternative options to if and switch
Changing table schema to make it fit our solution
Bulk insert of record to a table/list instead of processing them one-by-one
Working with fields that contain complex data

Effect of internal field names and title on the way you use table functions
Difference between search, filter and lookup and where to use each one of them
Chose between sort and sortbycolumns to effectively reorder records
Powerapps aggregate functions
Counting rows using count, counta, countif and countrows. which one to use?
Grouping records and removing duplicated records
Show more
Show less

Basic table and database concepts in power apps (record, table, arrays, collection and variables)
Mass insert, delete and update and detailed analysis about available functions in power apps and how to use the efficiently
Working with loops and sequence to process the table items separately
Bridge between behavior and non-behavior functions
Condition and alternative options to if and switch
Changing table schema to make it fit our solution
Bulk insert of record to a table/list instead of processing them one-by-one
Working with fields that contain complex data
Effect of internal field names and title on the way you use table functions
Difference between search, filter and lookup and where to use each one of them
Chose between sort and sortbycolumns to effectively reorder records
Powerapps aggregate functions
Counting rows using count, counta, countif and countrows. which one to use?
Grouping records and removing duplicated records
Show more
Show less

Syllabus

Introduction

Course structure and content

PowerApps formula basics

Behavior formula vs non-behavior formula

Using variables to bridge between behavior and non-behavior properties

Working with PowerApps records

Understanding and working with "Context"

Tables and Arrays in PowerApps

Loops in PowerApps - ForAll

Working with PowerApps conditions - "If" and "Switch"

If ... beyond just a formula

JSON the black sheep

Table Table Functions - Project 1

This is how it started

Building the UI in PowerApps

Unleash the power of Collect function in PowerApps

Collection or Table variable... which one to use

The right way to calculate subtotal

Understanding "Remove" and "RemoveIf"

Quick fix to "Remove" function - Test your knowledge

Deleting an item from a gallery with confirmation dialog

Creating lists for Project 1

Layers of "Collect" function

Adding one table to another table using "Collect"

Using JSON as our silver bullet to discover complex data formats

Adding Order to SharePoint and capturing newly inserted item in PowerApps

Using collect to insert all order items in one line of code (and some surprises)

How to get internal field name in a SharePoint list?

Be careful... things are not as simple as you may think

Table Table Functions - Project 2

A project with focus on search

Filter, Search and LookUp

Search, Filter and Lookup in action - Part 1

Select, Filter and Lookup in action - Part 2

More essential table functions - Project 3

Using Distinct function to create combo box filters

Adding extra item manually to "Distinct" result

Sorting records like a pro

How to effectively use SortByColumn

Calculating average and sum in a data table

A task management App with Dataverse - Project 4

Counting records is more important than sum and average

Adding task to Dataverse using "Edit form"

Patching and updating Dataverse choice column

Difference between PowerApps count functions (Count, CountA, CountRows, CountIf)

Count vs CountA (Easy yet very important)

Phase 2 of project 3 - Project 5

This is where we need Patch function

Patch can also create a new record, just like collect

Patching complex data types

Patch or UpdateIf?

We have extra budget from project 3 - Project 6

Let's make data summary better in our app

Understanding GroupBy

Using GroupBy in a "not-so-easy" situation and how to make it easy

Edit data in a PowerApps grid - Project 7

The project was very easy... at least in the beginning

Enable auto save on a PowerApps gallery

Adding save and undo buttons to every row in PowerApps gallery

Single save button to save all changes in a PowerApps gallery

Highlight the changed rows in a Gallery

Let's finish this course

Important - Review on what we learned

The elephant in the room - The biggest missing part in this course

Get your next course for free

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Focuses on practical field problems, which helps developers connect theoretical knowledge with real-world application and build apps that effectively address specific scenarios

Explores the nuances between similar functions like Search, Filter, and Lookup, which allows developers to make informed decisions about which function to use in different situations

Covers advanced topics such as changing table schema and working with complex data, which enables developers to handle more sophisticated data manipulation tasks within Power Apps

Requires familiarity with PowerApps formula basics, which may necessitate that beginners first acquire foundational knowledge before taking this course

Teaches techniques for bulk data operations, which can significantly improve the performance and efficiency of Power Apps when dealing with large datasets

Uses JSON to discover complex data formats, which may require learners to have some familiarity with JSON and data structures

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 Master Microsoft Power Apps Table functions with these activities:

Review Power Apps Basics

Show steps

Reinforce your understanding of fundamental Power Apps concepts, including the Power Apps interface, basic controls, and data connections, to ensure a solid foundation for mastering table functions.

Browse courses on Power Apps

Show steps

Review the Power Apps interface and key components.
Practice creating simple apps with basic controls.
Revisit data connection basics and experiment with different data sources.

Review Power Apps Basics

Show steps

Solidify your understanding of Power Apps fundamentals, including the interface, data connections, and basic formulas, to prepare for the course's advanced table functions.

Browse courses on Power Apps

Show steps

Review the Power Apps interface and navigation.
Practice connecting to different data sources.
Revisit basic formula syntax and common functions.

Practice Table Manipulation with Sample Data

Show steps

Reinforce your understanding of Power Apps table functions by working through practical exercises with sample data sets.

Show steps

Create sample data tables in Power Apps.
Practice using Collect, Filter, Lookup, and other table functions to manipulate the data.
Experiment with different scenarios and data types.

Four other activities

Expand to see all activities and additional details

Show all seven activities

Document Common Table Function Use Cases

Show steps

Deepen your understanding of Power Apps table functions by creating documentation that explains common use cases and provides examples.

Show steps

Identify common scenarios where table functions are used.
Write clear and concise explanations of how to use each function in those scenarios.
Provide example formulas and screenshots to illustrate the concepts.

Build a Simple Inventory Management App

Show steps

Apply your knowledge of Power Apps table functions to build a real-world application that manages inventory data.

Browse courses on Inventory Management

Show steps

Design the user interface for the inventory management app.
Connect the app to a data source (e.g., Dataverse, SharePoint).
Implement table functions to add, update, and delete inventory items.
Add search and filtering capabilities to the app.

Read 'Microsoft Power Platform Enterprise Architecture: Architecting solutions with Power Apps, Power Automate, and Power BI'

Show steps

Gain a broader understanding of Power Apps within the Microsoft Power Platform ecosystem and learn about enterprise architecture considerations.

View Putting Knowledge to Work on Amazon

Show steps

Read the book and take notes on key concepts and best practices.
Identify sections that are relevant to Power Apps table functions.
Reflect on how the concepts in the book can be applied to your Power Apps projects.

Create a Data Visualization Dashboard

Show steps

Build a Power BI dashboard that visualizes data from a Power Apps application, demonstrating the use of table functions to prepare and transform data for analysis.

Browse courses on Data Visualization

Show steps

Design the layout and key metrics for the dashboard.
Connect Power BI to the data source used by your Power Apps application.
Use Power BI's data transformation capabilities to prepare the data for visualization.
Create charts and graphs to visualize the key metrics.

Career center

Learners who complete Master Microsoft Power Apps Table functions will develop knowledge and skills that may be useful to these careers:

Applications Developer

An Applications Developer builds and maintains software applications. This role frequently involves working with databases and data manipulation, which this course on Microsoft Power Apps table functions directly addresses. Specifically, the course covers essential database concepts such as records, tables, arrays, and collections, and how to manipulate these within Power Apps. This includes mass data operations, working with complex data types, and changing table schemas. An Applications Developer needs to understand how to effectively use functions like Search, Filter, and Lookup, as well as sorting and grouping data; this course directly provides this knowledge. Developers often use loops and conditional logic, also covered in this course, to build sophisticated apps that process data efficiently. The practical project-based nature of this course is valuable as it provides real-world problem solving experience.

See salaries and explore the career path for Applications Developer

Business Intelligence Analyst

A Business Intelligence Analyst interprets data to improve business decision-making. This often requires working with data tables and creating visualizations from them. This course teaches fundamental concepts such as database tables, arrays, and collections within the context of Microsoft Power Apps, helping an analyst to source, shape and prepare data for analysis. Furthermore, the course's focus on using functions like Filter, Sort, and Lookup and aggregate functions is important for data extraction and manipulation. The course also covers grouping and removing duplicate records, which is useful for data cleaning. An analyst often builds reports from data; this course will make it easier for the analyst to obtain the data in the correct shape in order to use it effectively. The practical projects covered will help an analyst understand how to use Power Apps to source data efficiently.

See salaries and explore the career path for Business Intelligence Analyst

Data Analyst

A Data Analyst examines datasets to draw conclusions and report findings. The course on Power Apps table functions is a useful resource for a data analyst since it deeply explores database concepts such as records, tables, and arrays. The ability to perform mass inserts, deletes, and updates as taught in this course is a key skill. Additionally, this course teaches working with loops to process data, handling complex data, and using functions like Search, Filter, and Lookup, which are core to data extraction. Furthermore, the course includes instruction on effectively using aggregate functions, counting rows, and grouping; all of these are techniques that a data analyst uses every day. This course may be particularly helpful because it includes practical projects that demonstrate how to solve real-world problems using Power Apps table functions.

See salaries and explore the career path for Data Analyst

Report Developer

A Report Developer designs and builds reports that display data from various sources. This role generally requires a strong understanding of data structures and how to manipulate them. The Power Apps table functions course provides important skills for a Report Developer to source and prepare the underlying data that is used in the reports. This course provides experience in using database concepts such as records, tables, arrays, and collections. The practice of using functions such as Search, Filter, and Lookup, as well as the use of sorting and grouping are critical for effective reporting. The course also includes instruction on how to handle complex data and perform aggregate calculations, also important skills for a Report Developer. The practical projects may be valuable for the Report Developer to prepare them for building reports from Power Apps.

See salaries and explore the career path for Report Developer

Database Administrator

A Database Administrator manages and maintains databases, which involves tasks directly related to the content of this course. The course's focus on database concepts such as records, tables, arrays, collections, and variables provides a valuable foundation in database management. A Database Administrator must be able to perform mass inserts, deletes, and updates, manage table schema, handle complex data, and use functions like Filter, Sort, and Lookup to manage information. This course teaches all of these skills within the context of Power Apps. A Database Administrator may find useful the learning regarding the impact of internal field names and titles on the way table functions are used. This course provides practical experience through projects that directly apply to real-world database management scenarios. While this role often requires an advanced degree, the practical skills learned can be useful.

See salaries and explore the career path for Database Administrator

Citizen Developer

A Citizen Developer is someone who builds applications using low-code platforms. This course on Power Apps table functions directly relevant for the Citizen Developer who needs to use Power Apps to create data-driven business solutions. This course teaches the fundamentals of using records, tables, arrays, collections, and variables. Further, the course also teaches mass insert, update and delete operations, manipulating complex data, and using essential functions like Search, Filter, and Lookup; all of which are necessary for building robust applications for real-world scenarios. This course helps the Citizen Developer understand how to use loops and conditional logic to create complex business logic. By learning to work effectively with data tables, the Citizen Developer will be able to create effective applications that solve business problems.

See salaries and explore the career path for Citizen Developer

Solutions Architect

A Solutions Architect designs the architecture of complex systems. Effective use of data is critical to architecting performant and maintainable solutions. This course on Microsoft Power Apps table functions provides important expertise for a Solutions Architect who plans to integrate Power Apps into their systems. They will need a good understanding of working with database concepts such as records, tables, arrays, collections, and variables. This course provides experience with building with these concepts, and an understanding of how to perform mass operations, manipulate schemas, manage complex data types, and use comparison and aggregation functions. This course also provides a practical understanding of how to use loops, conditions and table functions; skills which the architect can use to make appropriate system design decisions. By building a deep understanding of data handling within Power Apps, a Solutions Architect can architect systems that work effectively with Power Apps.

See salaries and explore the career path for Solutions Architect

Data Engineer

A Data Engineer builds and maintains scalable data systems. This role requires an understanding of data structures, data transformation, and data manipulation, all of which are taught in this course on Power Apps table functions. Specifically, the course explores crucial database concepts such as records, tables, arrays, and collections. A Data Engineer needs a good understanding of mass operations, advanced data manipulation such as working with complex data fields, changing table schemas, and using functions like Search, Filter and Lookup. The course's instruction on table manipulation, sorting, grouping, and handling duplicates will also be helpful in the process of data transformation and management. Data engineers need to use loops and conditional logic, also covered in this course. The practical projects included in this course may be useful to a data engineer in understanding and implementing effective data solutions.

See salaries and explore the career path for Data Engineer

Process Automation Specialist

A Process Automation Specialist automates business processes, often using low-code platforms, such as Power Apps. This course on Power Apps table functions may be valuable as many of the business processes that are automated using Power Apps involve working with data and data tables. This course introduces database table concepts like records, tables, arrays, variables and collections, which are crucial for understanding the structure of the data used in Power Apps. Furthermore, the course covers key functions for managing data such as mass insert, delete and update, and working with complex data types. The course provides a good grounding in table functions such as Search, Filter, and LookUp, as well as sorting and grouping operations. The course's emphasis on practical projects in the context of real-world scenarios makes this learning even more useful.

See salaries and explore the career path for Process Automation Specialist

Systems Analyst

A Systems Analyst examines business problems and designs technical solutions. This course on Power Apps table functions may be helpful to a Systems Analyst, especially if their solutions involve handling data. The course dives into important database concepts such as records, tables, arrays, collections, and variables, which are foundational in any system that manages data. The course teaches mass insert, delete, and update operations, and how to manipulate complex data. The course covers functions including Search, Filter, and Lookup, sorting and grouping data, and conditional logic, all of which a Systems Analyst may need to consider when planning a system. The learning provided in this course about practical application of table functions might be helpful to a Systems Analyst.

See salaries and explore the career path for Systems Analyst

Technical Consultant

A Technical Consultant provides expertise on technical solutions to clients. Often, this involves configuring or customizing software to meet business needs and may require working with data. This course regarding Power Apps table functions is directly relevant to a Technical Consultant involved in implementing Power Apps. The course may be helpful in understanding the basics of records, tables, arrays, collections and variables within Power Apps. The course's instruction on mass insert, delete and update operations, and how to manipulate complex data is valuable for a consultant. A consultant may also use the functions Search, Filter, and Lookup, as well as grouping and sorting. Consultants will also require an understanding of the different methods of data manipulation. This course's practical applications can assist a Technical Consultant to effectively advise on the implementation of Power Apps solutions.

See salaries and explore the career path for Technical Consultant

Project Manager

A Project Manager is responsible for planning and executing projects. While this role doesn't directly interact with databases, basic data literacy and an understanding of business processes can improve a project manager's ability to communicate with their team. This course provides an understanding of how data manipulation can be achieved using the Power Apps platform, and how this might fit into a business process. The project manager will benefit from an understanding of how to work with database concepts such as records, tables, and arrays. This course may be useful in understanding options for data management, and for understanding basic concepts in data manipulation, such as mass insert, delete, and update. Though not directly applicable to day-to-day tasks, this course may help the Project Manager understand the technical work of team members.

See salaries and explore the career path for Project Manager

Technical Writer

A Technical Writer creates documentation and guides for software and other technical products. While a technical writer may not directly use Power Apps, a working knowledge can be useful for creating accurate documentation. This course may be helpful as it provides a good overview of database table concepts, such as records, tables, arrays, collections, and variables. It also provides insight into the practical application of these concepts. The course covers essential data handling functions within Power Apps. This course will provide a technical writer with a foundation for documenting the data handling capabilities of Power Apps. This course may be useful for a technical writer aiming to gain hands-on experience and a practical working knowledge of Power Apps.

See salaries and explore the career path for Technical Writer

Quality Assurance Tester

A Quality Assurance Tester is responsible for testing software applications to ensure they meet quality standards. The Power Apps table functions course may be useful for gaining an understanding of software and data manipulation concepts. The tester, who might be exposed to the Power Apps platform, can benefit from an understanding of basic database concepts such as records, tables, arrays, and collections. The course can help a tester understand the kind of functions used to manipulate data in Power Apps, such as mass insert, delete and update operations, and functions like Filter, Sort, and Lookup. They will also gain insight into how table functions work. This course may be especially helpful for a tester who needs to test features related to data manipulation.

See salaries and explore the career path for Quality Assurance Tester

Sales Representative

A Sales Representative sells products or services to clients. This role generally does not involve direct data manipulation. However, with increasing amounts of business data being made available, a general awareness of how data is organized, manipulated, and presented, can be useful. This course provides an introduction to database concepts such as records, tables, arrays, collections, and variables. It also provides an overview of functions used to manipulate and analyze data. This course may be useful to a Sales Representative who seeks to understand the technical side of the products or services they are selling. While not directly related to their core responsibilities, this course may be useful to gain a broader understanding of the technology.

See salaries and explore the career path for Sales Representative

Reading list

We've selected one books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in Master Microsoft Power Apps Table functions.

Putting Knowledge to Work

Save

Provides a comprehensive overview of the Microsoft Power Platform, including Power Apps, Power Automate, and Power BI. It covers enterprise architecture considerations, governance, and best practices for building scalable and maintainable solutions. While not solely focused on table functions, it provides valuable context for understanding how Power Apps fits into a larger enterprise environment. It is useful as additional reading to provide breadth to the existing course.

Putting Knowledge to Work

Paperback

Check price

Putting Knowledge to Work

Kindle Edition

Check price

Master Microsoft Power Apps Table functions

What's inside

Learning objectives

Syllabus

Good to know

Save this course

Activities

Career center

Reading list

Share

Similar courses