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 Platform Community / Forums / Power Automate / String was not recogni...
Power Automate
Unanswered

String was not recognized as a valid DateTime

(1) ShareShare
ReportReport
Posted on by 14

Hallo,

 

I have a German SharePoint site with a regional setting for Germany.

formatDateTime(triggerBody()?['field_3'], 'dd.MM.yyyy')

Image

 

Image

What do I make wrong?

Thank you.

 

Categories:
I have the same question (0)
  • creativeopinion Profile Picture
    10,508 Moderator on at
    The format of your date should be 'yyyy-MM-dd'. When working with an automated trigger in your flow, you should consider using Trigger Conditions. This way your flow will only trigger when the item created meets your criteria rather than trigger each time an item is created and run a condition check.
     
    Check out this YT Tutorial for more details on how to add Trigger Conditions to your flow: 4 Ways You Can Use Trigger Conditions in Your Microsoft Power Automate Flow

    If you are using an Automated Cloud flow trigger in your flow—you need to consider adding trigger conditions.

    Do YOU 🫵 know what a trigger condition is? Trigger conditions can be set in most flow triggers. These conditions you set must be true for the trigger to fire. In this Power Automate tutorial, I’m going to show you how to use trigger conditions in your flows to control when your Power Automate flows trigger.
    If your plan has flow run limits—you can avoid triggering your flows unnecessarily by using trigger conditions.
    I’ll cover four different flow examples that would benefit from trigger conditions:

    ⚡️ Triggering a flow when a column is changed to a specific value
    ⚡️ Triggering a Flow When an Event Updated or Deleted
    ⚡️ Triggering a Flow When a New Folder is Created
    ⚡️ Triggering a Flow When a Specific Email is Received I’ll also show you a trick on how to easily create the expressions needed and give you a few tips on how to troubleshoot your flow.

    IN THIS VIDEO:
    ✅ Four different flows that would benefit from trigger conditions
    ✅ What is a trigger condition?
    ✅ How to add a trigger condition to your flow
    ✅ How to trigger a flow when a column is changed to a specific value
    ✅ How to trigger a flow when an event is updated or Deleted
    ✅ How to trigger a flow when a new folder is created
    ✅ How to trigger a flow when a specific email is received
    ✅ How to troubleshoot a trigger condition
    ✅ How to prevent case sensitivity issues with a trigger condition
    ✅ How to use the filter array action to easily compose an expression that can be used in a trigger condition
     
    -----

    You might also be interested in this YT Tutorial: 

    How to Work with 📆 Dates in Power Automate | Example Scenarios and Tips & Tricks
        
    Are you easily stumped when working with Dates in Power Automate? In this Power Automate tutorial, I’ll show you how to compose an expression that will return a future date, a past date, how to count the number of days between two dates, how to check for a birthdate and anniversary date as well as tips and tricks when working with dates in Power Automate. 
        
    I’ll cover some common use cases and concepts that can help you to build better Power Automate flows. Feel free to skip ahead using the timestamps listed below. I’ve also linked a few other tutorials that you might be interested in as well.
        
    IN THIS VIDEO:
    ✅ 4 Date Functions You Need to Know
    ✅ How to use the Convert Time Zone Action
    ✅ How to Get a Future Date
    ✅ How to Get a Past Date
    ✅ How to Return SharePoint Items Due in a Number of Days
    ✅ How to Return SharePoint Items Due within a Date Range
    ✅ How to write a Filter Query for SharePoint Items Due in 30, 60 and 90 Days
    ✅ How to Calculate the Number of Days between Two Dates
    ✅ How to Check for a Birthdate and Anniversary Date
    ✅ How to work with Dates and Times in Excel
    ✅ How to use a Manual Trigger with Date Input
    ✅ How to Output Dynamic Text with an Expression
    ✅ How to Check if a Date Falls on a Weekend

     

    Hope this helps!

    Consider giving me a ❤️ if you liked my response!

    👉 Level up your Power Automate skills by checking out my tutorials on YouTube
    👉 Tips and Tricks on TikTok and Instagram​​​​​​​

  • lbendlin Profile Picture
    8,649 Super User 2026 Season 1 on at
    please show an example raw value for [field_3]
  • Leon1976 Profile Picture
    14 on at
    Hi ibendlin,
     
    that what I write
     
    For Beginn time
    formatDateTime(triggerBody()?['field_2'], 'dd/MM/yyyy')
     
    End Time
    formatDateTime(triggerBody()?['field_3'], 'dd.MM.yyyy')
     
    And used action 
    Outlook event v4
     
    Thank you for help
     
     
  • Leon1976 Profile Picture
    14 on at
    Entry at the beginning is:
     
  • creativeopinion Profile Picture
    10,508 Moderator on at
    When using it in an Outlook Event action you must provide a valid datetime format that includes a time. The start date and time should be provided in UTC.
     
    yyyy-MM-ddT00:00:00Z 
     
    Hope this helps!

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 592

#2
Valantis Profile Picture

Valantis 340

#3
11manish Profile Picture

11manish 284

Last 30 days Overall leaderboard