cancel
Showing results for 
Search instead for 
Did you mean: 

PLEASE give us REAL control on Data/Time format

PLEASE give us REAL control on Data/Time format in both entry and output. I have just created an Approval flow for testing, the email message i received states that user requested approval at "2017-05-22T20:41:46Z ", this is not easy to understand that it is 22 May 2017 at 20:41:46 time.

 

If in Entry, like in Reoccurance, i use trial and error to be able set us the step at the time I need because i never understand the date/time format imposed.

 

please allow us use am/pm, and be able to have multipel choice of format like in Excel, include DAY 

Status: New
Comments

I need to be able to format a date in this format, coming out for Microsoft Forms

2017-05-26T14:03:35Z

Microsoft

You can currently use Workflow Definition Language (https://docs.microsoft.com/en-us/azure/logic-apps/logic-apps-workflow-definition-language) and the Standard Date and Time Format Strings (https://docs.microsoft.com/en-us/dotnet/standard/base-types/standard-date-and-time-format-strings) to format the output of the times you'd like. 

 

So your example "2017-05-22T20:41:46Z " can be fed in to formatDateTime() with your selected format (for example, formatDateTime('2017-05-22T20:41:46Z', 'g') will output '5/22/17 8:41:46 pm')

Level: Powered On

That's great, but if the trick of feeding it into the time-zone conversion connector in flow and converting it back to the same timezone, then choosing the proper formatting from a drop-down works, why can't we just have a simpler connector that takes in a time/date column from a List in SP and then gives you that same drop-down so you can just reformat it there and get the same result back. That should already be an out of the box feature if you ask me.