I have 3 different Sharepoint lists. Companies, Work-sites and departments.
Companies got Infos about the Name and the Adress of a company
Work-Sites got Infos about the Name, the Count of Workers and the Company (Lookup-Field to Company)
Departmens got Infos about thhe Name, the head of department and the Work-Site (LookUp)
Now I have built a powerapps app, where I can search for Companies with a combo box and based of the selection there, the combobox with the work-sites is filtered. Then the same again with departments, filtered by work-sites.
That's all working fine.
Now I want to create "reverse" search or "auto-fill". If the user selects a department of the list (if no combobox is checked, all of them should show the whole lists) the work-site and company should be selected automatically in the other comboboxes. Is this possible?