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
Flow Staff SameerCh
Flow 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" }}
        )
7 REPLIES 7
Flow Staff SameerCh
Flow 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" }}
        )
Flow Staff SameerCh
Flow 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. 

Jvaughan
Level: Powered On

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
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

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

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Top Kudoed Authors
Users Online
Currently online: 49 members 4,927 guests
Please welcome our newest community members: