Hi @georhe6 ,
Yes, you can use AEM as a Cloud Service to develop a dropdown component that allows the end user to select a vendor and view their details. Here are some suggestions for how to implement this component:
1. Store Vendor Details in AEM DAM: You can upload the vendor details as an Excel file in AEM DAM and use a workflow to write the data to the JCR. This will allow you to manage the vendor data in AEM and make updates as needed.
2. Use a Custom Component: You can create a custom component in AEM that includes a dropdown list of vendors and a "details" button. When the user selects a vendor and clicks the "details" button, the component can retrieve the vendor details from the JCR and display them in a table.
3. Use a Dynamic Dropdown: To handle a large number of vendors, you can use a dynamic dropdown that loads the vendor list from the JCR as the user types in the dropdown field. This can help improve performance and make it easier for the user to find the vendor they are looking for.
4. Use a Data Source: You can create a data source in AEM that retrieves the vendor data from the JCR and makes it available to the component. This can help simplify the component code and make it easier to manage the vendor data.
Overall, the most effective and easiest way for the authoring team to manage this component will depend on your specific requirements and constraints. You may need to experiment with different approaches and tools to find the best solution for your needs. It is recommended to work with an experienced AEM developer or consultant to help you with the implementation.