Microsoft flow not filtering SharePoint list by date to send email

0
votes

First thing first I am very new to Microsoft Flow and think I may have bit off more than I can chew.

I have a SharePoint list with multiple dates that I plan on using to send communication. I would like FLOW to examine my SharePoint list and for each record where Today's Date matches the "T-21" date send an email. T-21 date in SharePoint is Date only format.

Now I figured out to use a trigger, get the items from my SharePoint list, but the problem I am having is the filter/date compare.

Used Compose to format utcnow to "M/d/yyyy" format so it matches my SharePoint list. But either I get an error message or the FLOW ignores the filter/date compare and sends everyone an email even those where "t-21" does not match.

  • Trigger
  • Compose (format utcnow)
  • Get Items from SharePoint list (Filter query??)
  • Condition (T-21 = Compose Date from earlier; NOT WORKING)
  • If yes, send email
  • If no, do nothing

Hopefully this explains things.

Thanks ahead of time.

1
sharepointpower-automate

1 Answers

1
votes

Check out the following post I stumbled upon while I was trying to set up my flows. This person has the same use case as you, in that they trigger something based upon the date. There is code included in the post as well to help you solve the date condition problem you're having. The link: Post explaining possible solution to your question