Multivalue in convert time zone or Formatdatetime function

(0) Share

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:

Building flows

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-bofeng-msft on at

Like (0)

Report
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