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:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

QuentinDURIEZ 577 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
PowerNovice on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

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

Im sorry, im still pretty new to PowerApps.

Was this reply helpful? Yes No
QuentinDURIEZ 577 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

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,

Was this reply helpful? Yes No
PowerNovice on at

Like
a
(0)

Report
Copy link

Link copied!

@QuentinDURIEZ Thank you!

Was this reply helpful? Yes No