Filter sharepoint list by datepicker selected date or text search box

(0) Share

Report

Posted on by AT_AlanTse123

181

Hi all,

I have TextSearchBox and datepicker and I want to use them to filter the SharePoint list called YT CDR List.

Just filter by text search box is fine but filter by datepicker Selected date is not work.

Below is my code on Browse gallery's Items but not work;

SortByColumns(Filter([@'YT CDR List'],StartsWith('Upload Time', DatePicker2.SelectedDate) ||StartsWith('Project No.', TextSearchBox1.Text)||StartsWith(OA, TextSearchBox1.Text)||StartsWith(Commence, TextSearchBox1.Text)), "Title", If(SortDescending1, Descending, Ascending))

Screen Capture:

How can i revise the code that can search by datepicker selected date or TextSearchBox ?

Thank you very much for your help.

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (1)

Report
SortByColumns( Filter( [@'YT CDR List'], 'Upload Time' = DatePicker2.SelectedDate), StartsWith('Project No.', TextSearchBox1.Text), StartsWith(OA, TextSearchBox1.Text), StartsWith(Commence, TextSearchBox1.Text) ), "Title", If( SortDescending1, Descending, Ascending ) )

Try that

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,

Gonçalo Nogueira

Check my LinkedIn!

My website!

Was this reply helpful? Yes No
AT_AlanTse123 181 on at

Like (0)

Report

Hi Nogueira,

Thank you very much for your reply.
I tried your code but it has the error.
Would you please help to check?
Thank you.

Was this reply helpful? Yes No
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (1)

Report
SortByColumns( Filter( [@'YT CDR List'], 'Upload Time' = DatePicker2.SelectedDate, StartsWith('Project No.', TextSearchBox1.Text), StartsWith(OA, TextSearchBox1.Text), StartsWith(Commence, TextSearchBox1.Text) ), "Title", If( SortDescending1, Descending, Ascending ) )

Was this reply helpful? Yes No
AT_AlanTse123 181 on at

Like (0)

Report

Hi Nogueira,
Thank you very much for your reply.
Filter by date is work but it cannot filter by textsearchbox, Is it only can filter by one type in items property?
Also, May I know if only filter by date, how to revise the code?
Sorry for too much question.

Was this reply helpful? Yes No
Verified answer

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (1)

Report
Filter by date:

SortByColumns( Filter( [@'YT CDR List'], 'Upload Time' = DatePicker2.SelectedDate ), "Title", If( SortDescending1, Descending, Ascending ) )

Try this filter instead:

SortByColumns( Filter( Search([@'YT CDR List'];TextSearchBox1.Text;"Project No.";"OA";"Commence"), 'Upload Time' = DatePicker2.SelectedDate ), "Title", If( SortDescending1, Descending, Ascending ) )

Please chekc the name of the fields and the , and ;

Was this reply helpful? Yes No
AT_AlanTse123 181 on at

Like (0)

Report

Hi Nogueria,
Filter by date is work, thank you very much for your help.
But your second code is not work, i had change ; to :, it shows below error.
Thank you.

Was this reply helpful? Yes No
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (1)

Report

Itold you to check the names... It is not recognizing the "Porject No.".

Check the suggestions when oyu type Project and use that value. The problem is the collumn

Was this reply helpful? Yes No
AT_AlanTse123 181 on at

Like (1)

Report

Ok, thank you very much for your help.
I will check the name again.

Was this reply helpful? Yes No