在自动云流动力自动化中转换时区

发布于 2025-02-04 19:30:01 字数 858 浏览 3 评论 0原文

您好,感谢您抽出宝贵的时间阅读我的帖子! 我刚刚确定了一个自动流,这将帮助我在共享收件箱中跟踪电子邮件的流量(接收)。从本质上讲,我正在跟踪我一天的电子邮件数量。 我设置了流量,并能够使其工作起作用,并且我将添加一排,即所需的信息(即,从,从,到主题行,收到的时间等)。但是,我注意到时间戳不在正确的时区。我阅读了几篇文章,似乎Power Automate默认设置了UTC时区。我尝试使用表达式转换为正确的时区(EST),流量没有返回任何错误,但以原始格式保留的时间:“ UTC”。 这是我添加了“ converttimezone(utcnow(),'utc','东部标准时间','mm/dd/yyy hh:mm')> 我真的很感谢有关如何最佳解决此问题的任何建议或指导。

“与日期转换的新尝试”

Hello and thank you for taking the time to read my post!
I just finalized an automated flow that will help me keep track of emails' flow (received) in a shared inbox. In essence, I am tracking the number of emails I get a day.
I set up the flow and was able to get it to work and I am getting a row added with the info I need (i.e., From, To, Subject line, Received Time, etc..). However, I noticed that the time stamp is not in the correct time zone. I read several posts and it seems like Power Automate has a UTC time zone set by default. I tried using an expression to convert to the correct time zone (EST), the flow did not return any errors but the time remained in the original format: "UTC".
This is the expression that I added" convertTimeZone(utcNow(),'UTC','Eastern Standard Time','MM/dd/yyy HH:mm')
I would really appreciate any suggestions or guidance on how to best get this issue resolved.

Flow actions

New attempt with date conversion
Date Output

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。

评论(1

反目相谮 2025-02-11 19:30:01

如果您是从UTC转换,可以像这样很容易地做到这一点...

formatDateTime(convertFromUtc(utcNow(), 'Eastern Standard Time'), 'dd MMM yyyy HH:mm')

在运行时,UTC日期/时间是 2022年6月5日,23:50 ,这是我的结果...

“

If you're converting from UTC, you can do it as easily as this ...

formatDateTime(convertFromUtc(utcNow(), 'Eastern Standard Time'), 'dd MMM yyyy HH:mm')

At the time of running this, the UTC date/time was the 5th of June, 2022 at 23:50, this was my result ...

DateTime

~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文