cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Fanki
Level: Power Up

Reverse Lookup / Combobox-Autofill

Hello Smiley Happy

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?

 

Thank you very much in advance!

Fanki