Answered

Calendar control - mark events on a day with circle in MonthDayGallery

(0) Share

Report

Posted on by Snoop

Hi There,

My question is how can I mark an event with a small circle easily?
I want to mark all the days that have any events without using the Due Date as it is not used in this calendar.
At the moment I can only display items with the following criteria using the Due Date field(see attached):

!IsBlank(LookUp(Calendar, 'Due Date' = DateAdd(_firstDayInView,ThisItem.Value,TimeUnit.Days)).Title)

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (1)

Sort by

BCBuizer 22,833 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Snoop ,

Can you please share what 'Calendar' is in your formula?

Was this reply helpful? Yes No
Snoop 57 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @BCBuizer,
It is the data source (SharePoint Calendar)

Was this reply helpful? Yes No
BCBuizer 22,833 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Snoop ,

Usually the Calendar template works with a collection of calendar events, based on which the visibility of the circle is set. So when you are saying it is a SharePoint calendar, can you please clarify if "Calendar" is a collection, a list, something else?

Was this reply helpful? Yes No
Snoop 57 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @BCBuizer,
It is the default calendar (which is a special list with a calendar view as far as I know) on a SharePoint site.

Was this reply helpful? Yes No
BCBuizer 22,833 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Snoop ,

If it's a SharePoint list, what is the name of the column that has the start date/time in it? Unfortunately I couldn't find a default Calendar in my environment to check.

Was this reply helpful? Yes No
Snoop 57 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @BCBuizer,
It is Called Start Time

Was this reply helpful? Yes No
BCBuizer 22,833 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Snoop ,

So, then let's try:

!IsBlank(LookUp(Calendar, 'Start Date' = DateAdd(_firstDayInView,ThisItem.Value,TimeUnit.Days)).Title)

Was this reply helpful? Yes No
Snoop 57 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @BCBuizer,
I have only 'Start Time' which includes date and time as well and the above formula does not work with it.

Was this reply helpful? Yes No
Verified answer

BCBuizer 22,833 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Snoop ,

Then let's try to retrieve the date from 'Start Time':

!IsBlank(LookUp(Calendar, DateValue(Text('Start Time')) = DateAdd(_firstDayInView,ThisItem.Value,TimeUnit.Days)).Title)

Was this reply helpful? Yes No
Snoop 57 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @BCBuizer ,
Thank you for helping me I really appreciate it. This is working but on the other hand it creates a new problem which is a delegation warning. If I understood correctly when I have more than 2000 events in the calendar it won't work ?

Was this reply helpful? Yes No