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.

All responses (5)

Answers (0)

Pstork1 67,060 Most Valuable Professional on at

Like (0)

Report

Re: Change in date format in approvals

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

Like (0)

Report

Re: Change in date format in approvals

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

Like (0)

Report

Re: Change in date format in approvals

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 (0)

Report

Re: Change in date format in approvals

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

Like (0)

Report
Re: Change in date format in approvals

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

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