Power Apps Canvas Key Functions for Beginners


Getting Started



Common Expressions to Know First

ProblemExpression
Show the current logged in user

The User Function Examples

 
User().Email - Shows email address
User().FullName - Shows user's name
User().Image - Shows user's photo
                        
                        
Filter the rows to a certain criteria

The Filter expression can filter the rows based on an expression of your choosing.


Filter(DataSource, Expresssion)
Filter( DataSourceName, Column > 0 )
Filter( DataSourceName, Column > 0, Column2 = "Value" )

                        
Lookup a value in another table or source

The lookup function can see the value from a different source based on an expression.


Lookup(Source, Condition, ValueToShow)
Lookup(DataSourceName, CustomerID = 5, CustomerName)

                             
                        
Create a Global Variable

Global variables can be seen on any screen. They can be created when you start an app by selecting the App OnStart event or on any actionable event.


Set(VariableName, value)
                            
                        
Send data from a form to the source.

A few ways to send data from a form are SubmitForm or the Patch commands. The SubmitForm is easiest with he smallest amount of flexibility.

 
    SubmitForm(FormName)
                            
                        
Searching multiple columns for a row

The Search command does a contains search across multiple columns and is usually used in galleries or data tables.


Search(DataSource, SearchString, Column1 [, Column2, ... ] )
Search(DataSource, txtInput.Text, "FirstName", "LastName")