2

I am trying to create a flow that takes the Expiry date from the list and sends an email to outlook. This is my list:

enter image description here

This is my flow:

enter image description here

I have added this string (Should send a reminder when 1 day is left for the expiry date):

FormatDateTime(addDays(utcNow('yyyy-MM-dd'), +1)

When I run my flow I always get an error:

enter image description here

Could you help me identify why is there this error informing that:

"The expression "expire date eq '2021-11-18'" is not valid. Creating query failed. clientRequestId: c45f4aad-2999-4ece-a4f5-d56490163c7a serviceRequestId: c45f4aad-2999-4ece-a4f5-d56490163c7a"

1
  • Does my below response answered your question? If yes, Please Upvote(^) and accept as an Answer as it helped you & it will help others with similar question in future to find the correct answer easily. It also removes this question from "Unanswered questions" list. Apr 26 at 14:24

1 Answer 1

0

You have to use the correct internal name (not display name) of your expiry date column in Filter Query.

Check below URL to find out the internal name of SharePoint column:

Find the internal name of SharePoint column.


Also, check how to filter on date columns using correct filter query format. Follow below link for more information:

  1. Filter Created in SP REST API

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.