Get Student's Grades from a Different Sharepoint List - ForAll Function
I have a Sharepoint list(Grade List) that holds the different marks and grades to be used to rank student's results as shown below
I have another list (Results List) that holds the results details of the students. I am using a Gallery of repeated tables to capture these results as shown below:
I need a way to automatically grade a student once i type a mark on the Mid(%) and/or End(%) columns. E.g if i type 80 on Mid(%) column, the Grade column should automatically populate as D1.
After spending hours trying to figure out how to pick the grades from the Grade List, i decided trying to load the Grade list as a gallery(GradesGallery) on the same Screen and making it's visible property = false. I then used a ForAll function to loop through the gallery items and assign marks if a match is found. This is what i have as a Default value for my Grade TextInput, assuming we are only grading the Mid(%) whose textbox name is MidResults:
However, I get "Expected Text Value" error. At this point I am not even sure if my approach is viable or not. If it is viable, how do I get rid of that error. If it's not viable, what's the best way to get the grades?