Answered

Gallery Filter for items created today

(0) Share

Report

Posted on by JR-BejeweledOne

5,836 Moderator

In my app I am working directly with the data source, no interim collection is necessary. In my gallery I only want to display the items that were created by the current user and created today.

I have tried this solution: https://powerusers.microsoft.com/t5/Building-Power-Apps/Filter-gallery-to-show-results-created-today/m-p/89589#M33895 but find that it's not working and it's not delegable.

This is my Gallery filter:

Filter('Conference Rooms', 'Created By'.Email = User().Email && IsToday(Created))

If I just use the Created By part of the filter it works fine but when I add the IsToday, then nothing is displayed.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@JR-BejeweledOne

Shouldn't it be IsToday('Created On')?

Was this reply helpful? Yes No
JR-BejeweledOne 5,836 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

'Created On' isn't an option. This is the default Created field that was there when the list was created.

Was this reply helpful? Yes No
Verified answer

JR-BejeweledOne 5,836 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
I finally solved this. What I had to do was to create 2 variables in the Visible property of my start screen.

UpdateContext({ cvStartDateTime: $"{Today()} 12:00:00 AM", cvEndDateTime: $"{Today()} 11:59:59 PM" })

Then I filter my gallery like this:

Filter('Conference Rooms', (Created > DateTimeValue(cvStartDateTime) && Created < DateTimeValue(cvEndDateTime)) && 'Created By'.Email = User().Email)

Was this reply helpful? Yes No