Announcements
43
Hi
I have a recurrance flow and i'm looking to send the document owner an email notification 30 days prior to the Review Date.
I'm having some problems with the filter query, can anyone advise please? below is a copy of flow and i'm using filter query
formatDateTime(addDays(utcnow(),-30),'yyyy-MM-dd')
Hi @yashag2255
Thanks for replying. Are you able to guide me to an example of this flow please
You need to get all the records and the use an apply to each on the returned list and use the condition control to filter the values by comparing the attributes in the condition statement
thanks
andrea
Hey @AndreaBurgess
Currently the calculated columns are not supported in filter queries. You need to get all the records and the use an apply to each on the returned list and use the condition control to filter the values by comparing the attributes in the condition statement.
Hope this Helps!
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
Thank you @yashag2255
Share
Report
All responses (
Answers (
{
"status": 400,
"message": "The field 'Review_x0020_Date' of type 'Calculated' cannot be used in the query filter expression.\r\nclientRequestId: b18d7713-26e3-4076-a4ed-7953a56a78b9\r\nserviceRequestId: b18d7713-26e3-4076-a4ed-7953a56a78b9"
}
Should look like this:
Hope this Helps!
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
Thanks for replying @yashag2255 Yes the date does have single quotes within the filter query.
it looks like this at the moment
Review_x0020_Date eq 'formatDateTime(addDays(utcnow(),30),'yyyy-MM-dd')'
what am I missing? (sorry)
You need to have the date value in a single quote:
Review_x0020_Date eq '2019-11-01'
You need to add the single quotes in the filter query expression as Review_x0020_Date eq 'insert the formula here'
Hope this Helps!
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
Hi
The error I am getting is
{
"status": 400,
"message": "The expression \"Review_x0020_Date eq 2019-11-01\" is not valid.\r\nclientRequestId: aa7dfee9-ee8b-4efe-803c-68d14c278d4b\r\nserviceRequestId: aa7dfee9-ee8b-4efe-803c-68d14c278d4b"
}I have also tried the above advice and it changes the error to column is not valid
Hey @AndreaBurgess
Can you try filter query as:
ReviewDate eq 'expression'
ensure that the expression is in single quotes. Instead of the _X0020_ for space directly write the column name as ReviewDate and if it fails, try with Review_x0020_Date eq 'exp' too. The exoression should be in single quotes is the first issue and then see the column name part.
Hope this Helps!
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
