birthday flow help

[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')

[v-mengmli-msft]

Hi @fdlbe ,

This is because "Send an email" action isn't inside the condition. If you just want to send an email when the condition returns "true", please move "send an email" action inside "Yes".

Best regards,

Rimmon

[fdlbe · Accepted solution]

Ok it's logical ! i try this ,thanks

[v-mengmli-msft]

Hi @fdlbe ,

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

Thanks.

Rimmon

[fdlbe]

 

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]

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]

 

 

[fdlbe]

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

[fdlbe]

 

[v-mengmli-msft]

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]

I see that the flow only works with the current year here 2024

[v-mengmli-msft]

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]

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