Announcements
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 )
@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.
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
@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
@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 )
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Vish WR 839
Valantis 533
Haque 412
