web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Display Outlook Calend...
Power Apps
Answered

Display Outlook Calendar Event with Attendees and Responses

(0) ShareShare
ReportReport
Posted on by 99

I'm trying to connect to an Outlook calendar and display a list of events in my gallery. Then, when an event is selected, I want to display a second gallery that shows the required attendees along with each attendees response (accepted, declined, etc.)

 

In my first gallery, the events are displaying properly using the follow:

SortByColumns(
 Office365Outlook.GetEventsCalendarViewV3(
 varUserCalendarId,
 Text(Date(2023,09,18),DateTimeFormat.UTC),
 Text(Date(2023,09,22),DateTimeFormat.UTC)
).value,
"start",SortOrder.Descending)

 

I have set the OnSelect property in gallery 1 to this:

Set(varRecord,ThisItem);

 

I successfully call the event into the second gallery using this in the Items property:

Gallery1.Selected

 

Then I have two labels. One for Attendees using the below. This displays a semi colon separated list of attendees.

ThisItem.requiredAttendees

 

The second label using the below only shows my response:

ThisItem.responseType

 

What I really want in the second gallery is to list each attendee on a separate line, along with their associated response. Is there a way to accomplish this?

 

If anyone knows a way to do this, I would be grateful for any help!

 

Categories:
I have the same question (0)
  • Verified answer
    v-xiaochen-msft Profile Picture
    on at

    Hi @tsparkman ,

     

    Please try this

    vxiaochenmsft_0-1694744965781.png

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

    vxiaochenmsft_1-1694744991726.png

    ForAll(Table(var),{email:Text(Value.emailAddress.address),response:Text(Value.status.response)})

     

    Best Regards,

    Wearsky

  • tsparkman Profile Picture
    99 on at

    Thank you so much @v-xiaochen-msft! This worked exactly as I had hoped. I truly appreciate your help with this!

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 739 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 343 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard