Answered

Get attendees from calendar events for a dropdown

(0) Share

Report

Posted on by Adil Microsoft Employee

Hello,

I am trying to get Attendees of a calendar event into a dropdown by connecting to Office365. I have the following query to get the calendar items:

Office365.CalendarGetItems("Calendar").value

I can get the Organiser, Start, End and other attributes and I can set them as labels but when I try to get Attendees' email adresses and set them on a dropdown or combobox, I cannot.

There is solution to similar problem not exactly. I cannot make that work. The link to that thread is following;

https://powerusers.microsoft.com/t5/PowerApps-Forum/Get-attendees-from-calendar-events/m-p/44784#M18670

Can anyone help me on this pelase?

Thanks a lot in adavnce!

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

v-micsh-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Adil,

If you have the Office365.CalendarGetItems("Calendar").value configured with the Items property of a gallery, then within the Gallery, please add a dropdown control, then specify the items property of the Dropdown with the formula below:

AddColumns(ThisItem.Attendees,"EmailAddress1",EmailAddress.Address).EmailAddress1

Reference:

Regards,

Michael
Adil Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Worked like a charm! Thanks a lot.

How can I make it work for Combobox?
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

How can i check other attendees calendar free time slots ?
is it possible?