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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Automate
Unanswered

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

 

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard