web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Calendar show items fr...

Power Apps

Answered

Calendar show items from collection or SharePoint list by date

(0) Share

Report

Report

Posted on by KHenderson

14

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.

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

v-xida-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
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,

CustomCalendarScr...
Alois 95 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Join the conversation