Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Sum value into foreach in flow designer

Paolo
Kilo Explorer

Hello.

I need to help.

I have two tables.

The first table is "Movement" and the second table is "RowMovement", the first table is referenced in the second table.
Movement has a column "total", this value is the sum of column "amount" in "RowMovement".

With flow designer I have a trigger that

  1. update or create "RowMovement"
  2. update total = 0;
  3. Lookup records RowMovement where movement.sys_id = RowMovement .movement.sys_id
  4. in foreach
  5. update RowMovement .Movement 
  6. in scripts: return parseFloat(fd_data._3__foreach.item.u_amount) + parseFloat(fd_data._3__per_ogni.item.u_movement.u_total)

Now if i check it with test button it works, but at runtime it not works.

Why????

Thank you.

2 REPLIES 2

Community Alums
Not applicable

Can you please provide screen shots of your code / buttons, so we can help.

Paolo
Kilo Explorer

The screenshot with italian translation.

Rimborso is RowMovement
NotaSpesa is Movement.

Thanks.

find_real_file.png