Dear All,
I am making a Student app. I am using two sharepoint list. Campus and Studentprofile. Campus Sharepoint list, will include the all the campus name. Student Profile list will save all details of students.
I am using custom control and not using Edit form option.
I have student ID text control and i placed a Search Button. When i click on Search button, the record as per the student id box will be fetched from studentprofile sharepoint list and displays rest of the student profile details on the screen.
If the student id not found, the user still can key in the rest of the details and save it to profile list.
The campus details are coming from another sharepoint list called "Campus". the dropdown is set with showing the list of campus from the another list.
In Search button i have set a variable as Set(varStudent, StudentID = text_studentid.Text)
In the Campus drop down box i used a condition as If(IsBlank(varStudent), Distinct(Campus, Name), [varStudent.Campus].Value
I want to show if the student id exists, the dropdown should fetch the detail from profile list else it should should the dropdown items from campus list.
i am not able to do this. any one please help. attaching screenshots.
