Power Platform Community Forum Thread Details

First, let me say that this forum has provided me with enormous help and understanding. I would say my knowledge of coding is minimal but not impossible. I am willing to listen, learn, and understand to improve my processes. Thank you.

I am trying to write a flow to send an email when our annual training logs need to be updated by each employee. Now, I've found multiple sources for this through this forum, youtube videos, and other blogs. In fact, I created three very different flows, each with different parameters and none of them have worked. But what I'm trying to do is have the flow check a SP library for a date, then send an email to let employees know that they have 15 days to update their training logs. The date is the same for everyone but for flow checking, I changed my personal date to 7/1/2021 (within 15 days from today's date).

When running each of the flows that I have written, I get basically the same error.

Recurrence->Scope, Compose flow: The expression "Expiration Date eq '07/01/2021'" is not valid. Creating query failed.
clientRequestId: 25e10e86-899e-4705-815c-c0c79af67030
serviceRequestId: 25e10e86-899e-4705-815c-c0c79af67030

Recurrence->Get future time, Substring, Get items flow: The expression "Expiration Date eq '2021-07-02'" is not valid. Creating query failed.
clientRequestId: 5453c10e-2e3c-47e2-80d3-413722984fa3
serviceRequestId: 5453c10e-2e3c-47e2-80d3-413722984fa3

Recurrence->Get items, Apply to each flow: Says it ran successfully but no email was received on my end (which is the result I was expecting for the flow to run successfully). However, it does say in Warnings (Get items): "Updating action 'Get items' to use OData filter queries can improve the performance of your flow. "

I am not sure which flow someone wants to take a stab at, but the second flow is my least developed flow (because I was saving along the way and stopped the moment it failed. The first one is the one that makes the most sense to my brain.