Advanced formula in a canvas app in Power Apps

April 8, 2020

Advanced formula in a canvas app in Power Apps: Do you have need for a complex formula in your app? This module can help you author that formula.

In this module, you will:

  • Utilize formulas that process multiple records
  • Use the Concat function to combine text from multiple records
  • Utilize the Countrows, CountIf, ForAll
  • Perform math operations on data in a table

Advanced formula in a canvas app in Power Apps : Throughout other Power Apps learning paths, you have been focused on using formulas to manipulate single records. That is a great way to get started with Power Apps. As you build more complex apps, it is often necessary to process and work with multiple records in one formula. Throughout this module, the focus will be on learning some of the more common functions that are used to work with tables, records, and collections. To keep the rest of this module straight forward, the content will refer to tables and records. Tables are a data set that is made up of one or more columns with one or more rows of data. A record is the name used to refer to the individual rows in the table. Tables can be manually created using the Table function or come from a tabular data source. Collections are a special kind of variable that stores a table. Throughout this module, table and collection are synonymous. This means that any function you can use on a table of data , you can use on a collection.

Building apps with Power Apps helps everyone from business analysts to professional developers work more efficiently together. Solve business problems with intuitive visual tools that don’t require code, work faster with a platform that enables data integration and distribution, and extend the platform with building blocks for professional developers. Easily build and share apps on any device.

Prerequisites

A basic understanding of how to create a canvas app in Power Apps.

Course Information

Estimated Time: 2 Days

Categories:

Course Instructor

Author

Buy Now

Buy Now

Multiple records

Math operation on tables

Records

ForAll Function

Summary

Summary

Course Information

Estimated Time: 2 Days

Difficulty: Intermediate

Categories:

Skip to toolbar