Showing results for 
Search instead for 
Did you mean: 

FLOW (Get Items) Filter SharePoint list on Date

I have a filter query with this


substringof('variable', 'column') and EventDate Ge 'utcNow('yyyy-MM-ddTHH:mm:ssZ')' (expression)


It keeps getting not valid error for some reasons. It is working with substring of. I cannot seem to make it work with the dates though. 

Community Support
Community Support

Re: FLOW (Get Items) Filter SharePoint list on Date

Hi @KarlChristopher,


Please make sure you entered the code under Expression tab likes below. I have made the following test and it works fine.

Note: In the Filter query field, please make sure the code is surrounded by a single quote.


If you are still having the issue, please feel free post back with more details.


Best regards,

Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: FLOW (Get Items) Filter SharePoint list on Date

  "status": 400,
  "message": "The expression \"substringof('test',  Router_x0020_name_x003a_) and EventDate Gt '2018-09-28T05:40:44Z'  and EndDate Lt '2018-09-28T05:40:44Z'\" is not valid.\r\nclientRequestId: 4f1dde96-98a9-492d-a8b4-d80950fa59aa\r\nserviceRequestId: e70d939e-702b-7000-47c0-98db7844f805"

Here's the error I am getting.




Re: FLOW (Get Items) Filter SharePoint list on Date

Would be amazing if you could help me on this. Feels like I should not have any issue or am I missing something?

Helpful resources


Microsoft Ignite 2020

Check out the announcement of Power Platform content at Microsoft Ignite!


Experience what's new for Power Automate

Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.


Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Users online (9,053)