What governs how CalendarGetTables().value lists available calendars?

[AdamD]

Try as I might to figure out what it is that results in the calendars that show up in Office365Outlook.CalendarGetTablesV2().value, I can't figure out why I get the same seven calendars. There are many more calendars that are shared with me and that I'm a part of on Teams, but for whatever reason it's limited to a very specific seven. I can't find any documentation that explains this behavior or how one might be able to modify the number of results that show up in a gallery.

I'm trying to create an app that allows people to view and add items to calendars they already have access to, but I can't quite figure out if there's a calendar group I need them to have them added to or if there's some other mysterious way for the calendars to auto-populate.

[v-xiaochen-msft]

Hi @AdamD ,

According to your description, let me explain why you encountered this problem.

The calendar is created in outlook.

1\ This is my outlook calendars.

You could see that there are 5 calendars in the picture.

2\ This is my formula and the result in canvas app.

Best Regards,

Wearsky

If my post helps, then please consider Accept it as the solution to help others. Thanks.

[AdamD]

Thank you for your reply @v-xiaochen-msft .Unfortunately my problem isn't the same. Calendars that I have created in "My Calendars" are not all listed. Moreover, some shared calendars (from two other people in my organization) are in the list returned by the function! There doesn't seem to be any rhyme or reason to it on the surface, so I'm wondering if Graph has some special way it organizes calendars and returns them in the get calendar tables function.

Is there a way that I can quickly look up the calendar id of a calendar not listed (but which I have access to) when I use the CalendarGetTables().value function? I've seen posts where people explain how to reveal it in Power Automate but it'd be cumbersome to do it for all the calendars I'd like to get the id values for. Thanks.

[AdamD]

I've done some more research in Graph and what I'm seeing is that the calendar groups are all there, but the listing of the calendars in those groups are incomplete. I have no idea why when I add calendars to the groups in Outlook (whether from the app or OWA), they simply don't return the full list when I run GET /me/calendarGroups/{id}/calendars

It will list the same few, but I have no idea why it selects those and not others. I've added new calendar groups and those groups do show up when I run graph queries, but not the calendars--unless I've created the calendar as blank (i.e. it isn't a shared calendar). So it'll instantly reveal the groups and the calendars created by me, but I've only got two shared calendars belonging to users, and one shared calendar (not associated with a user, just a plain shared mailbox).

I'd be content with the news that viewing shared calendar information isn't available, but it clearly is since I have two people's shared calendars showing up! My permissions for those users aren't special, and I double checked that I don't have any special access to their root mailbox store. I just don't know what the secret sauce is. I've even seen in @Shanescows youtube video about calendaring in PowerApps that he sees a select few calendars for other people in his org. Still can't figure out the why of it all though.

[AdamD · Accepted solution]

I've been messing with this in myriad ways and trying to ask Graph people what's up with why some shared calendars are showing up and yet still not others. As I was looking at my phone I noticed that the only calendars that were listed in my Outlook Mobile App were the exact ones that I was seeing in both the Power Apps function and Graph call. On a hunch, I added another user's shared calendar to my Outlook Mobile App and voila, it shows up now in the Power App function and the graph query!

While I still have no idea what is happening in the background that makes this happen, I figured a solution is a solution and I better post about it here. I've tried adding calendars using both OWA and Outlook proper, and the shared calendars never show up in the function or Graph call. The mobile app will do it though. Strange.

So, if you want to expand the list of calendars exposed by the Office365Outlook.CalendarGetTablesV2().value for any user, have that user add those calendars to their Outlook Mobile App's calendar.

[jconnelly]

Adding the Calendar to the mobile app worked for us. Thank you!

[idanorin]

Thank you for sharing @AdamD!

I am currently combatting the same very strange issue, and was surprised to find that the same solution still works!

I also have a question. Do you know if there were any differences between the calendar types you were trying to use? In my case, I have noticed that MAPI calendars don't show, while REST do, but I am unsure whether this is a connection or just random chance.