Skip to main content

Notifications

Community site session details

Community site session details

Session Id : GUwDb18bXANAoKOV4TjP43
Power Apps - Building Power Apps
Unanswered

Filter and Sort Gallery

Like (0) ShareShare
ReportReport
Posted on 5 May 2023 13:55:15 by 720

I have a gallery i would like to allow a search for requester name and also display all the records in descending order based on the ID. 

 

This doesn't work, so im a bit stuck.

 

Sort(
	Filter(Uniform,
		REQUESTER = TextInput31.Text).
	
	Descending
)

 

 

 

Categories:
  • Ami K Profile Picture
    15,665 Super User 2024 Season 1 on 05 May 2023 at 16:18:31
    Re: Filter and Sort Gallery

    @amyharkus86 - If REQUESTOR is a Single Line Text column, you could can use the same code but slightly modified:

     

    Sort(
     Filter(
     UniForm,
     IsBlank(TextInput31.Text) || StartsWith(
     REQUESTER,
     TextInput31.Text
     )
     ),
     ID,
     SortOrder.Descending
    )

     

    ------------------------------------------------------------------------------------------------------------------------------

     

    If I have answered your question, please mark your post as Solved.

    If you like my response, please give it a Thumbs Up.

     

     

  • amyharkus86 Profile Picture
    720 on 05 May 2023 at 14:10:54
    Re: Filter and Sort Gallery

    @Amik 

     

    This works, with slight change 

    Sort(
    Filter(Uniform, TextInput31.Text = REQUESTER)
     
     ,
     ID,
     SortOrder.Descending
    ) 

     

    But I'd like it to display everything even if TextInput31 is blank

  • Ethan_009 Profile Picture
    4,838 Super User 2025 Season 1 on 05 May 2023 at 14:02:10
    Re: Filter and Sort Gallery

    Hi @amyharkus86 ,

     

    You need to change the formula similar to this:

    SortByColumns(
     Filter(Uniform,
     REQUESTER = TextInput31.Text
     ),
     <column-name>,
     Descending
    )

     

    Modify the column name and formula accordingly.

     

    Hope this helps

     

  • Ami K Profile Picture
    15,665 Super User 2024 Season 1 on 05 May 2023 at 14:01:19
    Re: Filter and Sort Gallery

    @amyharkus86 -

     

    The below assumes the Requestor Name column is a People Column:

     

     

    Sort(
     Filter(
     Uniform,
     IsBlank(TextInput31.Text) || StartsWith(
     REQUESTOR.DisplayName,
     TextInput31.Text
     )
     ),
     ID,
     SortOrder.Descending
    )

     

     

     

    ------------------------------------------------------------------------------------------------------------------------------

     

    If I have answered your question, please mark your post as Solved.

    If you like my response, please give it a Thumbs Up.

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Building Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 89 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 58

#3
Michael E. Gernaey Profile Picture

Michael E. Gernaey 42 Super User 2025 Season 1

Overall leaderboard
Loading started