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
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (60,927)