Unanswered

Change in date format in approvals

(0) Share

Report

Posted on by Guicord101

151

Hi guys!
I have an automation that sends an approval request.
This approval uses in its text a date in a sharepoint list, however, in sharepoint the date is in the correct format but in the approval it is not.
Example:

On sharepoint:

On powerautomate:

I would like in powerautomate to be the same in sharepoint.

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

Pstork1 68,707 Most Valuable Professional on at

Like (0)

Report
You can use the formatDateTime() function in the flow to format the date to whatever output you want.

formatDateTime(<<date>>, 'dd/MM/yyyy')

Was this reply helpful? Yes No
Guicord101 151 on at

Like (0)

Report

Hi!
My approval action looks like this, where can I use this "FormatDateTime" formula?

Was this reply helpful? Yes No
Pstork1 68,707 Most Valuable Professional on at

Like (0)

Report

Instead of inserting the date field directly in the body use the expressions tab to add the formatDateTime() function around the date and insert that.

Was this reply helpful? Yes No
Guicord101 151 on at

Like (0)

Report

When trying to do this, I cannot find my sharepoint field.
Is there another way to write?

Was this reply helpful? Yes No
Pstork1 68,707 Most Valuable Professional on at

Like (0)

Report

There are two possibilities.

1) If you hover over the existing entry (or look in peek code on the context menu) you can see the JSON representation of the field. That's what needs to be added at this point. You can type it in the expressions tab manually.

2) If you add a Compose action just before you do the approval and add the date to that, that Compose value will normally continue showing up in the dynamic content picker even if the date itself doesn't.

Was this reply helpful? Yes No