我正在尝试构建一个流,该流量是:
- 从Excel(以ISO 8601格式)接收日期/时间,
- 将其计算为多个小时和分钟的
- 格式,以发送电子邮件以发送电子邮件为
Excel中的数据是员工的小时数量成员在本周工作。数据以:
流量是:
给出“ duty24 hours”和“参考Zero”相同的刻度值,因此,随着时间的工作时间,电子邮件总是发送“ 0”。我得出的结论是,“税收24小时”不是从ABC Excel方法中读取价值,而是默认为0。
请有人提供帮助吗?
谢谢!
编辑:
存储数据的Excel工作簿为每个工作人员包含一张工作表。每张纸都有一个单独的流程插入的表。然后在右侧的灰色表中总计,这是所讨论的流程所读取的数据。
I am trying to build a flow which:
- Receives a date/time from Excel (in ISO 8601 format)
- Calculates this as a number of hours and minutes
- Formats this for an email to be sent
The data in Excel is the amount of hours a staff member has worked in the week. The data is received in Power Automate as:

The flow is:



Currently, the flow gives "duty24Hours" and "referenceZero" the same ticks value, and therefore the email always sends "0" as the hours worked. I have concluded that "duty24Hours" is not reading the value from the ABC excel method, and is defaulting to 0.
Please can someone assist?
Thanks!
EDIT:
The excel workbook where the data is stored contains a sheet for each staff member. Each sheet has a table which a separate flow inserts into. This then totals in grey table on the right, which is the data that the flow in question reads.

发布评论