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

[srduval]

@v-siky-msft is there an odata option? If I use the filter after the fact it's not working for me because the initial dump from the get events is apparently truncated, as it doesn't return the record for the person I'm looking for. But if I filter the Odata based on the subject field, then filter for required attendees I get the event id I'm looking for