Skip to main content

Power Apps Group By function limitations

Its 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 columns.

Hope this helps!

Thanks,

Keyur


Labels:

Comments

Post a Comment

Popular posts from this blog

SharePoint Copilot Apps: What Developers Need to Know in 2026

SharePoint Copilot Apps and SPFx Development Microsoft has been pushing SharePoint beyond being simply a collaboration and document-management platform. SharePoint Copilot Apps introduce an interesting opportunity for developers to build AI-driven experiences. The question is changing from "How do I build an SPFx solution?" to "How do I build an SPFx solution that can participate in AI-driven experiences?" SharePoint Copilot Apps entered public preview in July 2026, with scenarios including approvals, incident triage, onboarding checklists, interactive data grids, forms, charts, and dashboards. 1. What Are SharePoint Copilot Apps? Traditionally, an SPFx solution lives primarily inside SharePoint. Users navigate to a SharePoint page and interact with the application. Traditional SPFx Model User | v...
Post a Comment
Read more

Business Data Connectivity

I came to a requirement wherein I was supposed to get data from an 3 rd party portal using API’s and then bring them to SharePoint server. The first approach that I finalized was just to make BDC solution that will get data from 3 rd party portal and will deploy it to SharePoint. How to Create BDC solution in SharePoint? I found below link that is having really great description about hot to create and deploy the BDC solution to SharePoint. http://www.c-sharpcorner.com/uploadfile/hung123/creating-business-data-connectivity-service-using-visual-studio-2010/ After creating an POC I came to know that BDC model cannot be deployed on Multi tenant farm. So what can be done next? After some amount of googling I came to know that we can create BDC solution using WCF services also. So I created a WCF service solution that acted as a wrapper that used to fetch data from the portal. We can them publish that service to IIS or Server and use the servic...
2 comments
Read more

SharePoint hosted apps with Angularjs

Wow.. I thought i won't be able to manage to write a blog this month. Hey guys today i am here with a something of that i have been planning since a long time. Some time back i tried to implement Angularjs with SharePoint. To be frank Angularjs is just awesome. You can have flawless feel while working with it. I don't know how will i manage to work with Angularjs in huge projects but i found it really really good to work with single page applications. Let's have a look to the classic definition of Angularjs that you find when you google for Angularjs. Angularjs "AngularJS is a structural framework for dynamic web apps. It lets you use HTML as your template language and lets you extend HTML's syntax to express your application's components clearly and succinctly. Angular's data binding and dependency injection eliminate much of the code you would otherwise have to write." SharePoint Apps SharePoint Apps, I personally found it more developer...
6 comments
Read more