cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
KHenderson
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
v-xida-msft
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
v-xida-msft
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.

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
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Changes to Ideas Coming

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (2,214)