Calendar show items from collection or SharePoint list by date

[KHenderson]

I would like to use the calendar as a filter and act as a interactive guide. Is there a way to have the calendar to only pull of the SharePoint list items and not the outlook events? I could not find a way to get the calendar to update and edit a group calendar event. I would like to have them sort by date. Any ideas would be helpful.

[v-xida-msft · Accepted solution]

Hi @KHenderson ,

Have you add a Calendar screen in your canvas app?

Do you want the Calendar control to be populated with events from your SP Calendar List rather than Outlook events?

Based on the needs that you mentioned, I think the Calendar screen could achieve your needs. Firstly, please add your SP Calendar List as data source into your canvas app.

I have made a test on my side, please take a try with the following workaround:

Set the Items property of the CalendarEventsGallery1 to following:

/*Shows events only on selected date*/
SortByColumns(Filter('Your SP Calendar List', Text('Start Time', DateTimeFormat.ShortDate) = Text(_dateSelected, DateTimeFormat.ShortDate)), "EventDate")

Within the Events Gallery, re-reference the column value from your SP Calendar List in these Labels.

Set the Visible property of the Circle1 under the MonthDayGallery1 to following:

/*Visible if calendar events are found on this day*/               
CountRows(Filter('Your SP Calendar List', DateValue(Text('Start Time')) = DateAdd(_firstDayInView,ThisItem.Value,Days))) > 0 && !Subcircle1.Visible && Title2.Visible

Please consider take a try with above solution, then check if the issue is solved. You could also refer to the sample app I attached below.

Best regards,

[Alois]

Hi,

I did as your instructions. However, I'm encountering an error regarding the "Start Time" field. I have a Column titled "Pick Up Time" and replaced it accordingly as seen below but is showing up an error at where I highlighted. I suspect the issue is the DateValue and DateTimeValue. 

"Pick Up Time" is a Date and Time data field. How do I fix this?

Regards,
Alois