cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Dyxt
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

15 REPLIES 15
Dyxt
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

Anonymous
Not applicable

adding in @KeremY to review and assist

 

@Anonymous

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

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

 

 

Dyxt
Frequent Visitor

Hi ,

 

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

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (4,062)