I'm using a ForAll Statement on a Collection that has been sorted just how I like it.
The ForAll executes well, all records are accounted for, EXCEPT my output in no longer sorted how I want it and now my results are hardcoded in HTML.
My office ladies are upset that their Wonderfully formatted office reports are showing up, as 1 Doc, but results aren't printing in order.
I don't know what to do!!
The reason for this behaviour is because PowerApps doesn't guarantee to run the statements inside a ForAll loop sequentially. For performance reasons, PowerApps can execute these statements in parallel to help speed up the processing time. That's the reason why your output appears out of sequence.
A workaround is to include a sort sequence value in your collection. Within your ForAll, you can Collect your row level results to a new collection, making sure to include the sort value.
To derive your final output, you can carry out a SortByColumns and Concat on this new collection.
The formula in this thread provides an example of how to apply this technique. You'll see how I added a column called SortCol to address this issue.
Hopefully, you'll get a gist of how you can use this technique to solve your problem.
If not, if you post some code here, we can point you in the right direction.
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand