I have two sharepoint sites. sharepoint site 1: "Teacher" has the following columns: Id,teachername, profession,location,salary, status N.B Id is auto increment and unique number sharepoint site 2 that is "Course" has the following columns: id,coursename,credithour, teacherId. N.B: teacherid is a lookup id from SharePoint site "Teacher" of column Id Now I have two questions. I want to display Teacher:
| ID | teachername ||profession | location |Status
| 101 | Selam | IT | Mekelle | Active
| 102| Hagos |Biology |Axum | Active
|103| lily |Maths | Mekelle |Inactive
Course
coursename |credithour | teacherId |
Powerbi | 24 | 102
Python | 36 | 103
Azure | 40 | 101
abc | 20 | 102
Python | 36 | 101
Now i have a dropdown list from "teacher"sharepoint list filled with ID column and i have gallery to display result from sharepoint site 2 that is course based on selection of dropdown list from sharepoint site 1. Dropdownlist from sharepoint 1 filled with ID from teacher list: Distinct(Teacher,ID)
on the gallery item: Filter(course,Dropdown3.Selected.Value= teacherid) but it doesnot works.
I have two questions: one i understand the problem comes when i use the lookup column teacherid for filtering. so how can i filter and display on gallery using the lookup column teacherid for filtering. my second question, when a drop down value is selected that is id of the teacher i want to show his/her name in textbox help me please
I am new for power apps canva , I appreciate your feedback
