Answered

Question - Only show items in gallery of todays date

(0) Share

Report

Posted on by PowerNovice

Hi,

I have an app which is for internal audits/pre start up checks. I have one sheet that is a pre start up check and a gallery on the left sidebar for the list of completed ones. However, i only want to show the items with todays date.

Thank you,

Matt

Categories:

Mobile App

General Questions

All responses (4)

Answers (1)

PowerNovice on at

Like (0)

Report

Re: Question - Only show items in gallery of todays date

@QuentinDURIEZ Thank you!
QuentinDURIEZ 507 Super User 2025 Season 1 on at

Like (1)

Report

Re: Question - Only show items in gallery of todays date

This code will be in the property "Items" of your gallery, this is the property PowerApps use to query the data shown in your gallery

Here is some documentation for the "Filter" formula if you need : https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-filter-lookup

And a another documentation about what a gallery is and its properties : https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/controls/control-gallery

Regards,
PowerNovice on at

Like (0)

Report

Re: Question - Only show items in gallery of todays date

Hi,

Im sorry, this code will be within the default property for the gallery?

Im sorry, im still pretty new to PowerApps.
Verified answer

QuentinDURIEZ 507 Super User 2025 Season 1 on at

Like (1)

Report
Re: Question - Only show items in gallery of todays date

Hi,

If you're using the field CreatedOn (or any other system filled field), you can filter by using this formula as an example :
Filter([DATASOURCE] , [DATE] >= Today() And [DATE] < DateAdd(Today() , 1) )

Using Today() will return to today date, instead of Now() which will return today date AND time.

Then, we compare the date field where date >= 2023-11-14 AND date < 2023-11-15 (for today), so you will have all items created beteewen 00h01 and 23h59 today

Regards