Unanswered

Reset date controls to default. Special Case.

(0) Share

Report

Posted on by EvaSantos

Hi everyone,

I'm having a problem resetting my gallery to default. I use SQL Server as a database and had to add a dateInt column,
which converts the Date field from yyyy-mm-dd to yyyymmdd. This calculated column is the one I use to search my gallery.
When I start the app, all the records appear, and when I search by date range, the data is correct. Here's the code that performs the search:

Search(
Filter(
registro;
FechaInt >=(Year(DatePicker_busqueda_Inicio.SelectedDate) * 10000 + Month(DatePicker_busqueda_Inicio.SelectedDate) * 100 + Day(DatePicker_busqueda_Inicio.SelectedDate)

) &&
FechaInt <=(Year(DatePicker_busqueda_Fin.SelectedDate) * 10000 + Month(DatePicker_busqueda_Fin.SelectedDate) * 100 + Day(DatePicker_busqueda_Fin.SelectedDate)
)

);
busqueda_palabras.Text;
"Centro"; "Estado"; "Usuario"
)

If I do any search, it returns the results between both dates. The problem is when I want to reset the date controls and have all the records reappear.

If I do a normal reset like: Reset(DatePicker) the gallery doesn't show results. How can I fix this?
I would appreciate any help

Categories:

Building Power Apps

All responses (2)

Answers (0)

Sort by

mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
hey @EvaSantos

can u please try this version:

If( IsBlank(DatePicker_busqueda_Inicio.SelectedDate) || IsBlank(DatePicker_busqueda_Fin.SelectedDate), Search( registro, busqueda_palabras.Text, "Centro", "Estado", "Usuario" ), Search( Filter( registro, FechaInt >= (Year(DatePicker_busqueda_Inicio.SelectedDate) * 10000 + Month(DatePicker_busqueda_Inicio.SelectedDate) * 100 + Day(DatePicker_busqueda_Inicio.SelectedDate)) && FechaInt <= (Year(DatePicker_busqueda_Fin.SelectedDate) * 10000 + Month(DatePicker_busqueda_Fin.SelectedDate) * 100 + Day(DatePicker_busqueda_Fin.SelectedDate)) ), busqueda_palabras.Text, "Centro", "Estado", "Usuario" ) )

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings
EvaSantos 49 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @mmbr1606 ,
Thank you for your reply. My gallery still doesn't show results. I think the problem may be that for the DatePickers I have set a DefaultDate (?) and it does the search in a different date format(?) For the DePicker_busqueda_Inicio: DateValue("2023-01-01"; "en-ES") and for DatePicker_busqueda_Fin: Today()

But when I start the App it does show all the results. It does the search well. It's just that it doesn't show all the results again. Refresh() doesn't work either.