cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Calendar show items from collection or SharePoint list by date

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

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:

3.JPG

 

4.JPGSet 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,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Community Support
Community Support

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:

3.JPG

 

4.JPGSet 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,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

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?

Alois_0-1603678893212.png
Regards,
Alois

 

Helpful resources

Announcements
News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

Power Apps Community Call

Power Apps Community Call- January

Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

Top Solution Authors
Top Kudoed Authors
Users online (5,792)