Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Group in gallery

Hi Guys,


I'm new on PowerApps and i already learn a lot. This App is wonderful, but i need your help right now. Thanks in advance.


As you can see on my Sharepoint List (please see attachements), i have 3 lines. 2 of them has the Statut = Nouveau.

I would like to know how i can regroup them in a gallery in PowerApps. Cause for now, when i create a gallery, my gallery create a line for every "Nouveau" i have in my SharepointList. (see attachment) 

I only want two lines in my gallery : "Nouveau"and "En cours"


Thanks for your help

Frequent Visitor

I really don't know what is the reason but some of my columns appears now.

But "Statut"does not appear, maybe because it is a dropdown ?

As far as I can tell setting Items in a gallery to 

GroupBy(Tickets, "Statut", "Group")

And adding a label in the gallery should give a gallery with the options. 

What type of field is Statut in Sharepoint? I dont think it should matter but I know I've had issues with LookUp/Choice fields before

Not applicable

adding in @KeremY to review and assist



Yes, this is a known issue that GroupBy does not work with choice or lookup columns. Don't hesitate to add this requirements to our ideas forum for future enhancements.



Adding both @KeremY and @GregLi in case there is a workaround.


Thank you,


Hi @Dyxt,


It looks like Statu is a Choice type column in Sharepoint.  You can save yourself a lot of aggravation by either converting Choice columns to Single line of text or Numbers from within Sharepoint.  I have never lost data by doing this but the other way is to create a new calculated column and put the Choice column in as the calculation.  You can then use the new calculated column in Powerapps. Choice and Lookup columns are embedded tables and INHO are meant for use in SharePoint and are not designed for Powerapps.  Thats the reason for the complicated work arounds.  The screen capture on the left is from the Sharepoint Online with the list settings and  create columns clicked and the calculated type chosen. In this case, the Categories column is a Choice type.  Note the single line of text option below the type of information  section. Unfortunately, this will not work for Lookup type columns.  A different approach is necessary for unpacking them.  I hope this helps.  Capture.PNG



Hi ,


Thank you so much for your help. I succeed now.

Helpful resources

Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (5,903)