cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
charliejbird
Regular Visitor

Gallery only showing events occurring at midnight

Hi all,

My issue is with a nested gallery I am using to create a calendar. The nested gallery shows events that match the date label for each day using the following formula;

 

Filter(colEvents,InitialApptDate=DateValue(DateLabel.Text))

 

However my issue is that it will only show events that occur at midnight. Does anyone know a solution so that the gallery will show events that occur at any time?

Thanks

charliejbird_1-1629714363459.png

 

 

3 REPLIES 3
PG_WorXz10
Community Champion
Community Champion

Hi @charliejbird ,

 

Just to check does your database field which you are refereeing contains 12:00 AM as time parameter like in case of Sharepoint if you make dateTime field as Date only it stores everything with default time 12:00 AM. Is something like this happening in your side ? 

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

If this post was helpful or you need more help please consider giving Thumbs Up and Tag me in your reply I'll be happy to help. If this post helped you solve your issue please click Accept as solution and provide Thumbs Up. This will help others find it more readily.

charliejbird
Regular Visitor

The database field is a DateTime field and different records have different times. However, it is only showing the records with the time 12:00 AM. I assume because the  DateValue of the DateLabel is defaulting to 12:00 AM.

@charliejbird 

 

Yes, you can cross check with the database data if this is the condition. 

If this post was helpful or you need more help please consider giving Thumbs Up and Tag me in your reply I'll be happy to help. If this post helped you solve your issue please click Accept as solution and provide Thumbs Up. This will help others find it more readily.

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,075)