web

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

News and Announcements icon

Power Platform CommunityForums Power Automate Multivalue in convert ...

Power Automate

Answered

Multivalue in convert time zone or Formatdatetime function

(0) Share

Report

Report

Posted on by JSP360

hello boys, i expose the problem below:

We have a sharepoint listing where there are 8 different date and time fields,

The flow is triggered by creating an item in this list.

The goal is to send an email with the contents of these fields but the date and time does not appear correctly, I tried to convert the time with the action "Convert time zone" but it only works converting field by field.

Do you know any way to convert several fields at once?

Is it necessary to add an action "convert time zone" per field?

Can I use the "formatdatetime" function to achieve this? Could you give me an example? I don't manage to do it.

Thks for the help!

Categories:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @JSP360 :

Formatdatetime can not convert time zone. But if you know the date offset of the target time zone, you can use addHours to modify the date.

for example. Suppose I want to convert UCT-10 to UCT+8 (The date offset is 18 hours), then I can use this Expression:

addHours(target time, 18)

I think this link will help you a lot:

https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#addHours

Best Regards,

Bof

Was this reply helpful? Yes No

Join the conversation