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 - 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.
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
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
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.
WarrenBelz
89
Most Valuable Professional
MS.Ragavendar
58
Michael E. Gernaey
42
Super User 2025 Season 1