Announcements
Hi I'm Having a list with checkbox column called apptype which are having values as SharePoint,Power Platform,LiveTiles,Nintex
so i want to use groupby and get the list of apps based on apptype for that i want to use groupby
Hi @Krishna98 ,
I wonder you could use GroupBy on a choice filed in SharePoint! group by always works with a single line of text of a single value column field. Please change the list schema with a single line of text and then use the below:
ClearCollect(collApplications, GroupBy(SPList,"apptype"))
Hi @KrishnaV
It didn't worked actually
Did you change the column to a single line of text?
Sorry i forget to mention that, the requirement is that we shouldn't change the type of column of the list. since the enduser will feel uncomfortable while filling the data into the list
Then it is not possible to group on a choice field that is the limitation with the groupby function.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 541
WarrenBelz 434 Most Valuable Professional
Valantis 289