Calculation with data from the same column.

(0) Share

Report

Posted on by KM986547

I have a situation where I have a SharePoint list where water usage is noted. It look something like this:

I need Power Automate to make this calculation: "Water meter reading current day - Water meter reading previous day" and then update the Water usage column with the result.

I know I need the trigger: When an item is created or modified. I have tried a lot of different options but I can't seem to get a result that actually works.

I hope you guys can help.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Daniel Bocklandt 5,099 Super User 2025 Season 2 on at

Like (1)

Report
Hey,

so I assume you're trying to get the second to last Record in your table.

Try this:

first(skip(reverse(your_array), 1))

If this solved your problem, please mark it as Solved to help others find the solution faster.
If you found it helpful, consider giving it a Like to support each other in this community!

Thanks, and happy building!

Was this reply helpful? Yes No
KM986547 2 on at

Like (0)

Report

How will a potential flow look like?

Sorry I am fairly new in this.

Was this reply helpful? Yes No