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 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, privacy policy and cookie policy

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