how to sort the gallary in powerapps

[Ishtiaq_zamil]

Hi Makers,

I have a sharepoint list on global level it should sort the gallary by year

Then it should arrange the gallary meetings vertically. as shown below(our target is to achive like this).

This is my sharepoint list

[PriyankaGeethik]

Hi @Ishtiaq_zamil ,

May I ask you if you have any year field in your Sharepoint list ? 

[Ishtiaq_zamil]

yes there is a year field, name as "contDate"

[PriyankaGeethik]

Hi @Ishtiaq_zamil ,

Ok, on select of dropdown Year set the a variable with the selected year. Is it ok for you to filter the gallery based on the selected year because for sorting only ascending and Descending are possible.

[Ramole]

@Ishtiaq_zamil 

Here is a video Todd Baginski explaining  how to Filtering and sorting galleries https://www.youtube.com/watch?v=jb--wPX10bc 

[RandyHayes]

@Ishtiaq_zamil 

Are you really trying to sort the gallery or filter the gallery?  You have a dropdown with different years in it - that would usually imply that you want to filter the list.

If Filtering is what you need, then you can simply set your Gallery Items formula to be:

Filter(<yourExistingItemsFormulaHere>,
    contDate = yourDropdown.Selected.Value
)

I am not sure how the dropdown would play into the sorting, but if it is just sorting you want, then the following should give you that sorting:

Sort(<yourExistingItemsFormulaHere>,
    contDate
)

If you have multiple levels of sorting needed, then you can use the SortByColumns function for that. 

SortByColumns(<yourExistingItemsFormulaHere>,
    "Title", Ascending,
    "contDate", Ascending
)

However, in looking at what you have for the final outcome, you really need some level of grouping based on your list data.

I hope this is helpful for you.

[Ishtiaq_zamil]

Hi RandyHayes,

Yes i am really looking for the filtering of my sharepoint list data. i want to filter it as i shown in the first image.

how can i achieve it? i am unable to write a formula for that filter.

[RandyHayes]

@Ishtiaq_zamil 

Did you try the formulas I provided?  What is the current Items property of your gallery?

[Ishtiaq_zamil]

@RandyHayes 

Yes I tried it but i am unable to write the formula for the gallary filter. my current formula in items property is 

Filter(DataOfUpload,
    contDate = DDYear.Selected.Value
)

the above formula shows all the records as below

let me show  you more info for this app, the first gallary of companies is like this.

there will be multiple meetings conducted by the board on these companies, whenever the meeting is completed for the perticualr company they will upload 2 files one for Minutes of Meeting and another one Material.

in the total there will be 5 meetings in one year for each company.

can you please help me to write the formula for filetering of these sharepoint list items.

if you want i have share you the app.

[Ishtiaq_zamil]

@RandyHayes can you please assist me.