Thursday
I want to have a loop with a counter causing a wait to stop a flood. In Step 4 i have tried changing the Clear Step Output to yes but it still sticks in the 'recordset' from Step 2 - so it processes record 1 3 times. The Google sheet simply shows me what is being processed. Can you help a newbie please?! Thanks.
Thursday
Hi @simontl,
Not sure what is the exact purpose of using a mycount variable.
What I understand is you want to wait for sometime before processing the next record.
Instead you can use Wait for specified length of time for each iteration, before processing next record in the For Each.
Regards,
Prudvi
Thursday
Hi @simontl ,
1. I am just curious to know what is the filter condition you are using in the step.2?
2. Does it mean you are getting same payload again and again from the step.2? if possible, can you add the screenshots
3. What are the updates you are doing at the step.5?
Please kindly give your inputs so that we can provide you the suitable solutions.
Thanks and Regards,
Shivakumara K A
Thursday
Try something like this. This will pause after each item, after the third item. If you want to Stop after the third item, add a Stop instead of the pause. Hope this helps
Get HTTP List
Create Variable myCount
For each Item in HTTPList
Update gSheets with Item
Increment myCount
If myCount >=3
Pause (or Stop)
End If
Continue Loop
Thursday
Your description of the issue is a little confusing, but I think you're saying the HTTP action (step 5) keeps processing the same record over and over. This is probably because your input for step 5 is using output from step 2 when it should be using output from step 4.
When you create a loop action (step 4), the output of the loop action handles the iteration through your array.
If you use the output from step 2 within the loop, you'll access the same item/data every time (it will default to the first item in the array).
If you use the output from step 4, you'll get the iterated item and its data.