web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Automate
Answered

birthday flow help

(0) ShareShare
ReportReport
Posted on by 27

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
Categories:
I have the same question (0)
  • v-mengmli-msft Profile Picture
    Microsoft Employee on at

    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

  • Verified answer
    fdlbe Profile Picture
    27 on at

    Ok it's logical ! i try this ,thanks

  • v-mengmli-msft Profile Picture
    Microsoft Employee on at

    Hi @fdlbe ,

     

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

    Thanks.

    Rimmon

  • fdlbe Profile Picture
    27 on at

    4 birthday.png

    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 Profile Picture
    Microsoft Employee on at

    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 Profile Picture
    27 on at

    5 birthday.png

    6 birthday.png

  • fdlbe Profile Picture
    27 on at

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

  • fdlbe Profile Picture
    27 on at

    7 birthday.png

  • v-mengmli-msft Profile Picture
    Microsoft Employee on at

    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 Profile Picture
    27 on at

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 600

#2
Valantis Profile Picture

Valantis 453

#3
11manish Profile Picture

11manish 356

Last 30 days Overall leaderboard