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:

General topics

I have the same question (0)

All responses (5)

Answers (1)

CU-18081211-6 9,270 Moderator on at

Like (1)

Report
@Guicord101 ,

Can you share the approval action as image, eventually the formula you use for date part.

There is a formatDateTime function that helps you to "arrange" date in desired format like this:

formatDateTime('yourDateValueBroughtFromSharepoint','dd/MM/yyyy')

Insert this kind of function in your approval text.

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
Verified answer

CU-18081211-6 9,270 Moderator on at

Like (0)

Report

Delete the existing Data_inicial and with help of + add dynamic content (there is a small text), expression tab write the formula from my previous post.

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

Like (0)

Report

It worked! I just refresh this page

Was this reply helpful? Yes No