Unanswered

filter for dates older than today

(0) Share

Report

Posted on by RD-08041721-0

I believe I have the rest of the flow set up correctly, and it is sending the emails formatted the way I want them to be. The last issue (hopefully) that I am stuck on is that it sends an email for every vendor in the Excel table. Based on copilot the formula being used to filter the dates is: formatDateTime(addDays(utcNow(), -1), 'yyyy-MM-dd'). The excel file is setup for the yyyy-MM-dd format

Also, I'd like to change the date format in the body of the email so it only displays MM/DD/YYYY or it can stay as yyyy-MM-dd. Not sure if one would be easier than the other, I just want the time portion removed (See email attachment)

Please help!! TIA.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Sort by

David_MA 14,546 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Your post says you want to find dates older than today. However. the expression shows you are looking for dates that are less than the current date less 1 day (less than yesterday):

I can spot at least two issues with this filter query, aside from whether you want to check for lt (less than) or gt (greater than):

Cert Expiration is not a valid field name for a filter query. How can I tell? It contains a space. Filter queries use the internal name of the field and not the display name. You can get the internal name by going to your list settings and clicking on the field. The internal name is displayed at the end of the URL.

If the expression for the date in the filter query is formatDateTime(addDays(utcNow(), -1), 'yyyy-MM-dd'), that is the correct format. Filter queries must use an ISO8601 formatted date. However, you need to enclose the expression in single quotes in the filter query. Without the quotes, it considers the value a number.

I need to head to a meeting and will try to remember to follow up later. But hopefully this helps. Note: use the formatDateTime expression to format the date in the e-mail to any format you desire.

Was this reply helpful? Yes No
RD-08041721-0 8 on at

Like (0)

Report
Copy link

Link copied!

Thanks, David MA I'll play around with it based on your reply. What are you referring to when you say "You can get the internal name by going to your list settings and clicking on the field. The internal name is displayed at the end of the URL."

Was this reply helpful? Yes No