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

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.

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
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (50,357)