Hi there, I created this flow (works fine) which loops through an external array (stored in Excel) to get the new value to be used in the flow.
It works like this
- Initialize index & value (from Excel)
- Also convert string value to integer
- Increment index after operation
- If end of array is reached, reset index
Looking at my flow below, I was wondering if there is a more simple and efficient way to achieve these steps?
Flow in detail - The logic behind each step
So I init a raw string value (because value in Excel is retrieved as a string) and I need an integer for my index, so I convert it afterwards.
I also need a 'newindex' to store the old and new index for my reset-check later in the flow.
I then retrieve the matching email for the current index, then I increment the index.
A check now follows to see if the end of the array has been reached, if so, its reset to 1.
For you info, this is the Excel:
Again, this works great, but I can't let go of the fact that this flow seems bloated, any thoughts? Cheers!
