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

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
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 linlin88 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

 

Categories:
Calling actions from Copilot Studio
I have the same question (0)
  • Verified answer
    Expiscornovus Profile Picture
    Expiscornovus 33,767 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
    linlin88 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

News and Announcements

Welcome to the Power Platform Communities

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 February Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Copilot Studio

#1
Romain The Low-Code Bearded Bear Profile Picture

Romain The Low-Code... 240 Super User 2026 Season 1

#2
Valantis Profile Picture

Valantis 226

#3
Arild Aarnes Profile Picture

Arild Aarnes 73 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Announcing the "Microsoft Copilot Studio ❤️ MCP" lab
Block PII/PCI in Copilot Studio agent user prompt
Welcome to the Copilot Studio forum!

Product updates

Microsoft Power Platform Community release plans