cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jalapiha
Level: Powered On

Office 365 Calendar events won't show

Hi,

 

I'm trying to display calendar events from Office 365 in PowerApps, but only I get is errors. How CalendarGetItems(Table ....) should work?

1 ACCEPTED SOLUTION

Accepted Solutions
Power Automate Staff SameerCh
Power Automate Staff

Re: Office 365 Calendar events won't show

What errors are you getting?

 

I wrote this up some time back so that our docs can be updated (which is still not done unfortunately).  Hope this helps though.

 

Here is how you do this:

  1. Create a Blank App
  2. Add an “Office 365 Outlook” data source.
  3. Insert a Drop down to show a list of available Calendars. Rename the control to “calendarDropDown”.
  4. Set the Items property to: Office365.CalendarGetTables().value
    powerapps1.jpg
    You should see a list of your available calendars:
    powerapps2.jpg
  5. Insert a Gallery to show the list of calendar items.
  6. Set the Items property to: Office365.CalendarGetItems(calendarDropDown.Selected.Name).value
    You should see the list of items in the selected calendar.
  7. Format the gallery as necessary by adding/deleting controls.  Some of the properties you can use include “Subject”, “Start”, “End”, “WebLink”, “BodyPreview”, etc.
    powerapps3.jpg
  8. Format the gallery as necessary by adding/deleting controls.  Some of the properties you can use include “Subject”, “Start”, “End”, “WebLink”, “BodyPreview”, etc.
  9. To create a calendar item, you can insert controls for taking user inputs and call the following operation on the connector:
    Office365.CalendarPostItem(
        calendarDropDown2.Selected.Name,
        Text(startDatePicker.SelectedDate, DateTimeFormat.UTC),
        subjectTextInput.Text,
        { Body: { Content: messageTextInput.Text, ContentType: "HTML" }}
        )

View solution in original post

7 REPLIES 7
Power Automate Staff SameerCh
Power Automate Staff

Re: Office 365 Calendar events won't show

What errors are you getting?

 

I wrote this up some time back so that our docs can be updated (which is still not done unfortunately).  Hope this helps though.

 

Here is how you do this:

  1. Create a Blank App
  2. Add an “Office 365 Outlook” data source.
  3. Insert a Drop down to show a list of available Calendars. Rename the control to “calendarDropDown”.
  4. Set the Items property to: Office365.CalendarGetTables().value
    powerapps1.jpg
    You should see a list of your available calendars:
    powerapps2.jpg
  5. Insert a Gallery to show the list of calendar items.
  6. Set the Items property to: Office365.CalendarGetItems(calendarDropDown.Selected.Name).value
    You should see the list of items in the selected calendar.
  7. Format the gallery as necessary by adding/deleting controls.  Some of the properties you can use include “Subject”, “Start”, “End”, “WebLink”, “BodyPreview”, etc.
    powerapps3.jpg
  8. Format the gallery as necessary by adding/deleting controls.  Some of the properties you can use include “Subject”, “Start”, “End”, “WebLink”, “BodyPreview”, etc.
  9. To create a calendar item, you can insert controls for taking user inputs and call the following operation on the connector:
    Office365.CalendarPostItem(
        calendarDropDown2.Selected.Name,
        Text(startDatePicker.SelectedDate, DateTimeFormat.UTC),
        subjectTextInput.Text,
        { Body: { Content: messageTextInput.Text, ContentType: "HTML" }}
        )

View solution in original post

Power Automate Staff SameerCh
Power Automate Staff

Re: Office 365 Calendar events won't show

This is already fixed.  I will show you the details (if I can post this successfully).

jalapiha
Level: Powered On

Re: Office 365 Calendar events won't show

Thanks a lot, now it works. I had missed the .value from the end and because of that I didn't get any values but only errors. 

Anonymous
Not applicable

Re: Office 365 Calendar events won't show

@SameerCh

How did you you format it to look like the picture?

 

Highlighted
Ambuja
Level: Powered On

Re: Office 365 Calendar events won't show

Hi Did you get the wayout have calendar view for the meeting room?, if yes please let me know

mohammadragheb
Level: Power Up

Re: Office 365 Calendar events won't show

guys do we know why when using this method Office365.CalendarGetTables().value i don't get all the calendars available in my outlook i have connected my outlook to a couple of SPO Calendars but when i try to retrive this in power app it shows only my old calendars in the drop dow

m0le
Level: Powered On

Re: Office 365 Calendar events won't show

Thanks for this quick tutorial it helped me understand how it works.

Can I ask you how we can delete event there 

Helpful resources

Announcements
thirdimage

Power Platform 24

Check it out!

thirdimage

New Badges

Check it out!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors
Users online (6,229)