Clear Run Value on Foreach Excel Row step

Unknown

Clear Run Value on Foreach Excel Row step

Unknown

Hello,

I have an outer foreach to process each Team Member via SQL query which generates an inner foreach XLS file object that will contain multiple items. As I loop through the outer foreach to process my inner foreach it appears that the foreach XLS is retaining my previous outer foreach loop. How can I purge or remove the XLS content/file prior to my next outer foreach loop? Tried: Set NULL value to my Report (FileData) object. Did not work. Looked at the Clear Cache By Name, but not sure what to input as cache instant and type name. See screenshot of workflow:

[img]att1[/img]

Unknown

You should be able to resolve this by putting the inner foreach (For Each Subscription Item) loop inside of a subflow. Now the outer loop will call a new instance of the flow each time, resetting the run value on the foreach XLS row step.