I'm building a flow that takes file names from a folder and breaks them down into the same data points that are present on an Excel spreadsheet I'm going to forward them into.
My flow works from one end to the other - however, the issue is that my For Each loop isn't iterating every item.
I've targeted a folder with 28 items in it. It is supposed to iterate 28 loops of the process, however, it only fires 3 times. The first iteration is the always the first item, it doesn't seem to matter if I change WHAT this first file is, and the last 2 files in the bottom of the list. It will skip over almost the entire list, even if it displays the list of files as longer than 3.
Any ideas what's causing this?
***EDIT:
I put together a counter to track how many iterations of the For-Each loop my Flow has processed already. It looks like this:
Total Files = Total Files - Total Files
Total Files = (0) + 1
At the end of the For-Each loop I show how many iterations so far:
Then, when all the processing is done and the last file has been iterated, I show how many iterations vs how many files...
If Iterations = Total Files then the For-Each worked as intended. Which it did. 29 files, looped 29 times.
The issue I was experiencing before this edit was more a behavior of the For-Each loop itself and I was misinterpreting what that behavior was.
The files I'm iterating are sorted alphabetically, and in their destination worksheet they're also sorted alphabetically. In my all-knowing monkey-brain I thought the behavior from the For-Each loop would replicate this alphabetical sort same as the files are listed. Instead, For-Each would randomly select the next file to iterate, going from alphabetical A to M then Z, then back to C. No idea why. The alphabetical sort of the data isn't crucial for my Flow to work right, but it would be nice to watch the Flow go from sorted file 1 to sorted file 2, rather than 1 to... any other number, then eventually back to 2.
For-Each WAS iterating each item, just wildly out of order.
