cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
linlin88
Regular Visitor

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

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

 

1 ACCEPTED SOLUTION

Accepted Solutions
Expiscornovus
Super User
Super User

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



Happy to help out! 🙂

Interested in more #PowerAutomate #SharePointOnline or #PowerVirtualAgents content?
Visit my blog, Subscribe to my YouTube channel or Follow me on Twitter


View solution in original post

2 REPLIES 2
Expiscornovus
Super User
Super User

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



Happy to help out! 🙂

Interested in more #PowerAutomate #SharePointOnline or #PowerVirtualAgents content?
Visit my blog, Subscribe to my YouTube channel or Follow me on Twitter


linlin88
Regular Visitor

Hi @Expiscornovus,

 

Thanks so much, your solution worked 🙂 Much appreciated!

 

Lin

 

 

Helpful resources

Announcements
Power Virtual Agents News & Announcements

Power Virtual Agents News & Announcements

Keep up to date with current events and community announcements in the Power Virtual Agents community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Virtual Agents Community Blog

Power Virtual Agents Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,583)