PowerFx Cheat Sheet for Power Apps Canvas Apps

Introduction:

Welcome to the PowerFx Cheat Sheet! PowerFx is the powerful formula language behind Power Apps that enables you to create dynamic and interactive canvas apps effortlessly. This cheat sheet will serve as your quick reference guide to some of the most essential PowerFx formulas and functions you'll need to build incredible canvas apps. Let's dive in!

1.Basic Functions

• Text: Concatenate, Len, Left, Right, Mid
• Numbers: Sum, Average, Min, Max
• Logical: If, And, Or, Not
• Dates and Times: Today, Now, AddDays, AddHours, TimeZoneOffset

2.Datasource Functions

• Collect: Create a collection
• ClearCollect: Clear and recreate a collection
• Filter: Filter data in a collection
• Lookup: Retrieve a single record from a data source
• Search: Find records containing a specific value
• Sort: Sort records in a collection

3.Gallery Functions:

• Gallery: Display data in a gallery
• ForAll: Iterate through a collection
• Add, Update, Remove: Modify collection data
• Navigate: Move between screens
• ShowError: Display error messages

4.Input Controls:

• TextInput: Capture text input from users
• ComboBox: Dropdown selection
• Slider: Range selection
• Toggle: On/Off control
• Checkbox: True/False selection
• Date picker: Select dates

5.Variables and Context:

• Set: Assign a value to a variable
• UpdateContext: Modify the context variable
• Navigate: Passing context between screens
• Context-related functions: Parent, ThisItem, ThisRecord

6.Formulas for User Interaction:

Notify: Display in-app notifications

Confirmation: Prompt for user confirmation

Input: Request user input

Launch: Open URLs, apps, or emails

7.Integration and Advanced Functions:

Office 365 connectors: Office365Outlook, Office365Users

SharePoint connectors: ClearCollect, Patch, Delete

Power Automate integration: Run, Launch, PowerAutomateButton

Conclusion:

You now have a handy PowerFx Cheat Sheet at your disposal! As you build canvas apps with Power Apps, refer to this guide for quick access to the most common formulas and functions. Don't forget to explore the PowerFx documentation for even more powerful capabilities.

Remember, practice is key to mastering any language. Experiment with different scenarios and unleash the true potential of PowerFx in creating dynamic and engaging canvas apps. Happy app-building!