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.

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 (2,537)