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

Power Platform Community Conference

Check out the on demand sessions that are available now!

Watch Now

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (7,417)