Answered

Office365Outlook V4CalendarGetItems filter by string

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

I am trying to get the Office365Outlook.V4CalendarGetItems to filter events that have a specific keyword (in this case, a project ID). I am getting an invalid filter clause message. Any thoughts on what I need to do differently?

Office365Outlook.V4CalendarGetItems(
ProvCalendar,
{'$filter': "substringof(body, '" & ActiveProject.WorkOrderId & "')"}
).value

ProvCalendar - this is a variable containing the calendar ID. It is correct as it works elsewhere in the app in this function.
ActiveProject.WorkOrderId - this is a variable containing a string with the work order ID that I want to filter for.

I've also tried ActiveProject.WorkOrderId in body with no success either.

Ideally, I'd search subject and body, but I will settle for just one for now as the other should work the same way (or so I am assuming).

Thanks!

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

v-siky-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anonymous ,

Actually, you can try to use Filter() function to filter the events. Please try with this.

Filter(Office365Outlook.V4CalendarGetItems(ProvCalendar).value, ActiveProject.WorkOrderId in subject || ActiveProject.WorkOrderId in body)

Hope this helps
Sik
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Thank you -- and this has been my workaround, but I was trying to offload that to server-side using the built in ODATA filter. Using Filter() in this context seems to pull in all results, then process locally making the app super sluggish. Maybe I am wrong in that assumption, but that is how it appears from user side.

No one seems to have a good answer for using the ODATA filter, which makes me wonder why they even have it if there is no good documentation for it.
Verified answer

v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

If you want to learn more about Odata filter, please review these blogs Basic Tutorial System Query Option $filter

However, the body of event doesn't support filter, reference from here, so the formula returns the error of invalid filter clause.

In addition, the Subject of event is filterable, and the Contains() function is more suitable, so the odata filter is like this:

Office365Outlook.V4CalendarGetItems(
ProvCalendar,
{'$filter': "Contains(subject, '" & ActiveProject.WorkOrderId & "')"}
).value

Hope this helps.

Sik