Unanswered

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

(0) Share

Report

Posted on 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:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-xiaochen-msft on at

Like (0)

Report
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

Was this reply helpful? Yes No
AlexLindberg 87 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
AlexLindberg 87 on at

Like (0)

Report
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.

Was this reply helpful? Yes No