web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Gallery - Date

Power Apps

Unanswered

Gallery - Date

(0) Share

Report

Report

Posted on by DLCaterhamSch

394 Super User 2024 Season 1

Dear All,

I would like to have a gallery which shows only records from a sharepoint list today plus one. I have the following formula which doesnt work:

Date >= Today()) || Date >= Today()+1),

Can you help? So it only shows dates from today and tomorrow.

Thanks

Daniel

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Rajkumar_M 3,747 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Try this In Gallery Item

Filter('YourSharePointList', Date = Today() || Date = Today()+1)

(Or)

Filter(
SharePointList,
Date >= Today() && Date <= DateAdd(Today(), 1, TimeUnit.Days)
)

Thanks!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.
timl 37,287 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @DLCaterhamSch

If the data in your Date column includes a time element, you can also try the following. The result of this will include records that are today +1 day (up to 23:59).

Filter( SharePointList, Date >= Today() && Date < DateAdd(Today(), 2, TimeUnit.Days) )

Join the conversation