cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Fanki
Level: Powered On

Reverse Lookup / Combobox-Autofill

Hello 🙂

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

Helpful resources

Announcements
thirdimage

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors
Users online (5,641)