web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Multivalue in convert ...
Power Automate
Answered

Multivalue in convert time zone or Formatdatetime function

(0) ShareShare
ReportReport
Posted on by

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)
  • Verified answer
    v-bofeng-msft Profile Picture
    Microsoft Employee on at

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 112 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 52

#3
Ellis Karim Profile Picture

Ellis Karim 51 Super User 2026 Season 1

Last 30 days Overall leaderboard