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

All responses (5)

Answers (0)

Sort by

Pstork1 69,665 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

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

formatDateTime(<<date>>, 'dd/MM/yyyy')
Guicord101 151 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi!
My approval action looks like this, where can I use this "FormatDateTime" formula?
Pstork1 69,665 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

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.
Guicord101 151 on at

Like
a
(0)

Report
Copy link

Link copied!

When trying to do this, I cannot find my sharepoint field.
Is there another way to write?
Pstork1 69,665 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

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.