Hi @Slloyd ,
Please check the following blogs, which mentions that there is currently no support for formatting fields in Filter Query, and the Choice column is not supported in Filter Query.
https://veenstra.me.uk/2018/11/12/microsoft-flow-filter-queries-in-sharepoint-get-items/
Best Regards,
Thanks! Your solution works. However, if I can futher filter in using the Get Items filter query that would be awesome. Here's the expression I'm trying to combine in my filter query which is not working.
formatDateTime(item()['EventDate'],'yyyy-MM-dd') eq addDays(utcNow(),1,'yyyy-MM-dd') and Coverage_Status eq 'Not-Covered'
Thank you very much for the quick response! I will give this a try. One quick question... is there any way to do the filtering via Odata in Get Items setup so as not to pull all the items?
Hi @Slloyd ,
You could use multiple Flows to correspond to these scenarios.
3 days, 1 day before the event, the two Flows are similar, the only difference is to change the parameters in the addDays() function to 3 or 1.
Image reference:
For "2 hours before event", I don't have a suitable solution for you currently. If it is accurate to the hour, it seems that it is difficult to achieve through the current function.
Best Regards,
Michael E. Gernaey
566
Super User 2025 Season 1
David_MA
516
Super User 2025 Season 1
stampcoin
492