I have created a calendar attached to a sharepoint list and all works well except that if there are multiple events in 1 day only one item shows. I have checked the board here and the formula that I am using is - Filter('Leave Request',From<= DateValue(lblDateCurrent.Text) And To >= DateValue(lblDateCurrent.Text)) - In the lblDateCurrent under Items I have ThisItem.Value.
I have attached a screenshot of the calendar for you to check out. I'm sure it must be one little thing that I am doing wrong.
Any help would be greatly appreciated.
Mike, yes it shows up as 3. Time Zones are all Australia ( GMT + 10 hrs)..
Hi @GARYRU
If You add a text label to screen and in the Text value do CountRows(your filter) what do you get?
I just want to see if your data actually has more than one. Also what time zones are your list versus what you’re typing in?
WarrenBelz
791
Most Valuable Professional
MS.Ragavendar
410
mmbr1606
275
Super User 2025 Season 2