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

 

 

2 REPLIES 2
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:

Capture.PNG

 

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.

Capture.PNG

 

Regards,

Mona

 

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.
Domiowa
Frequent Visitor

Re: Regroup Items

Okay

I have already something similar to that:

 

Untitled.png

 

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

Right?

 

A

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

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)