It's good to be back with some new learning that I recently did. While trying to generate a report to identify the ideal time of the resource in my team, I came across an interesting aspect of the PowerApps GroupBy function.
Syntax of the GroupBy Function
Before discussing its limitations, let's first look at the syntax.
GroupBy(Table, ColumnName1 [, ColumnName2, ... ], GroupColumnName)
- Table: Required. The table to be grouped.
- ColumnName(s): Required. The column names in the table by which to group records. These columns become columns in the resulting table.
- GroupColumnName: Required. The column name for the storage of record data not in the ColumnName(s).
Note: For SharePoint and Excel data sources that contain column names with spaces, specify each space as "_x0020_". For example, specify "Column Name" as "Column_x0020_Name".
Functionality of GroupBy
The GroupBy function works well with text, number, date, duration, and other simple column types. However, it has some limitations when dealing with certain types of columns.
Limitations
Unfortunately, the GroupBy function does not work with Choices and Lookup columns. This is a significant limitation to keep in mind when designing your PowerApps applications.
Hope this helps!
For more updates, connect with me on LinkedIn