GroupBy formula using issues

[Dennis_Qiang]

I know GroupBy Syntax is  ''GroupBy( Table, ColumnName1 [, ColumnName2, ... ], GroupColumnName )''.

My question is if my column is Choice type, it can not be use. If single line Type, it works. ( Table datasource base on Sharepoint list )

So how to use GroupBy formula if my column is Choice Type ?

Thank You

Dennis

[eka24]

The only difference is adding .Value to the choice field.

Check this post

https://powerusers.microsoft.com/t5/Building-Power-Apps/Using-Choice-Column-in-PieCharts/m-p/352272#...

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[ganeshsanap · Accepted solution]

@Dennis_Qiang As per this post, SharePoint Choice Field is not supported with GroupBy function.

But there is an workaround of using AddColumns function. You can use it like below:

Groupby(AddColumns(DataSourceName, "NewFieldName",Category.Value),"NewFieldName","GroupName")

Here, We are using AddColumns to introduce a new field based on the Choice field (Category) then grouping by the new field.

Reference: How to do a group by with Choice field 

---

Please click Accept as solution if my post helped you solve your issue. This will help others find the correct solution easily. It also closes the item. If the content was useful in other ways, please consider giving it 👍