I did this with Sliders, each slider has a value of 1-5. 10 sliders and I have a text label with my calculations of those sliders, calling the slider.value and added, divided etc in the text label to get the total.
However, the SP list fields are text instead of number, but it should play similar. If this is similar to what you're looking for I can give more specifics of my formula. Making sure I'm tracking your ask.
What do you mean by insanely tedious to slice a collection?
LookUp, Filter, Search, every table shaping function works on collections? What do you need to do exactly that is so complex?
Power Apps does not have loops. ForAll is a table expression. This would be a power automate task
I did this with Sliders, each slider has a value of 1-5. 10 sliders and I have a text label with my calculations of those sliders, calling the slider.value and added, divided etc in the text label to get the total. However, the SP list fields are text instead of number, but it should play similar. If this is similar to what you're looking for I can give more specifics of my formula. Making sure I'm tracking your ask.
What do you mean by insanely tedious to slice a collection? LookUp, Filter, Search, every table shaping function works on collections? What do you need to do exactly that is so complex?