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

Announcements

News and Announcements icon
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:
  • Verified answer
    v-xiaochen-msft Profile Picture
    Microsoft Employee 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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 394 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 328

#3
WarrenBelz Profile Picture

WarrenBelz 324 Most Valuable Professional

Last 30 days Overall leaderboard