dd/mm/yyyy

(0) Share

Report

Posted on by R Bakker

725

Hi all

Painfully new at Power Automate

But I have a flow that is almost good but when I compose a date from a Sharepoint list, it changes it from 2021-05-27 to 27/00/2021. Not sure what is happening to the month. This is the expression. formatDateTime(outputs('Compose'),'dd/mm/yyyy')

Thank you for any help

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

PrasadAthalye on at

Like (1)

Report

Use MM (caps) instead of mm (Small). It will work.

Was this reply helpful? Yes No
swathirajan 93 on at

Like (0)

Report

Hi,

Have you tried changing it other format like mm/yyyy/dd and see how it displays the date?

Here is the format that I use for my flows:

formatDateTime(outputs('Create_an_approval')?['body/requestDate'], 'dd MMM yyyy')

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up

Was this reply helpful? Yes No
Verified answer

Pstork1 68,707 Most Valuable Professional on at

Like (2)

Report
mm (lowercase) retrieves the minutes. MM (uppercase) retrieves the Month. The formula should be:

formatDateTime(outputs('Compose'),'dd/MM/yyyy')

Was this reply helpful? Yes No
R Bakker 725 on at

Like (0)

Report

Soo simple
Thank you Pstork1

Was this reply helpful? Yes No