Unanswered

Filter and Sort Gallery

(0) Share

Report

Posted on by amyharkus86

726

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:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Ami K 15,679 Super User 2024 Season 1 on at

Like (0)

Report
@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.

Was this reply helpful? Yes No
Ethan_009 4,838 Moderator on at

Like (0)

Report
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

Was this reply helpful? Yes No
amyharkus86 726 on at

Like (0)

Report
@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

Was this reply helpful? Yes No
Ami K 15,679 Super User 2024 Season 1 on at

Like (0)

Report
@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.

Was this reply helpful? Yes No