How to format Date/Time in my MS flow?

(0) Share

Report

Posted on by Aazza

108

I have just set up a flow with an approval process in it, once i get the approval response I have it so that it gets updated in a Microsoft Excel spreadsheet.

I then want to add the Date/Time of when the approver responds, currently i have used the dynamic content Responses Response date from the Approval but what gets updated in the excel column is this.

Is there a way to get rid of the letters T and Z in my column?

date response was submitted.png date and time submitted.png

Categories:

General topics

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

CU-18081211-6 9,270 Moderator on at

Like (1)

Report
Copy link

Link copied!
@Aazza ,

Use formatDateTime() function written in add dynamic content ->expressions.

Like ..

formatDateTime(...,'dd.MM.yyyy')

Hope it helps !

Was this reply helpful? Yes No