Notifications
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.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 717 Most Valuable Professional
Michael E. Gernaey 329 Super User 2025 Season 2
Power Platform 1919 268