Time Date format returned from Flow

Like (0) Share

Report

Posted on 28 Oct 2019 15:18:33 by HFG

514

Hi all,

I have an app that is connected to a SQL DB. OnSelect of a button I have a Flow that executes a stored procedure and returns the information to PowerApps. In the response part of the Flow there is a TimeDate2 (2) column from SQL being returned as a string in JSON, this gives the response in the following format: "YYYY-MM-DDTHH:MM:SS.ss". I have tried using "Text(ThisItem.TSP_MsgTime, DateTimeFormat.ShortDateTime)" in PowerApps to format the date, but it is still showing as in the Flow response. Any ideas how I can get it to format properly? I would like it in the format DD/MM/YYYY HH:MM:SS, without the T in the middle and the final milliseconds.

Thank in advance.

All responses (7)

Answers (1)

mdevaney 29,987 Moderator on 29 Oct 2019 at 12:34:14

Like (0)

Report

Re: Time Date format returned from Flow

@HFG
Awesome. Make sure to close the thread if your issue is solved 😸
HFG 514 on 29 Oct 2019 at 12:18:23

Like (0)

Report

Re: Time Date format returned from Flow

Haha, yes, that's crazy!

Thanks
Verified answer

mdevaney 29,987 Moderator on 28 Oct 2019 at 16:25:08

Like (0)

Report
Re: Time Date format returned from Flow

@HFG
Yes, you can definitely convert into a datetime and then apply a TEXT function.

With( {FlowYear:Value(Left(Label1.Text,4)), FlowMonth:Value(Right(Left(Label1.Text,7),2)), FlowDay:Value(Right(Left(Label1.Text,10),2)), FlowHours:Value(Right(Left(Label1.Text,13),2)), FlowMin:Value(Right(Left(Label1.Text,16),2)), FlowSec:Value(Right(Left(Label1.Text,19),2)) }, Text(
DateAdd(
DateAdd(
DateAdd(
Date(FlowYear,FlowMonth,FlowDay),FlowHours,Hours),
FlowMin,Minutes),
FlowSec,Seconds),
"dd/mm/yyyy hh:mm:ss"
) )

Crazy, right?

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
HFG 514 on 28 Oct 2019 at 16:01:44

Like (0)

Report

Re: Time Date format returned from Flow

Hi,

Thank you.

So you think there is no way that PowerApps can recognise it as a datetime in order to make use of all the different formats available?
mdevaney 29,987 Moderator on 28 Oct 2019 at 15:50:27

Like (0)

Report
Re: Time Date format returned from Flow

@HFG
Here's my suggestion

With( {FlowDT:Label1.Text}, Right(Left(FlowDT,10),2)&"/"& Right(Left(FlowDT,7),2)&"/"& Left(FlowDT,4)&" "& Right(Left(FlowDT,13),2)&":"& Right(Left(FlowDT,16),2)&":"& Right(Left(FlowDT,19),2) )

It will convert this text

2019-10-28T15:14:54.15

Into this text

28/10/2019 15:14:54

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
HFG 514 on 28 Oct 2019 at 15:34:10

Like (0)

Report

Re: Time Date format returned from Flow

Hi @mdevaney,

Here is an example:
2019-10-28T15:14:54.15
I have also attached a screenshot of the JSON response.

Thanks in advance for any help.

(In the meantime, I am going to try to remove the parts of the string I don't need using functions.)

JSON Date Time.pdf
mdevaney 29,987 Moderator on 28 Oct 2019 at 15:29:32

Like (0)

Report

Re: Time Date format returned from Flow

@HFG
Can you please provide a specific example of a date/time returned by flow for the forum members to test when trying the conversion?