I have two screens (screenHome and screenLevel). Both screens have a gallery (homeGallery and levelGallery).
homeGallery has items = Distinct('List Name', 'column1' which gives me two rows. This column is a choice field in a sharepoint list.
What I want to do is when I click the button next to row 1 it takes me to the screenLevel page and filters the gallery to show all the distinct values of the Level column (also a choice).
If I create a collection I can get it to show all values, but I cannot figure out how to say show distinct "Level" values where the column1 choice field selected is equal to the choice field on the sharepoint list.
I am using O365, Sharepoint Lists and Power Apps. When I look at my collection it seems to be showing a symbol vs a value.
