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

All responses (4)

Answers (1)

R Bakker 725 on at

Like (0)

Report

Re: dd/mm/yyyy

Soo simple
Thank you Pstork1
Verified answer

Pstork1 66,864 Most Valuable Professional on at

Like (2)

Report
Re: dd/mm/yyyy

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

formatDateTime(outputs('Compose'),'dd/MM/yyyy')
swathirajan 93 on at

Like (0)

Report

Re: dd/mm/yyyy

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
PrasadAthalye on at

Like (1)

Report

Re: dd/mm/yyyy

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