You’re offline. This is a read only version of the page.
I have a Send HTTP request Action in my flow. Action is working fine only last filer condition is not working (EventDate gt '@{formatDateTime(utcNow(), 'MM/dd/yyyy')}'). I am able to select properties and filter fRecurrence eq '0' but event date filter is not working.
I tried follwing in Uri
_api/lists/getbytitle('@{items('For_each_Calendar_List')}')/items?$select=EndDate,EventDate,Days,Title,fRecurrence,Author/Title,Author/EMail&$expand=Author&$filter=(fRecurrence eq '0')& (EventDate gt '@{formatDateTime(utcNow(), 'MM/dd/yyyy')}')
_api/lists/getbytitle('@{items('For_each_Calendar_List')}')/items?$select=EndDate,EventDate,Days,Title,fRecurrence,Author/Title,Author/EMail&$expand=Author&$filter=(fRecurrence eq '0') and (EventDate gt '@{formatDateTime(utcNow(), 'MM/dd/yyyy')}')
I want to filter both frecurrence and Eventdate conditions. Looking for suggestions please. I would appreciate any help.
Good to know! How is it different to what you were trying earlier?
Thank you for the suggestion.The flow and filter worked with the follwing uri:
_api/lists/getbytitle('@{items('For_each_Calendar_List')}')/items?$select=EndDate,EventDate,Days,Title,fRecurrence,Author/Title,Author/EMail&$expand=Author&$filter=(fRecurrence eq '0') and (EventDate gt '@{formatDateTime(utcNow(), 'MM/dd/yyyy')}')
Thank you.
@SudeepGhatakNZ "yyyy-MM-dd" format didn't help. Still not able to filter the EventDate.
SharePoint rest queries support the "yyyy-MM-dd" format because internally SharePoint saves the dates in this format 2023-01-13T21:00:00.000Z
#1
Michael E. Gernaey
497
Super User 2025 Season 2
#2
David_MA
436
Super User 2025 Season 2
#3
Riyaz_riz11
244
Super User 2025 Season 2
Share
Report
All responses (
Answers (
