web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Calendar Display not s...
Power Apps
Unanswered

Calendar Display not showing all events in SharePoint Events List

(0) ShareShare
ReportReport
Posted on by 21

Been reading through multiple threads but didn't see one to address this.

 

I followed @RezaDorrani 's video here:  https://www.youtube.com/watch?v=pA7pcAOvf10 to take the out of the box calendar screen template from PowerApps and customize it to use with a SharePoint list. It has worked for the the general structure of things. Where I'm running into issues is I think caused by my SharePoint list being an Events List. The need behind this is our users will be viewing the calendar from Outlook as well as within the app. 

 

I nested a gallery inside the main calendar gallery to display the event names, but there doesn't seem to be any rhyme or reason to which item it displays in the nested gallery. I resized the child gallery to make sure they weren't just hiding. There is only one event showing up on any given day. 

 

Here is a screenshot of what the Events list looks like on SPO:

JillianP_0-1711737697665.png

 

This is what is showing up in my app:

JillianP_1-1711737865101.png

In the OnVisible property of my screen, the following is set:

 

/*resets calendar view and date selection to today*/
Set(_dateSelected, Today());
Set(_firstDayOfMonth, DateAdd(Today(), 1 - Day(Today()), TimeUnit.Days));
Set(_firstDayInView, DateAdd(_firstDayOfMonth, -(Weekday(_firstDayOfMonth) - 2 + 1), TimeUnit.Days));
Set(_lastDayOfMonth, DateAdd(DateAdd(_firstDayOfMonth, 1, TimeUnit.Months), -1, TimeUnit.Days));
Set(_calendarVisible,true)

 

Here is my code for the items in my Child Gallery: 

Filter(PILD_PTO,'Start Time'= DateAdd(_firstDayInView,ThisItem.Value, TimeUnit.Days))

This is how the galleries are set up in the app:

JillianP_2-1711738464515.png

 

I tried watching videos from @Shanescows to get tips too but couldn't find a solution.

Categories:
I have the same question (0)
  • BCLS776 Profile Picture
    8,994 Moderator on at

    How many rows are in your PILD_PTO list? This sounds like what happens when a non-delegable query is run on a datasource with more rows than the app row limit.

     

    If so, the fix is to prefilter the underlying list and then query that. For a calendar view, a good way is to load the range of items for a month on either side of your calendar month into a collection, and then Filter() off the collection. That speeds up app performance too.

     

    Hope that helps,

    Bryan

  • JillianP Profile Picture
    21 on at

    It has less than 200 items in the list so shouldn't be causing a delegation issue. The code fort he Child Gallery that is having the issue is filtering the data source so have that part covered too 🙂

  • BCLS776 Profile Picture
    8,994 Moderator on at

    Another reason for pre-filtering to a collection (or, I've started using Named Formulas with great results) is that it reduces the number of queries to the SharePoint service. Your app may be running into throttling by the service if it exceeds 600 operations in 60 seconds. You can verify this by running a monitor session and looking for 429 status responses.

     

    If you've already got 200 rows in your list, it isn't a big stretch before you must ensure all queries are delegable and efficient.

     

    Bye for now,

    Bryan

  • JillianP Profile Picture
    21 on at

    Thank you, I'll give the monitoring session a try and see what it shows for future steps. 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 416 Most Valuable Professional

#2
11manish Profile Picture

11manish 205 Super User 2026 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 128 Super User 2026 Season 2

Last 30 days Overall leaderboard