Gallery Search and Filter y date if Toggle is 'true'

(0) Share

Report

Posted on by tredgold

HI,

I have a gallery that has the following set -

Search(Filter(Table2,

DateValue(

Text(Migration_x0020_Date)) = Today()

),TextSearchBox1_8.Text,"displayname")

This works, but what i would like to do is add a Toggle button, so that if it is true - then the filter is set to = Today() and if its not true it should not filter the list (i.e. show everything), but i am struggling to understood where and how best to put my If statement.

Appreciate your guidance\input.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Try:
If(Toggle1.Value=true,
Search(Filter(Table2, DateValue(
Text(Migration_x0020_Date)) =Today() ),TextSearchBox1_8.Text,"displayname"),Table2)
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Verified answer

v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @tredgold ,

Do you want to add a Toggle button to control the date filter within your Filter function?

I have made a test on my side, please consider take a try with the following workaround:

Set the Items property of the Gallery to following:

Search( Filter( Table2, If( Toggle1.Value = true, DateValue(Text(Migration_x0020_Date)) = Today(), true ) ), TextSearchBox1_8.Text, "displayname" )

Please try above solution, then check if the issue is solved.

Best regards,

Was this reply helpful? Yes No
tredgold 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks very much for the suggestion, this almost did what i needed but it wasn't allowing me to search when the toggle button was off, so i took what you provided and amended the "false" action slightly so i could still search on all records returned -

If(Toggle1.Value= true ,Search(Filter(Table2,DateValue(Text(Migration_x0020_Date))=Today()),TextSearchBox1_8.Text,"displayname"),Search(Table2,TextSearchBox1_8.Text,"displayname"))

The above is now working as i wanted in my app, Again thank you for the help as your suggestion pointed me in the right direction.

Was this reply helpful? Yes No
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Mark the solution
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

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

Like
a
(0)

Report
Copy link

Link copied!

Hi @tredgold ,

Have you taken a try with the solution I provided above?

Based on the needs that you mentioned, I think the formula I provided above could achieve your needs easily. Please try a try with it, if you have any issue with the solution, please feel free to let me know here.

If you have solved your problem, please consider go ahead to click "Accept as Solution" to identify this thread has been solved.

Best regards,

Was this reply helpful? Yes No
tredgold 6 on at

Like
a
(0)

Report
Copy link

Link copied!

HI, Yes i have tested the solution you provided and find this works and is a simpler solution than the alternative i had suggested - so thank you very much.
I have marked it as the accepted solution.

Was this reply helpful? Yes No