Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Answered

Flow

(0) ShareShare
ReportReport
Posted on by 32

I am trying to do a flow that sends a birthday email to all users in my domain. The condition says that if the current date contains the date of birth (day and month),

 

 

If string(item()) contains string(formatDateTime(utcNow(),'MM-dd"'))

 

But the flow shows me this error:

 

InvalidTemplate. No se pueden procesar las expresiones de lenguaje de plantilla para la acción 'Condición' en la línea '1' y la columna '2646': 'No se admite el parámetro de formato "MM-dd"" de la función de lenguaje de plantilla "formatDateTime". El formato debe ser un carácter especificador de formato único y válido (como "d" o "g") o un patrón de formato personalizado válido (como "'MMMM dd, yyyy" o "hh:mm:ss.ff"). Para obtener información, consulte las cadenas de formato de fecha y hora estándar y las cadenas de formato de fecha y hora personalizadas de .NET Framework.'.

 

Could somebody help me out

thanks

  • v-alzhan-msft Profile Picture
    on at
    Re: Flow

    Hi @alexaristide ,

     

    Please take a try with expression below if you want the minute to be 0:

    formatDateTime(utcNow(),'yyyy-MM-ddTHH:00:ssZ')

     

    Have your problem been solved according to my solution?  If yes, please go ahead and mark the post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!

     

    Best regards,

    Alice       

     

    Community Support Team _ Alice Zhang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Verified answer
    ScottShearer Profile Picture
    25,208 Most Valuable Professional on at
    Re: Flow

    @alexaristide 

    It looks like you have a double quote at the end of you date format - remove it and I think that will resolve the issue.

    DoubleQuote.jpg

     

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,552 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,928 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow