Hello!
I have built a form in Power Apps where users need to choose 10 elements out of many, the answers get saved to a Sharepoint list.
Now, based on answers they choose I would like to sort them into groups for a future activity. I do not want to automatically put them into Breakout rooms or something like that, I just want to see the end result, put it into a graph and compare the different results the people have chosen.
Each possible answer in the form indicates to one of few categories I made. In the end, I would like to see out of which category each user chose the most answers (just like the four houses in Harry Potter or some Buzzfeed quiz).
Users should only see the options, not the “Harry Potter house” it is supposed to lead to. I am trying to implement this right now, but I have no idea where to start.
Does anyone have an idea how I could easily do it? Is it better to somehow assign secret values that will get saved to the Sharepoint list together with what they choose? Should I make a counter for each “Harry Potter house” that will be incremented every time user chooses corresponding value? Should I just leave the Power App the way it is, and using the result list, work on the sorting in Power BI? Or is there any better solution?
Any help would be much appreciated, thank you!
