Group same dates in gallery

[Anonymous]

Hi all,

I have gallery which contains data like date, name etc. 

here is the dummy sketch of what I have in gallery:

So I want is, to group same dates line as 1. Because if user filter data on dates, can see the relevant dates data in gallery.

 

Can someone please help me on this?

Thanks

Ahmad.

[v-bofeng-msft · Accepted solution]

Hi @Anonymous :

The point is to use GroupBy function.I've made a test for your reference:

1\My data source

ClearCollect(
    TheCollection,
    {
        Name: "Test",
        Date: Date(2020,12,11)
    },
    {
        Name: "Test1",
        Date: Date(2020,12,11)
    },
    {
        Name: "Test2",
        Date: Date(2020,11,20)
    },
    {
        Name: "Test3",
        Date: Date(2020,10,12)
    }
)

2\Add a gallery(Gallery1) and set it's items property to:

ForAll(
Sequence(CountRows(GroupBy(AddColumns(TheCollection,"NewDate",Date),"Date","NewGroup"))),
{number:Value,
Group:Last(FirstN(GroupBy(AddColumns(TheCollection,"NewDate",Date),"Date","NewGroup"),Value)).NewGroup}
)

/*Use ForAll and Sequence functions to number each set of data*/

/*Use the GroupBy function to group data*/

3\Add a label control into Gallery1 and set it's Text property to:

ThisItem.number

4\Add an other gallery(Gallery2) into Gallery1 and set it's items property to

ThisItem.Group

5\Add a label control into Gallery2 and set it's Text property to:

"Name:"&ThisItem.Name

6\Add a label control into Gallery2 and set it's Text property to:

"Date:"&ThisItem.NewDate

 

Best Regards,

Bof

[Anonymous]

Thanks for your response. 

Is it possible to have this functionality in the same gallery?

Thanks.

[v-bofeng-msft]

Hi @Anonymous :

Could you tell me what "in the same gallery" means?

Best Regards,

Bof

[Anonymous]

Sorry for confusion.

You have used two galleries. I am using only 1 gallery and want to filter same functionality same gallery I am using.

Regards.

[v-bofeng-msft]

Hi @Anonymous :

Gallery2 is just a gallery embedded in Gallery1.Because the number of records in each group is uncertain, an embedded gallery is needed to dynamically display them.

Best Regards,

Bof

[v-bofeng-msft]

Hi @Anonymous :

If you want to achieve the "group display" effect you requested, I am afraid that there is no better way besides the solution I provided before.

If you only need to number and sort them, you can set the item property of the gallery to:

Sort(Ungroup(ForAll(
Sequence(CountRows(GroupBy(AddColumns(TheCollection,"NewDate",Date),"Date","NewGroup"))),
{number:Value,
Group:Last(FirstN(GroupBy(AddColumns(TheCollection,"NewDate",Date),"Date","NewGroup"),Value)).NewGroup}
),"Group"),number)

In this case, there is no need for sub-gallery.

Best Regards,

Bof