Answered

How to determine an invitee's status (Accepted, Tentative, Decline) to a O365 Calendar invitation?

Like (0) Share

Report

Posted on 20 May 2024 18:25:20 by AlexLindberg

I want to create a gallery of all required invitees and their response (Accepted, Tentative, Declined) to an Office 365 Calendar invitation. I'm able to get the invites and other meeting information, but I am unable to figure out how to get their status.

I have connected and configured Office365Users and Office365Outlook connectors.

From other posts:

Get list of calendars: (Note the use if the current APIs CalendarGetTablesV2 and GetEventsCalendarViewV3 - FYI: watch out for the case change in the attributes from previous API versions)

Set(MyCalendarID, LookUp(Office365Outlook.CalendarGetTablesV2().value,name = "MyCalendarName").id);
Set(UTCNow,Text(DateAdd(Now(),0,TimeUnit.Minutes),DateTimeFormat.UTC));
Set(UTCNext,Text(DateAdd(Now(),44640,TimeUnit.Minutes),DateTimeFormat.UTC));
Set(MyCalendarValues,Office365Outlook.GetEventsCalendarViewV3(MyCalendarID,UTCNow,UTCNext).value)

Setup collections for the meeting lists:

Sort(MyCalendarValues,start)

ThisItem.subject, (etc) for gallery.

Setup Collection for Required Users to display in a 2nd gallery:

ClearCollect(RequiredAttendance,Split(ThisItem.requiredAttendees,";"))

Get User's name to display in the gallery:

First(Office365Users.SearchUserV2({searchTerm: ThisItem.Value ,top: 1}).value).DisplayName

But I can't find (google) how to also display the user's response to the invite (Accepted, Declined or Tentative).

As always, thank you for your time.

Alex

Categories:

Connectors

All responses (3)

Answers (1)

AlexLindberg 87 on 24 May 2024 at 22:25:42

Like (0)

Report
Re: How to determine an invitee's status (Accepted, Tentative, Decline) to a O365 Calendar invitation?

One more quick question - Can you provide the code associated with your dropdown?

In my OnStart I have:

ClearCollect(CalList, Office365Outlook.CalendarGetTablesV2().value);

The Items Items value of the DropDown is set to CalList.

The OnSelect of the DropDown is set to:

Set(MyCalendarID, CalendarDropDown.Selected.id); ClearCollect(MyCalendarValues,Office365Outlook.GetEventsCalendarViewV3(MyCalendarID,UTCNow,UTCNext).value);

The gallery uses MyCalendarValues as the data source.

This seems very sluggish and at times, the gallery does not update. Any suggestions?

As always, thank you for your time.
AlexLindberg 87 on 21 May 2024 at 12:25:54

Like (0)

Report

Re: How to determine an invitee's status (Accepted, Tentative, Decline) to a O365 Calendar invitation?

Thank you @v-xiaochen-msft.

I ponder why is so difficult to get normal information regarding user status to an event. I was hoping for a simple API.
Verified answer

v-xiaochen-msft on 21 May 2024 at 02:13:00

Like (0)

Report
Re: How to determine an invitee's status (Accepted, Tentative, Decline) to a O365 Calendar invitation?

Hi @AlexLindberg ,

Please try this

Set(var,Office365Outlook.HttpRequest("https://graph.microsoft.com/v1.0/users/"&User().Email&"/calendars/"&Dropdown1.Selected.id&"/events/"&Gallery1.Selected.id,"GET",""))

ForAll(var.attendees,{status:Text(ThisRecord.status.response),userName:Text(ThisRecord.emailAddress.name)})

Best Regards,

Wearsky