Answered

Format Date Time to dd/mm/yyyy hh:mm

(0) Share

Report

Posted on by Sach2022

Hi,

I am using MS Flow (Power Automate) using a Scheduled task - i.e. Recurrence, Execute stored procedure (V2), Create CSV Table and Send Email (V4). I have an issue formatting date/time. When I build my CSV table from a SQL Stored Procedure, the object 'ResultSets Arrived' appears as: 2022-04-01T10:29:19.14. I want this appearing as 01/04/2022 10:29 (i.e. dd/mm/yyyy hh:mm).

In 'Create CSV Table' I tried to create a custom column for 'Arrived' using expression:

convertTimeZone([Arrived],'UTC','W. Europe Standard Time','dd/MM/yyyy HH:mm') but it failed.

Please help.

Thanks!

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (1)

Rhiassuring 8,692 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi there,

I think all you need is a Compose action with formatDateTime([Arrived], 'dd/mm/yyyy hh:mm').

If my reading up on Western Europe is right, then that's UTC itself, so it doesn't need to be converted assuming that's UTC that came out. And if it's stored in a different region, we need to know the region of the source - like Pacific, then it would need conversion using Source and Destination.

Let me know if this makes sense?

Cheers,

Rhia

Was this reply helpful? Yes No
Sach2022 56 on at

Like (0)

Report
Copy link

Link copied!

Hi there,
Sorry, how do I use the Compose Action?
Attached is screenshot of my flow as described earlier.
Before in Create CSV Table, I had Automatic, which meant the SP just put the fields into the CSV, but now I need to convert some fields from 2022-04-01T10:29:19.14 to 01/04/2022 10:29 and these objects are called: ResultSets Arrived, ResultSets Departed, ResultSets Host Notified.
I thought I'd be putting a formatting formula in the box highlighted to format the object coming from the SP (Stored Proc)?
Please help!
Thanks!

Was this reply helpful? Yes No
Sach2022 56 on at

Like (0)

Report
Copy link

Link copied!

Ok, I have managed to sort out my CSV fields (in the Create CSV table) to have a custom expression:

- formatDateTime(item()?['Arrived'],'dd/mm/yyyy hh:mm:ss')

...which appears to be working.

However, my dates are coming out like this (first column is formatted date/time and second column is raw:
30/18/2022 07:18:36 2022-03-30T07:18:36.307

Help!?

Thanks.

Was this reply helpful? Yes No
Verified answer

Sach2022 56 on at

Like (0)

Report
Copy link

Link copied!

Solving this because I worked it out. I need to use this function which closely resembles what was specified above and because i had NULL, I wrapped it with an If statement:
if(empty(item()?['Arrived']), '-', formatDateTime(item()?['Arrived'], 'dd/MM/yyyy HH:mm'))

1 people found this reply helpful.

Was this reply helpful? Yes No