🚀..Here are the top 10 mandatory Power Apps formulas that everyone should learn:
✅ 1. Patch() – Create or Update Records
Purpose: Used to create, modify, or update records in a data source like SharePoint, Dataverse, etc.
Example:
Patch(
DataSource,
Defaults(DataSource),
{Title: "New Record", Status: "Open"}
)
✅ 2. Filter() – Filter Records Based on Condition
Purpose: Filters a set of records based on certain conditions.
Example:
Filter(
DataSource,
Status = "Open"
)
✅ 3. Lookup() – Find a Single Record
Purpose: Returns the first record that meets a certain condition.
Example:
Lookup(
DataSource,
ID = 123
)
✅ 4. Collect() – Add Records to a Collection
Purpose: Adds data to a temporary collection in Power Apps.
Example:
Collect(
CollectionName,
{Name: "John", Age: 30}
)
✅ 5. ClearCollect() – Clear and Collect Data
Purpose: Clears the existing data in a collection and then adds new data.
Example:
ClearCollect(
CollectionName,
DataSource
)
✅ 6. Set() – Create Global Variable
Purpose: Defines a global variable that can be used across screens.
Example:
Set(
varUserName,
"John Doe"
)
✅ 7. UpdateContext() – Create Local Variable
Purpose: Creates or updates a context variable for a single screen.
Example:
UpdateContext(
{varShowPopup: true}
)
✅ 8. Navigate() – Navigate Between Screens
Purpose: Used to navigate between different screens in an app.
Example:
Navigate(
Screen2,
ScreenTransition.Fade
)
✅ 9. Sort() – Sort Records
Purpose: Sorts records in ascending or descending order.
Example:
Sort(
DataSource,
Title,
Ascending )
✅ 10. If() – Conditional Logic
Purpose: Performs actions based on conditions (like IF-ELSE).
Example:
If(
Age > 18,
"Adult",
"Minor"
)
💯 Why These Formulas Are Mandatory:
They are the most commonly used in Power Apps development.
Useful for data manipulation, navigation, collections, and user interface control.
Without these, it’s hard to build functional and dynamic apps.
Comments