cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ravenair_cfi
New Member

Access Excel Column Inside a Function Inside a Loop

Hi,

 

I am trying to build a flow which:

  1. Receives a date/time from Excel (in ISO 8601 format)
  2. Calculates this as a number of hours and minutes
  3. 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:

ravenair_cfi_0-1651666106532.png

 

The flow is:

ravenair_cfi_1-1651666142577.png

ravenair_cfi_2-1651666166947.png

 

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!

 

1 REPLY 1
ravenair_cfi
New Member

Helpful resources

Announcements
October Events

Mark Your Calendars

So many events happening this month - don't miss out!

 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Users online (5,284)