Answered

Combine Sort() for Date with TextSearchBox

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi !
I've learn PA a week ago.
I've struggled to combine Sort()- for Date with TextSearchBox - search by title.

For the Attaching picture.
I tried combine like this but it doesnt work and I have no idea.

SortByColumns(Filter([@testingSortByDate], StartsWith(Title, TextSearchBox1.Text)), "requestByDate", Sort(testingSortByDate,requestByDate,Descending))

I could do either sort() by Date descending or fill by title only.

I really appreciate any help.

Thanks,
David

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

PowerAddict 7,316 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Are you unable to sory by the date field?

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution.

Thanks!
Hardit Bhatia
The Power Addict
https://thepoweraddict.com

Was this reply helpful? Yes No
v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Could you please share a bit more about your scenario?

Do you want to filter your Gallery Items based on the date type column? or just want to sort by date type column?

If you want to filter your Gallery Items based on the date type column, I afraid that the StartsWith() function could not achieve your needs. The StartsWith function could only accept Text type column as search column.

If you just want to sort by date type column, please consider modify your formula as below:

SortByColumns( Filter([@testingSortByDate], StartsWith(Title, TextSearchBox1.Text)), "requestByDate", If(SortDescending1, Descending, Ascending) )

Best regards,

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Thank you very much !
I was able to solve it 🙂

Sort(SortByColumns(Filter(Sort([@'Previous Sample Request Database'],'Date Requested',Descending), StartsWith(Title, TextSearchBox1.Text)), "Title", If(SortDescending1, Descending, Ascending)),'Date Requested',Descending)

Was this reply helpful? Yes No