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 Apps
Unanswered

Regarding Sorting

(0) ShareShare
ReportReport
Posted on by 46

Sort is not working !! . I  want to use filter along with Sort in a gallery.  

 

Sort(Filter('User Allocations','User ID'.'User ID'=User().FullName,'End Date'>=Today()&&'Start Date'<=Today()),'Project Name')

 But this is not working Sort order for project

Categories:
  • Nogueira1306 Profile Picture
    7,390 Super User 2024 Season 1 on at

    Sort(Filter('User Allocations','User ID'.'User ID'=User().FullName,'End Date'>=Today()&&'Start Date'<=Today()),'Project Name', Asceding)

     

    That will order by project name, A-Z

     

    If you need additional help please tag me in your reply and please like my reply.
    If my reply provided you with a solution, pleased mark it as a solution ✔️!

    Best regards,
    Gonçalo Nogueira

    Check my LinkedIn!

    Check my User Group (pt-PT)!

    Last Post on Community

    My website!

  • ELango Profile Picture
    46 on at

    But i will show in the format

    Thorrol

    Sitling

    Para

    Sky

     

  • Nogueira1306 Profile Picture
    7,390 Super User 2024 Season 1 on at

    Filter(Sort('User Allocations','Project Name', Desceding), 'User ID'.'User ID'=User().FullName,'End Date'>=Today()&&'Start Date'<=Today())

     

    If you need additional help please tag me in your reply and please like my reply.
    If my reply provided you with a solution, pleased mark it as a solution ✔️!

    Best regards,
    Gonçalo Nogueira

    Check my LinkedIn!

    Check my User Group (pt-PT)!

    Last Post on Community

    My website!

  • v-bofeng-msft Profile Picture
    Microsoft Employee on at

    Hi @ELango :

    Is the problem solved?

    If the problem still exists, could you please tell me:

    • What is the data type of 'Project Name'?
    • Do you need to sort by the first letter of 'Project Name' in reverse order?

    Best Regards,

    Bof

  • ELango Profile Picture
    46 on at

    Datatype of project Name  would be Text  Only

    Sort order in ascending order

     

  • v-bofeng-msft Profile Picture
    Microsoft Employee on at

    Hi @ELango :

    I've made a test but did not encountered the problem you mentioned:

    I assume there is a table:

    ClearCollect(
     'User Allocations',
     {'Project Name':"Thorrol",'User ID':{'User ID':User().FullName},'End Date':Today(),'Start Date':Today()},
     {'Project Name':"Sitling",'User ID':{'User ID':User().FullName},'End Date':Today(),'Start Date':Today()},
     {'Project Name':"Para",'User ID':{'User ID':User().FullName},'End Date':Today(),'Start Date':Today()},
     {'Project Name':"Sky",'User ID':{'User ID':User().FullName},'End Date':Today(),'Start Date':Today()}
    )

    Filter and Sort the table:

    Sort(Filter('User Allocations','User ID'.'User ID'=User().FullName,'End Date'>=Today()&&'Start Date'<=Today()),'Project Name',Ascending)

    The Result:

    vbofengmsft_0-1643786881826.png

    If the problem still exists, I suggest you create a support ticket for professional assistance following the below procedure. 

    Get Help + Support - Power Platform | Microsoft Docs 

    Best Regards,

    Bof

     

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 Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 345 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 225

#3
M Bilal Khan Profile Picture

M Bilal Khan 192

Last 30 days Overall leaderboard