Group in gallery

[Dyxt]

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

[Dyxt]

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 ?

[Srautio]

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

[Anonymous]

adding in @KeremY to review and assist

@Anonymous

[Audrie-MSFT]

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,

Audrie

[Drrickryp · Accepted solution]

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.  

[Dyxt · Accepted solution]

Hi ,

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