Power Platform Community Forum Thread Details

I am a newbie, so be gentle!

I am creating a Skills Matrix. At the moment, I have three SharePoint lists as data sources:

SM-Scoring - Contains two columns: Score and Score Description (this is standalone and just feeds a dropdown on a form and a label explaining what the selected score means
SM-Skills - contains four columns
- Skill Ref (entries in the format of Skill01, Skill02 and so on)
- Skill (a short name for the particular skill)
- Description (a more verbose description of what we mean by the skill)
- Category (what category does the skill fall into)
SM-Capture - contains a number of columns to capture information about the person completing the assessment and what score they have given themselves for each skill. The columns capturing the scores for the skill have been named using the same Skill Ref value that appears in the SM-Skills list

The way that I have constructed the app is that there is a screen for each of the different Skills Categories and the forms on those screens only contain the fields for the skills related to that particular category - this is working fine and the data is being saved back to the SM-Capture list once all of the questions for each category have been answered.

To allow people to view their answers, I have created:

a 'View Answers' screen
Created a collection based on the SM-Skills list to group the skills by the Skill Category (called SkillsGroup)
Used the SkillsGroup collection as the data source for a gallery on the View Answers screen, this gives me a gallery item per Skill Category
Inserted a form, with the SM-Capture list as its data source. This is currently displaying all of the columns from that table (less the data cards relating to the person's identity, manager and so on, which I have deleted).

Where I am now struggling is how to get the form filtered so that when a gallery item is selected, the only form fields that are visible are those where the datafield value (which is the Skill Ref) appears in the list for the Category group

For example, part of the collection looks like:

Grouping (Category)	SkillRef
Leadership	Skill01
	Skill02
	Skill04
Organisational	Skill05
	Skill06

So, I think my question is in two parts:

If it is possible, how do I construct a statement which, when a user clicks the gallery entry, the form fields with datafield values that are equal to the Skills Ref entries for that particular Category (as appears in the SkillsGroup collection) are the only ones which are displayed?
If it is not possible, is there a more appropriate way for me to allow users to view their answers grouped by category?

Thanks - my mind is fried!

Categories:

Building Power Apps