I have an "Entity" List on site 1 showing all company details. Site 2 is for a specific project which i will need to select relevant parties involved in the project from the Entity list. So far i have created a customized form with powerapps with a drop down box showing all the company names.This works. The part i am stuck on and can't find info on is how to bring across the other details into the customized form, like the company phone number and contact name. Ideally when i select the company name from the drop down box on the form the rest of the fields populate then.
I am using Sharepoint on Office365
Thanks in advance. Brett