Weekly birthday reminders at the start of every week?

(0) Share

Report

Posted on by Henry G Smith

166

Hi,

I posted about this last week - I thought I had solved the problem, but the flow seems to be wrong.

I want to create a flow that triggers every Monday and send me a list of peoples birthdays that sit within the week. This is not a flow that send an email on the persons birthday. But rather pulls a list of all the upcoming birthday this week.

I have created this flow:

using: to pull the start of the week

addDays(utcNow(),int(concat('-',dayOfWeek(utcNow()))),'d')

& for the end of the week

addDays(utcNow(),sub(6,dayOfWeek(utcNow())),'d')

I created a condition so that the converted birthdates in short pattern time are greater than and less than (essentially saying that the birthdate needs to sit within the start and end of the week.)

However, for some reason the flow is pulling everyone's birthday who sits within the this month rather than this week.

I know someone mentioned on a previous post that I should use ticks? however, I cant seem to find any good material that explains this in depth.

I'm pulling my hair out with this one, hopefully someone can provide me some guidance?

Regards,

Henry

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (0)

Report
Hello @DynamicsHS ,
please try to check the day of month value:
1. Add a "Compose" action in which put the following expression:
dayofMonth(utcNow())
2. Add another "Compose" action putting the following expression:
add(outputs('Compose-DayOfMonthUtcNow'),6)
3. Within the Apply to each loop, add a "Compose" action putting the following expression:
dayofMonth(item()['birthdate'])
4. in the Condition control add this expression:
and(greater(outputs('Compose-DayOfMonthBirthdate'),outputs('Compose-DayOfMonthUtcNow')),less(outputs('Compose-DayOfMonthBirthdate'),outputs('Compose-Add6Days')))
if equal to
true

Append to Array variable.

Here the full flow:
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
BR,
Marco

Was this reply helpful? Yes No
Henry G Smith 166 on at

Like (1)

Report

Hi Marco,

Thank you. This worked - I had the start of the week and end of the week formulas in the apply to each - they needed to be outside of it like yours.

Was this reply helpful? Yes No