web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Format date Sharepoint...

Power Automate

Unanswered

Format date Sharepoint List to Teams message

(0) Share

Report

Report

Posted on by Elitezone

905

Hello,

I created a flow that send a message with details of sharepoint list that position that was either created or updated.

This flow is not bad, but a date is in this format:

2020-09-30T13:38:30Z - also it is two hours behind

I created a Data Convert Card:

but date is still the same in output:

Data Convert Card is before a action Card send Teams Message.

I cannot do it with expression. My formula always fails.

Can anyone help a bit.

I want to transform two field (Utworzony - date of creation, Zmodyfikowany - date of modification to format)

DD:MM:YYYY, HH:MM

Categories:

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

sudharsan1985 1,325 on at

Like (1)

Report
Copy link

Link copied!
Hi @Elitezone

Try to use the Compose action with the below-given formula, I had used the default item created date as the argument.

formatDateTime(triggerBody()?['Created'], 'dddd MM/dd/yyyy')

Was this reply helpful? Yes No
Elitezone 905 on at

Like (0)

Report
Copy link

Link copied!

@sudharsan1985
It works but time is still 2h behind it seems to take UTC while my sharepoint list has correct time....

This is very weird.

Was this reply helpful? Yes No
CFernandes 8,482 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

@Elitezone

When you are passing datetimes through triggers and actions in Microsoft Power Automate, users may find a datetime in the wrong time zone. Users may wish to convert the time zone (frequently in UTC) to their local time.

For details see: https://support.microsoft.com/en-in/help/4557244/converting-time-zone-in-microsoft-power-automate

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No

Join the conversation