Hello Everyone, Please I am facing some difficulty with this and would really appreciate it if someone could help me.
I am creating an app that validates students scores. List A is my validation list that gets populated by lookup. My app contains combobox for studentsnames, testsubject and testscores.
I have three sharepoint lists. A, B and C. I have a lookup column in A for B and a lookup colum in A for C.
LIST A | | |
| | | |
StudentNames | TestSubject | TestScores |
lookup (listB) | lookup (listc) | lookup (listc) |
| LIST B |
| |
| StudentNames |
| Jess |
| Ridi |
| Rucki |
| Beni |
| Shad |
| Pet |
| Luka |
| | | List C | | | | | | |
| | | | | | | | | |
TestSubject | testscore | | Ridi | Rucki | Beni | Shad | Pet | Luka |
English | 10 |  | |  | |  |  | |
Maths | 11 | |  | |  |  | |  |
Chemistry | 12 |  | 
|  | | | | |
History | 15 | |  | |  | |  |  |
Biology | 18 |  | |  |  | | | |
Arts | 25 | | | 
| | |  |  |
I want to populate combobox List C with Jess's test subjects if I select her name from combobox List B in my powerapps form
Please can anyone help me? I am really stuck here and would appreciate any help.
This is my code but it is not working. I am new in powerapps.
Filter(Choices([@A].StudentName), Value in Filter(ListC], TestSubject=DataCardValue2(Jess).Selected.Value),TestSubject)
I also tried this: Filter(Choices([@A].StudentName), Value in Filter(ListC], DataCardValue2(Jess).Selected.Result && true),TestSubject)
It showed no error but the combobox does not display any values.
Please find attached an excel copy of the three sharepoint lists.
Thanks in advance.
