Run a Calculation Action on Each Row of a List

I have a workflow running on a list of records.

I want to make some additional edits once the first run is complete, in this case I want to be able to add data based on the previous values.

The first pass inserts the data.

The second pass calculates a [Total] value based on the inserted data.

The third pass needs to allocate a value to [Status] from an Option Set to each row based on the ‘total’ value.

I presumed the best way to do this would be to set up a conditional.
Something like: Status = On Target Only when [Total] > 80.

I can’t, however, see how to run a conditional on every row?

Any suggestions?

set condition to ‘‘each item on list’’ this will capture each item on the list

That’s not presented to me as an option, unfortunately.

I can select the original list but that is effectively: Each item’s [Total]

However, if I select the first item, it applies that logic to all rows based on the outcome of the first row, rather than running that logic on all rows.

I’m at a loss.

try using a repeating group to present your data that will give you the ability to calculate each row respectively

The list the action is being run on is from a CSV upload.

Each row in the list comes from that file, then is added to a database, but this is all part of the same backend workflow. It does populate an RG, but it’s an inefficient way to pull the data back into the backend.

ChatGPT solved this one for me.

The conditional is the wrong place to look. Edit the list using a Filter instead!

1 Like

This topic was automatically closed after 70 days. New replies are no longer allowed.