Office365.V4CalendarGetItems Filter by raquiredAttendees mail

[Tom_FR]

Hi everybody,

Hope you are doing Ok.

I am using the outlook office 365 connector to get events from my outlook calendar.

My goal is to :

1- Select a contact in a gallery (which i have done )

2- Show the events programmed with this contact only, by filtering using his e-mail

I'm actually trying to use "Office365.V4CalendarGetItems" filter function but i can't find tips on how to use this filter for requiredAttendees e-mail. I don't even get what language i should use !

here you have someone who filtered with start and end date : https://powerusers.microsoft.com/t5/Building-Power-Apps/filter-in-V4CalendarGetItems/td-p/452010

But i couldn't figure out how to use it for requiredattendees e-mail.
Requieredattendees seems to ask for a table

Just in case, my app is in French we use ";" instead of "," as Americans do.

Thank you for you help,

Best regards

Tom

[v-siky-msft · Accepted solution]

Hi @Tom_FR ,

Required attendees for the event are separated by semicolons, please try to Filter function instead of ODATA filter query.

Filter(Office365Outlook.V4CalendarGetItems(Dropdown4.Selected.id).value;GalleryName.Selected.ColumnName in requiredAttendees)

Hope this helps.

Sik

[Tom_FR]

It works perfectly,

Thank you very much  v-siky-msft.

Best regards