Power Platform Community Forum Thread Details

Hello!

I am trying to display projects that are launching in a calendar that I have created. The calendar has a nested gallery to display the projects but it is not working as I had hoped.

Instead of all projects displaying on the day it is launching. It is displaying all projects on all days in the calendar.

On visible is set to:

Set(_dateSelected, Today());
Set(_firstDayOfMonth, DateAdd(Today(), 1 - Day(Today()), Days));
Set(_firstDayInView, DateAdd(_firstDayOfMonth, -(Weekday(_firstDayOfMonth) - 2 + 1), Days));
Set(_lastDayOfMonth, DateAdd(DateAdd(_firstDayOfMonth, 1, Months), -1, Days));
Set(_minDate, DateAdd(_firstDayOfMonth, -(Weekday(_firstDayOfMonth) - 2 + 1), Days));
Set(_maxDate, DateAdd(DateAdd(_firstDayOfMonth, -(Weekday(_firstDayOfMonth) - 2 + 1), Days), 40, Days));

The outer calendar gallery is set to:

[0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41]

and I have a label set to:

Day(DateAdd(_firstDayInView,ThisItem.Value,Days)) to display the days of the week on the calendar

I am using the following for the inner calendar:

Filter('Test List', DateValue(Text('Revised Launch Date')) = DateValue(Text(ThisItem.Value)))

I was hoping to display only the project launching on a particular day or multiple projects launching on the same day.

Eventually I want to expand it out to be able to allow the user to sort what is actually displayed on a date by using a drop down:)

Example: If user selected Projects from drop down it will display projects on calendar, if they select a user it will only display projects related to that user:)

Any help is always appreciated!!

Thank you!

Categories:

Building Power Apps