web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / how to sort the gallar...
Power Apps
Unanswered

how to sort the gallary in powerapps

(0) ShareShare
ReportReport
Posted on by 34

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).

1.jpg

This is my sharepoint list

2.jpg

 

 

 

 

 

 

Categories:
I have the same question (0)
  • PriyankaGeethik Profile Picture
    3,320 Super User 2024 Season 1 on at

    Hi @Ishtiaq_zamil ,

     

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

  • Ishtiaq_zamil Profile Picture
    34 on at

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

  • PriyankaGeethik Profile Picture
    3,320 Super User 2024 Season 1 on at

    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 Profile Picture
    Super User 2024 Season 1 on at

    @Ishtiaq_zamil 

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

  • RandyHayes Profile Picture
    76,299 Super User 2024 Season 1 on at

    @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 Profile Picture
    34 on at

    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 Profile Picture
    76,299 Super User 2024 Season 1 on at

    @Ishtiaq_zamil 

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

  • Ishtiaq_zamil Profile Picture
    34 on at

    @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

     

     

    Ishtiaq_zamil_0-1629358247705.png

     

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

    Ishtiaq_zamil_1-1629358406281.png

    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 Profile Picture
    34 on at

    @RandyHayes can you please assist me.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Valantis Profile Picture

Valantis 395

#2
WarrenBelz Profile Picture

WarrenBelz 352 Most Valuable Professional

#3
Kalathiya Profile Picture

Kalathiya 287 Super User 2026 Season 1

Last 30 days Overall leaderboard