Answered

Trying to lookup values by today's date

(0) Share

Report

Posted on by russrimm Microsoft Employee

Hi all,

Pls bare with me - still pretty new to PowerApps.

I've got a sharepoint list which has a bunch of events I want users to register for. There's a date column, and on event day, I want the users to register for the event for tracking purposes which will ultimately pop them into another list I've created which has their name, email, the event name, and the date.

So I'm trying to display the events happening today in a dropdown, let them pick one, and then allow them to click register and it'll populate another list with their name, email, the event name, etc.

My events are in a SP list called EventsTest.

I made the OnVisible build the collection of events using ClearCollect(EventCollect,EventsTest). The column with the event's date shows up as Event_x0020_Date, so i've been trying using Lookup(Filter(EventCollect,'Event_x0020_Date'=Today()),Title and no matter how many times I've tried it, I can't seem to get today's events to show in the dropdown.

TIA

I've been battling with building the dropdown's items list. I've been trying things like Lookup(Filter(EventCollect,

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@russrimm

The problem you're running into is most likely the (assumed) fact that your 'Event Date' column is a Date and Time column. If that assumption is correct, then the problem is, you are comparing against Today(), which will only return the current date...not a time.

If this case you need to compare Date to Date without Time.

Filter(EventCollect, Date(Year('Event_x0020_Date'), Month('Event_x0020_Date'), Day('Event_x0020_Date'))=Today())

This will convert the Event Date into a date only value to compare with Today().

I would avoid trying to convert it to string and back and forth to compare as you will run into TimeZone issues, and it's a step you don't need.

I hope this is helpful for you.

Was this reply helpful? Yes No
russrimm Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Thanks, I tried this but it's not displaying any values in the dropdown even though there's an event with today's date that shows in the collection.
The sharepoint list column with the date is a Date and Time type, but also has the "Include time" option set to no, so does this still apply?
**UPDATE** it is working now that I set the "Value" to something with data in it :|. THANK YOU! You just made my day better :).

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@russrimm

Ah very good...Looking at your formula for the DropDown would have been my next step, but sounds like you jumped right on it.

Was this reply helpful? Yes No