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 Platform Community / Forums / Copilot Studio / Flow to format Date an...
Copilot Studio
Answered

Flow to format Date and Time values in my flow is now failing (worked last week...)

(0) ShareShare
ReportReport
Posted on by 6

Hi everyone,

 

Last week I set up a flow to format Date and Time values. It was successfully working last week but now it's failing and throwing up an error (images below):

 

Snapshot of my flow and the error (in orange)

linlin88_0-1663104161367.png

 

The expression I'm using in the relevant field is:

formatDateTime(body('Current_time'), 'dd/MM/yyyy hh:mm tt')
 
 
Just wondering, has anyone else experienced this error? Otherwise, I wonder if there was a change in the system in the last week - seems strange that it was working perfectly before and now it's not...
 
Thanks!
Lin

 

I have the same question (0)
  • Verified answer
    Expiscornovus Profile Picture
    33,472 Most Valuable Professional on at

    Hi @linlin88,

     

    Quick question, have you tried using the current time value without formatting? As far as I am aware that should work with a standard DateTime SharePoint column.

     

    withoutformatting.png

  • linlin88 Profile Picture
    6 on at

    Hi @Expiscornovus,

     

    Thanks so much, your solution worked 🙂 Much appreciated!

     

    Lin

     

     

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…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Copilot Studio

#1
Valantis Profile Picture

Valantis 490

#2
chiaraalina Profile Picture

chiaraalina 149

#3
Michael E. Gernaey Profile Picture

Michael E. Gernaey 112 Super User 2025 Season 2

Last 30 days Overall leaderboard