Clear Run Value on Foreach Excel Row step
Comments
-
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]
-
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.
Howdy, Stranger!
Categories
- 4.2K All Categories
- 68 General
- 11 Training
- 203 Installation / Setup
- 1.1K Flows
- 107 Rules
- 262 Administration
- 212 Portal
- 494 General Q & A
- 698 Forms
- 334 Reports
- 3 Designer Extensions
- 47 Example Flows
- 52 CSS Examples
- 1 Diagram Tile
- 7 Javascript Controls
- 180 Pages
- 5 Process Mining
- New Features
- 179 Datastructures
- 69 Repository
- 221 Integrations
- 28 Multi-Tenant
- 27 SDK
- 80 Modules
- 56 Settings
- 25 Active Directory
- 12 Version 7
- 35 Version 8
- 83 Lunch And Learn Questions