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
Unanswered

Flow is failing

(1) ShareShare
ReportReport
Posted on by 13

Hello Community,

 

I am getting the below error message when trying to run flow. Please what might be the issue

 

Unable to process template language expressions for action 'Condition_3' at line '0' and column '0': 'The template language function 'formatDateTime' expects its first parameter to be of type string. The provided value is of type 'Null'.

 

Categories:
  • SudeepGhatakNZ Profile Picture
    14,396 Most Valuable Professional on at

    What is means is that date/dates you are formatting might be null. Can you post a screenshot of your flow?

     

  • jfeghali Profile Picture
    68 on at

    It seems you are passing a Null value when a date string is expected. To fix this issue, you will need a condition, which will only insert if the value is not null or empty. There are multiple ways to do so, the best one depends on your current flow. Perhaps provide us with a couple of screenshots, as to help us help you better.

  • Tunnex_ak Profile Picture
    13 on at

    Tunnex_ak_0-1708435157951.png

     

  • Tunnex_ak Profile Picture
    13 on at

    Tunnex_ak_1-1708435181049.png

     

  • jfeghali Profile Picture
    68 on at

    Thank you for the screenshots. In your case, there is a simple solution. In the "apply to each" add a condition. Check if the date field is equal to null (insert null as a function, not text). If it is Null, insert your error handling, if it is not, then insert your compose action. 

     

    If you need any more assistance, don't hesitate to ask.

     

    If my answer helped you, please consider accepting it as a solution 🙂

     

     

  • SudeepGhatakNZ Profile Picture
    14,396 Most Valuable Professional on at

    @jfeghali 

     

    Use these expressions in your condition before referring the date field in the compose

    SudeepGhatakNZ_0-1708461971333.png

     

     

  • jfeghali Profile Picture
    68 on at

    You're right, this method is the way to go in this case. 

     

    @Tunnex_ak I would suggest you try @SudeepGhatakNZ 's method, as it is fairly easy and foolproof. 

     

    I would also suggest adding some type of error handling, such as informing you via mail or saving an error log somewhere.

     

    If you need any more assistance, don't hesitate to ask 🙂

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
11manish Profile Picture

11manish 298 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 289

#3
Henil Profile Picture

Henil 125

Last 30 days Overall leaderboard