在自动云流动力自动化中转换时区
您好,感谢您抽出宝贵的时间阅读我的帖子! 我刚刚确定了一个自动流,这将帮助我在共享收件箱中跟踪电子邮件的流量(接收)。从本质上讲,我正在跟踪我一天的电子邮件数量。 我设置了流量,并能够使其工作起作用,并且我将添加一排,即所需的信息(即,从,从,到主题行,收到的时间等)。但是,我注意到时间戳不在正确的时区。我阅读了几篇文章,似乎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.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
如果您是从UTC转换,可以像这样很容易地做到这一点...
在运行时,UTC日期/时间是 2022年6月5日,23:50 ,这是我的结果...
If you're converting from UTC, you can do it as easily as this ...
At the time of running this, the UTC date/time was the 5th of June, 2022 at 23:50, this was my result ...