Answered

Transform SQL Date variable into Text

(0) Share

Report

Posted on by Community Power Pla...

I am building a flow where it takes info from SQL Database and sends an email.

And it works great:

However, I would like to transform the date into a nice format (Something like 12 Jun 2018 instead of 2018-06-12T00:00:00Z or at least to just 2018-06-12).

I am very familiar with PowerApps and there I would just use Text() function to transform date into nice date formats. Is there an equivalent function I can use in Flow?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-yuazh-msft on at

Like (1)

Report
Hi @Anonymous,

You could take a try with expresssion "formatDateTime()" to transform the 2018-06-12T00:00:00Z to 2018-06-12.

I have made a test on my side and have created a flow as below:

The expression in the email as below:

formatDateTime(body('Current_time'),'yyyy-MM-dd')

The flow would run successfully as below:

You could refer to link below to learn more about the workflow definition language:

https://docs.microsoft.com/en-us/azure/logic-apps/logic-apps-workflow-definition-language

Best regards,

Alice

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@v-yuazh-msft

Thank you Alice, this is exactly what I was looking for.

Is there a list of all available date time format strings?

I have tried 'dd/mmm/yyyy' which works with PowerApps Text() function but does not work with the Flow.

Was this reply helpful? Yes No