Essam Shaaban - Power Platform Blog

Creating a row number sequence within a Power Apps gallery is a powerful technique. It ensures consistent numbering even when items are dynamically added or removed. Let’s dive into the details: 1.  Set Up Your Data Source: Before creating the gallery, ensure you have a data source (such as a SharePoint list, Excel table, or custom collection) that contains the items you want to display. Each item should have a unique identifier (e.g., an “ID” field). 2.  Create a Custom Collection for Numbering: We’ll create a custom collection to store the numbered items. Here’s how: Set the screen’s OnVisible property : Clear(colNumberedItems); // colNumberedItems is a custom collection  ForAll(yourDataSource, Collect(colNumberedItems, Last(FirstN(AddColumns(yourDataSource, "RowNumber", CountRows(colNumberedItems) + 1), CountRows(colNumberedItems) + 1) ) ) ) Replace  yourDataSource  with the name of your...

Power Apps - Patch, Update and Collect In the realm of programming, versatility is key. Just as there are numerous ways to accomplish tasks in any proficient programming language, Power Apps offers multiple avenues for data manipulation. With various functions at our disposal, such as Patch, Update, and Collect, it's crucial to understand their strengths and nuances to make informed decisions. Let's explore these functions in detail and demystify their applications. Understanding Data Manipulation Power Apps, aligned with the Power Platform's endorsement of Power FX, provides developers with a plethora of options for data manipulation. Primarily focused on data sources and collections, these functions offer flexibility and adaptability. Here's a breakdown of the key functions: Patch : Modifies or creates records in data sources or collections. Update : Replaces records in data sources or collections. UpdateIf : Modifies records based on specified condit...

Power Apps, a part of the Microsoft Power Platform, empowers users to build custom business applications without the need for extensive coding knowledge. Among its many powerful functions, the Patch function stands out as a versatile tool for modifying data sources, such as SharePoint lists or databases. In this comprehensive guide, we'll delve into the intricacies of the Patch function, exploring its syntax, common use cases, and advanced techniques. Understanding the Patch Function The Patch function in Power Apps is used to modify or create records in a data source. Its syntax is as follows: Patch(DataSource, Defaults(DataSource), ChangeRecord1 [, ChangeRecord2, …]) DataSource : The data source to be modified. Defaults(DataSource) : A reference to the default values of the data source. ChangeRecord1, ChangeRecord2, … : One or more records containing the changes to be applied to the data source. Basic Examples Updating a Record: Patch(MyDataSource, LookUp(MyDataSource, ID = 1), {...