cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Office365.V4CalendarGetItems Filter by raquiredAttendees mail

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

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

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

 

View solution in original post

2 REPLIES 2
Community Support
Community Support

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

 

View solution in original post

It works perfectly,

 

Thank you very much 

 

Helpful resources

Announcements
News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

Power Apps Community Call

Power Apps Community Call- January

Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

Top Solution Authors
Top Kudoed Authors
Users online (5,539)