web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Filter Gallery by a Da...

Power Apps

Answered

Filter Gallery by a Date within 24h

(0) Share

Report

Report

Posted on by TS0

10

Hey guys

Ive been working on an App in which i included a Filter Option.

I can Filter my gallery by Titel or by a Status given to my Sharepoint list.

Plus i always Filter by todays Date.

How can i add a Filter with a time range between to Date pickers and if that is Not used by Date created (sharepoint list) for a Max of 24h.

Hope somebody can help 😁

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

Nicbo 145 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi,
Do you want to check if the user has selected a date or do you use a variable?
You probably can use something like this

If(!IsBlank(DatePicker1.SelectedDate), //Or add you variable here instead Filter( Datasource, Date >= DatePicker1.SelectedDate And Date <= DatePicker2.SelectedDate), Filter( Datasource, Date > DateAdd(Now(), -24, TimeUnit.Hours))

If you are useing the datepickers have in mind that the default value is Today() and therefore isn't blank.

Hope it helps!

Was this reply helpful? Yes No
TS0 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks i will try that tomorrow and give you a Feedback 😁

Was this reply helpful? Yes No

Join the conversation