web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Combine Sort, Serach a...

Power Apps

Answered

Combine Sort, Serach and Filter into Gallery

(0) Share

Report

Report

Posted on by JHAKANS

35

Hi.

I would like to combine these 3 functions into my gallery. Can someone help me with this?

SortByColumns("Created";Descending)

Search(Source; TextInput2.Text; "{Name}")

Filter(Source;("Change" >= DatePicker1.SelectedDate) &&
("Change" <= DatePicker2.SelectedDate)

Best regards.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (2)

Sort by

Verified answer

anibra 278 on at

Like (0)

Report
Copy link

Link copied!

Hi @JHAKANS ,
you can try
SortByColumns(Search(Filter(Source;("Change" >= DatePicker1.SelectedDate) &&
("Change" <= DatePicker2.SelectedDate),TextInput2.Text,"{Name}"),"Created",Descending))

Was this reply helpful? Yes No
Verified answer

CNT 10,921 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@JHAKANS

Please try the following,

SortByColumns( Filter(Source; Name=TextInput2.Text && (Change >= DatePicker1.SelectedDate && Change <= DatePicker2.SelectedDate) ); "Created";Descending )

Was this reply helpful? Yes No
JHAKANS 35 on at

Like (0)

Report
Copy link

Link copied!

Had to modify a bit. But it works now, thanks!

SortByColumns(
Filter(Search(Source;
TextInput2.Text;"{Name}");
(Change >= DatePicker1.SelectedDate &&
Change <= DatePicker2.SelectedDate)
);
"Created";Descending
)

Was this reply helpful? Yes No

Join the conversation