For one of the Requirements Implementation, I have to filter the Choice Drop-down values and from a condition perspective, i need to retrieve list items from a list called 'Company List'.
The library form where I need these list items to be retrieved is on one of the Subsites and the Company list resides at the Parent/root.
Here are the list column names present in the Company list: Project, Company, Role and EIN. Here is the URL to Company List: https://****.sharepoint.com/Lists/CompanyEntity List/AllItems.aspx
Now using this URL, I want to fetch only the Company Column values where value of the Project Column Equals "Project A". Is this something doable using JSOM? Also this retrieval should take place prior to metadata population on the library upload form.
Can someone help me out with the JSOM code to achieve this as I am working with SharePoint online.