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

Regroup Items

Hi everyone

I'm doing a small exercices, I have a sharepoint list where I add my customer request

So my requests are stored in the list : CustomerRequest, and I show the request per month

I'd like to have a gallery where my customer are group

Because currently if I have a request from my customer A in June and July

And will have something like that:

                       June   July
Customer A       2         0

Customer A       0         1


and I'd like to get:

                        June   July

Customer A       2        1


Any idea of how could I do that?

The data are already in a gallery, I used this function to do that:

Filter(Source;Title=Dropdown1.Selected.Value && Date>= DatePicker2 && Date<=DatePicker3)


The datePicker 1 and 2 are only are to limited my search


Many thanks in advance



Community Support
Community Support

Re: Regroup Items

Hi @Domiowa,


I'm afraid that if you want to achieve this directly inside one gallery, then I'm afraid that this cannot be achieved. But you can make the columns show separately in dropdown/label controls. I just created the app successfully and here are the steps: 


1. Create the list according to your description:



2. Create a new blank app, connect to this list. Insert a dropdown control, set its Items property to:

Distinct('Customer Request',Title)


All customers' names would be shown with duplicate values removed in the dropdown list.


3. Add a Label1 control, and set its Text property to:

Sum(Filter('Customer Request',Title=Dropdown1.Selected.Value),June)

Add a Label2 control, and set its Text property to:

Sum(Filter('Customer Request',Title=Dropdown1.Selected.Value),July)

There you go! Label1&2 would show the summed data according to the customer name you selected in dropdown control.






Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Frequent Visitor

Re: Regroup Items


I have already something similar to that:




And as I need to color my value, I couln't do that in a table




Helpful resources

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.


New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Top Solution Authors
Top Kudoed Authors
Users online (6,087)