Cheatography
https://cheatography.com
A quick reference guide for Powerapps, with functions refrerence
This is a draft cheat sheet. It is a work in progress and is not finished yet.
DataSource Functions
Filter( Table,condition1[,condition2] ) |
Table: |
Datasource to search |
Condition(s): |
A logical Expresion |
Result: |
A table with all records in which all conditions are true |
Search( Table,SearchString,Column1[,Column2]) |
Table: |
Datasource to search |
SearchString |
String to search for within the table columns. If blank or empty all the table records will be returned. |
Column(s): |
Name of table columns. They must be between double quotes. |
Result: |
Records table with the SeachString |
LookUp( Table, Formula [, ReductionFormula ] ) |
Table: |
Datasource to search |
Condition: |
A logical expression or formula that evaluate each records in the table. Its result must be true or false |
ReductionFormula |
Formula to reduce founded record to a single value. Column references can be use it. |
Result: |
The first record that comply with the condition, or a single value if a reduction formula is used. |
Columns are like an array of same type values, many functions that applies to single values applies to columns too.
|
|
Records & Tables
A record |
Set of data (or fields) related to a person, an animal or a thing.
i.e. {name:"John";surname:"Doe";age:20} |
A table |
A set of records {name:"John";surname:"Doe";age:20};{name:"Richard";surname:"Miles";age:19} |
A table with a single value |
Table({name:"John"}) |
A table with one record |
Table({name:"John";surname:"Doe";age:20}) |
A table with one column |
Table({name:"John"};{name:"Richard"};{name:"Leonard"}) |
A table with one column (Square Bracket Definition) |
["John";"Richard";"Leonard"] |
A collection is an internal table datasource |
ClearCollecction(name;{name:"John";surname:"Doe";age:20};{name:"Richard";surname:"Miles";age:19}) |
External Datasource |
Column |
Is the reference to same field in one or more records. In a colum al the values are of the same data type |
Save Data
Patch(Datasource;Record;UdpateRecord) |
Update a Record in a Datasource or a Collection |
Patch(Datasource;Defaults(Datasource);RecordtoInsert) |
Insert a Record in a Datasource or a Collection |
Collect(Datasource;Collection) |
Insert a Collection in a Datasource. All column names in Collection must be defined in the Datasource. |
|
|
Functions
Concepts |
A function take one or many arguments and return a result.The functions applies to single values, columns, or tables. |
* Normally when applies to a single value i.e Lower either applies to a column
|
