Power Platform Community Forum Thread Details

I need your help with PowerApps. I’ve created some PowerApps for use with SharePoint. I want to prevent students from registering for a course if they haven’t completed the prerequisite. For example, if a student wants to take 'AMERICAN SIGN LANGUAGE 2' but hasn’t completed 'AMERICAN SIGN LANGUAGE 1,' they should be prevented from registering for 'AMERICAN SIGN LANGUAGE 2' by disabling the registration button. Once they complete 'AMERICAN SIGN LANGUAGE 1,' the button should be enabled, allowing them to register for 'AMERICAN SIGN LANGUAGE 2.'

Additionally, if a student has already completed a course, that course should be hidden or disabled to prevent them from registering for it again.

Categories:

Connectors

Using Apps Using Formulas

Connecting to Data

Is there a specific ask there? I apologize I don't see one?

I would have a Class List where all the possible classes are, with the availability etc.

You need a Student to Course Mapping List, where you also can add things like year, passed, failed, or whatever. where Student RoW ID comes form the student list and the Course or Class whatever you want to call it, comes from the Course/Class List

I would NOT do a lookup in either of these columns.

I would use the row ID from SharePoint in both Columns because its much easier to search on than LookUps

You are also going to need a Prerequisites Table of some sort for Classes.

To me, this is where again I would be using a Mapping table, where all it has is the ID of the Table with the Prerequisite and the ID of the Prerequisite

This way if you load the Classes Available

You could either do a filter and the filter would essentially be, what classes have I done and what classes have pre-requisites, so that I cannot select it, heck not even see it.

Sorry there is so much more, but I don't even know the question