Answered

birthday flow help

(0) Share

Report

Posted on by fdlbe

Hello
I created an anniversary feed from a SharePoint list.
The feed runs correctly each day, but it doesn't take into account the anniversary date.
I receive an email every morning when the date has passed
Do I need to add a filter query or date conversion?

the date format is formatDateTime(utcNow(),'dd/MM/yyyy')

bonjour
j’ai crée un flux anniversaire à partir d’une liste sharepoint.
Le flux s’exécute chaque jour correctement mais il ne tient pas compte de la date d’anniversaire.
Je reçois un mail tous les matins alors que la date est dépassée
dois, je dois ajouter une requête de filtre ou une conversion de date ?

le format date est formatDateTime(utcNow(),'dd/MM/yyyy')

2 birthday.png

1 birthday.png

3 birthday.png

All responses (12)

Answers (1)

fdlbe 27 on at

Like (0)

Report

Re: birthday flow help

Really not easy, I want an email to be sent on the anniversary date each year, this according to the SharePoint list
v-mengmli-msft on at

Like (0)

Report

Re: birthday flow help

According to your previous screenshot, this is due to the setting of your condition.
The value of utcNow() is the date on which the flow runs, and this value contains 2024 now. For the date doesn't contain 2024, it doesn't match the Condition.
fdlbe 27 on at

Like (0)

Report

Re: birthday flow help

I see that the flow only works with the current year here 2024
v-mengmli-msft on at

Like (0)

Report
Re: birthday flow help

Hi @fdlbe,

The format of date column in SP list is yyyy-MM-dd in outputs of flow.
Please modify your expression:
formatDateTime(utcNow(),'yyyy-MM-dd')
fdlbe 27 on at

Like (0)

Report

Re: birthday flow help
fdlbe 27 on at

Like (0)

Report

Re: birthday flow help

le format date est formatDateTime(utcNow(),'dd/MM/yyyy')
fdlbe 27 on at

Like (0)

Report

Re: birthday flow help
v-mengmli-msft on at

Like (0)

Report

Re: birthday flow help

Hi @fdlbe ,

Could you please show some screenshots about setting of each action?
There are several reasons why the email was not sent:
1. There are no records that match the criteria.
2. There are some minor issues with your condition settings. I need to know how you want to set up the condition and what type of values need to be used in the condition.
fdlbe 27 on at

Like (0)

Report

Re: birthday flow help

After correcting the email condition to yes, the flow tells me no error, but I don't receive any test emails. My SP list is fine with the format date day month year, need to do a conversion somewhere?
v-mengmli-msft on at

Like (0)

Report

Re: birthday flow help

Hi @fdlbe ,

If my answer helps you solve the problem, hope you can accept it as a solution.
Thanks.
Rimmon