I'm trying to use the ODATA filter on the Get Events v2 action and it seems to be broken now after having worked in the past.
My filter is as follows: ShowAs ne 'Oof' and Start ge 2017-12-06T00:00:00.0000000Z and Start le 2017-12-07T00:00:00.0000000Z
This always returns empty results.
If I remove the date filters, results are returned but this is not a workable solution for I'm trying to do: create a summary of events on the next day to automatically post on Facebook.
I haven't tested ODATA myself with Calendar; but I have used it with Sharepoint Lists.
When dealing with Sharepoint, sometimes I need to add a Fiter Array action block instead of ODATA filters. You can see an example here:
Hope this helps
For Date and Time field, you need to use Date and Time functions day() month() year() hour() minute() second() to get the day, month, year first then check whether a date time falls inside a recurrent date time pattern.
Please check this doc for more details:
Please have a try with it on your side.
Sorry, I can't get this to work. If I use the day function in the filter like this:
The query filter contains one or more invalid nodes. clientRequestId: bb28fb4b-6d23-437c-843f-53d775904c79
What am I doing wrong on the syntax?
Check out the News & Announcements to learn more.
Check out the new Power Platform Community Connections gallery!
Congratulations, the new Super User Season 2 for 2021 has started!
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.