Get Calendar Contents of a Team

(0) Share

Report

Posted on by karimabdelrazek

294

Hi,

I am trying to get the calendar contents from Sharepoint of any MSTeam. I would like to be able to select the calendar from a dropdown and have its contents displayed in a gallery. Is it doable? Solution must not use any premium connectors and should be low code/ no code (I'm not a techie by any means). Thanks!!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

v-jefferni on at

Like (1)

Report
Hi @karimabdelrazek ,

Could you please share more details about your scenario? What kind of calendar would you like to retrieve, SharePoint group site calendar list or O365 Outlook calendar?

If you want to retrieve calendar apps from SharePoint group sites, which are just like lists, you could create connectors to connect with them:
1. Choose Sharepoint connector
2. Choose a site
3. Type in the calender list name then check, click connect:

You could find the calendar name in Site contents.

After connecting to all calendars of group sites, on the calendar contents screen, add a Drop down with the Items of a collection for users to select.
[“Group1 Calendar”, “Group2 Calendar”, “Group3 Calendar”]

Then you could use a Gallery with the Items:

Switch(Dropdown.Selected.Value, “Group1 Calendar”, ‘Group1 Calendar’ , “Group2 Calendar”, ‘Group2 Calendar’ , “Group3 Calendar”, ‘Group3 Calendar’)

Note:
App users should be an owner or member in those groups and with the permission to edit so that it would be able to update or modify the calendars.

If you want to retrieve all calendars of O365 teams from O365 outlook, I’m afraid there is no way to achieve your goal. Users could only get the teams list owned by themselves, you are not able to retrieve all teams into a dropdown for users to select. And user could only see calendar events owned by itself.

Hope it helps.

Best regards,
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
karimabdelrazek 294 on at

Like (0)

Report
@v-jefferni Thank you so much for your prompt and detailed reply. We're almost there. My scenario is as follows:
An Admin creates a Teams site for each customer using the "CreateATeam" function in the MSTeams Connector.
In a separate step, employees are added to their Teams sites. A single employee can be a member of multiple Teams
Using my PowerApp, I would like the employee to select the customer name from a dropdown and have the calendar events displayed in a gallery.
I would like to try and avoid a manual step of entering calendar names into the list if that's at all possible.
Many thanks!

Was this reply helpful? Yes No
v-jefferni on at

Like (1)

Report
Hi @karimabdelrazek ,

You could use Microsoft Teams connector to get all teams:
https://docs.microsoft.com/en-us/connectors/teams/#list-teams

Apply MicrosoftTeams.GetAllTeams().value on the Items of the Dropdown, then users would be able to see all teams they are a member of.

Then on the gallery, you could use below formula:

If(Dropdown.selected.displayName="TeamName1",CalendarTeamName1,Dropdown.selected.displayName="TeamName2",CalendarTeamName2,Dropdown.selected.displayName="TeamName3",CalendarTeamName3)

You will have to add all calendar list names in that formula so that each user could find the proper calendar.

Hope this helps.

Best regards,
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No