Answered

Reset Variables After Get Items ID Change

(0) Share

Report

Posted on by jmfillman

This flow works as expected, but not how I need it. The Get Items is doing a match on a SharePoint ID field. I need to reset the variables to zero, when that ID field changes to a new number, which is generally somewhere between 1 and 14 rows from the Excel file, but could be more. I am stuck at detecting when the ID changes to reset the variable.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Mira Ghaly 11,413 Moderator on at

Like (0)

Report

@jmfillman

You need to keep the Current ID in a variable, every time inside your loop , compose a data operation with the ID and compare it with the variable if they match continue if they are different then reset your counter and set the Current ID variable to the ID from the compose operation.

Was this reply helpful? Yes No
jmfillman 46 on at

Like (0)

Report

Thank you for the response. I guess my question was more so where in the flow to do that. If I add a Set Variable, after the Get Items, that creates a nested Apply to Each (see image), which I try to avoid, when possible, but even more of a problem, the nested the Apply to each loop does not actually get triggered, the first time the ID changes, which is missing an iteration, where the variable needs to be both zeroed out and a new value added to that zero.

Was this reply helpful? Yes No