Just set association from LoadSheet to Appliance and category. Make sure they both have XPath selected for selectable object datasource. Then you can constrain the appliance reference selector on your page so it only shows appliances for the selected category.
Hi Faiqa Ejaz,
make LoadSheet and Appliance (1 - *) Association also LoadSheet and Category (1 – *) Association
the in the data view connect LoadSheet as entity you will get a dropdown bar for Appliance and Category
Here you go.
Here is my domain model.
@Faiqa Ejaz, Here is the solution
First of all create a entity appliance and category in which the attributes will of string type. after that create loadsheet entity in which take the two attributes appliance and category. while taking aatributes in loadsheet make sure you you dont add attributes but just double click on the the loadsheet entity and click on association tab. here you click on new and select category and again click new and select appliance. Now by using a data view create two fields one is to add items in the compliance list and configure that item with appliance entity and another is to add items in category entity. After that create a button on which call a microflow, here you must create a object of both the entities and place a activity open a page where pass the object you just created. and here your work is done..
If you find my explanation useful please feedback. if any question, feel free to ask.