Power Platform Community Forum Thread Details

Hello,

I thought this flow was working but turns out I was wrong. 🙂 In theory, it is supposed to run every Monday, check a list of birthdays, and send an email to admin showing who has a birthday from the Sunday of that week (so one day before the email runs) through Saturday.

So, if today is the 21st, the flow pulls birthdays from the 20th-26th.

Here is the filter array I was using, along with the flow. It's working... but it's not catching those Sunday birthdays and I can't figure out why.

@And(equals(empty(item()?['oc9t']), false), and(greaterOrEquals(formatdateTime(item()?['oc9t'], concat(utcNow('yyyy'), 'MM-dd')), addDays(utcNow(), -1)), lessOrEquals(formatdateTime(item()?['oc9t'], concat(utcNow('yyyy'), 'MM-dd')), addDays(utcNow(), 5))))