Power Platform Community Forum Thread Details

I have a table called Approvers and a table called applicants, there are another two collections to get all the colleagues and subordinates under the user/applicant. I want dropbox to show only the superior user from the list of approvers. the table applicant is just to fill the information submitted by the user. collection 1 will check for the direct subordinate of his manager so that I can eliminate the college level of the user, the collection 2 will get the indirect subordinate of the user's manager so that the user is not visible to any approver who is his subordinate and colleagues, I have the tables and collection now, not sure how to connect the three to display the dropdown showing only the superior of the user. I have used office 365 to create the collections.