web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Calculation with data ...

Power Automate

Suggested Answer

Calculation with data from the same column.

(0) Share

Report

Report

Posted on by KM986547

2

Hi

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:

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Suggested answer

Daniel Bocklandt 5,151 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
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!
KM986547 2 on at

Like
a
(0)

Report
Copy link

Link copied!

How will a potential flow look like?

Sorry I am fairly new in this.

Join the conversation