cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jalapiha
Advocate I
Advocate I

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
SameerCh
Power Automate
Power Automate

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

8 REPLIES 8
SameerCh
Power Automate
Power Automate

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" }}
        )
SameerCh
Power Automate
Power Automate

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

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

@SameerCh

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

 

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

mohammadragheb
New Member

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

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

Can I ask you how we can delete event there 

i get this too & dont know how to fix 😞 

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (1,595)