How do I show red circles for monthly calendar view events?

(0) Share

Report

Posted on by F_Quint

257

Hi,

I'm trying to build a simple Calendar app that uses a SharePoint list as the Data source.

I got the names to show on a side Gallery, but the Month-view Gallery shows Red circles for all dates, even though I have no events for these dates.

The collection capturing the input is as follows:

Collect(NaviaPTO, {StartDate: StartDatePopUp_1.SelectedDate, EndDate: EndDatePopUp_1.SelectedDate, Resource: ResourceName_1.Selected.DisplayName, OOOType: OOO_Type_1.SelectedText.Value})

My on select for the circle is:

CountRows(Filter(NaviaPTO,DateValue(Text('StartDate'))<=DateAdd(_firstDayInView,ThisItem.Value,Days),DateValue(Text('EndDate'))>=DateAdd(_firstDayInView,ThisItem.Value,Days)))>0&&!Subcircle1_2.Visible&&ResourceName_1.Visible

Any help would be greatly appreciated.

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @F_Quint ,

Do you want the red circle to be shown up for these dates which have Calendar Events?

Regarding the formula and operation that you mentioned, I think there is something wrong with it. Firstly, if you want to control the visible of the red circle in your MonthDayGallery1_2, you should apply the second formula into the Visible property of the Red circle icon (Circle2_2).

Please set the Visible property of the Red Circle (Circle2_2) to following:

CountRows( Filter( NaviaPTO, DateValue(Text(StartDate)) = DateAdd(_firstDayInView,ThisItem.Value,Days) ) )>0 && !Subcircle1_2.Visible && Title3_2.Visible

or

CountRows( Filter( NaviaPTO, DateValue(Text(StartDate)) <= DateAdd(_firstDayInView,ThisItem.Value,Days), DateValue(Text(EndDate)) >= DateAdd(_firstDayInView,ThisItem.Value,Days) ) )>0 && !Subcircle1_2.Visible && Title3_2.Visible

Please try above solution, then check if the issue is solved.

Regards,
F_Quint 257 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-xida-msft Thank you for that reply.
I tried what you suggested and I do show the red circle, but not for the dates in between. See side gallery dates.
Verified answer

v-xida-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @F_Quint ,

Regarding the screenshot that you mentioned, I think there is something wrong with your operation.

Just as I mentioned before, you should apply the following formula:

CountRows( Filter( NaviaPTO, DateValue(Text(StartDate)) <= DateAdd(_firstDayInView,ThisItem.Value,Days), DateValue(Text(EndDate)) >= DateAdd(_firstDayInView,ThisItem.Value,Days) ) )>0 && !Subcircle1_2.Visible && Title3_2.Visible

into the Visible property of the Circle2_3 control rather than the OnSelect property as your screenshot mentioned. The OnSelect property would be fired when you click this Circle2_3 control. The Visible property of the Circle2_3 control would be used to control the visible of the red circle.

Please check if the solution in the following thread would help in your scenario:

https://powerusers.microsoft.com/t5/Building-Power-Apps/Calendar-gallery-display-circles-for-each-day-of-the-event-amp/m-p/415681

Regards,
F_Quint 257 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-xida-msft you were right, I had it on the OnSelect.
sorry about that! And thank you for your help!