Does anyone how to reverse an array?
Ex. [Alert 4, Alert 3, Alert 2, Alert 1] -> [Alert 1, Alert 2, Alert 3, Alert 4]
Solved! Go to Solution.
Hi there,
You can use an Excel script to do that - that would be the most efficient way. Paul Murana walks through that here, in his "Array Reverse" script.
https://www.tachytelic.net/2021/03/power-automate-sort-array/
If you're not into that, this works too:
1. Create a new array (I called mine arrBackwards)
2. Use an "Apply to Each" and point it at your original collection.
3. Get the last item in the Forwards array: last(variables('arrForwards'))
4. Add it to the Backwards array.
5. Remove the last item from the Forwards array. take(variables('arrForwards'),add(length(variables('arrForwards')),-1))
6. Set the Forwards array to the previous compose so we reference that going forward.
That did the trick.
I answer questions on the forum for 2-3 hours every Thursday!
Hi there,
You can use an Excel script to do that - that would be the most efficient way. Paul Murana walks through that here, in his "Array Reverse" script.
https://www.tachytelic.net/2021/03/power-automate-sort-array/
If you're not into that, this works too:
1. Create a new array (I called mine arrBackwards)
2. Use an "Apply to Each" and point it at your original collection.
3. Get the last item in the Forwards array: last(variables('arrForwards'))
4. Add it to the Backwards array.
5. Remove the last item from the Forwards array. take(variables('arrForwards'),add(length(variables('arrForwards')),-1))
6. Set the Forwards array to the previous compose so we reference that going forward.
That did the trick.
I answer questions on the forum for 2-3 hours every Thursday!
Excellent, thank you for this, very helpful. Love your username btw! 🙂
If anyone is still facing this issue, Power Automate now also has a reverse expression that you can use inside the compose function. See this blog for an explanation: https://www.inogic.com/blog/2022/10/new-function-expressions-in-power-automate-flow/
User | Count |
---|---|
16 | |
16 | |
14 | |
9 | |
8 |
User | Count |
---|---|
30 | |
28 | |
24 | |
23 | |
13 |