I ts good to be back with some new learning that I recently did. Recently I was trying to generate a report to identify ideal time of the resource in my team. There I came to know an interesting thing about PowerApps GroupBy function. Before we discuss on the limitation, lets first look at syntax. GroupBy (Table, ColumnName1 [, ColumnName2, ... ], GroupColumnName) Table - Required. Table to be grouped. ColumnName(s) - Required. The column names in 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". Now, this Group By will work fine with text, number, date, Duration and other simple column types. However, these doesn’t work with Choices and lookup colum