Dynamic Drop Downs from excel in OPA
Hello, I have solved an issue and I what to share it with all of you.
I had two Drop Downs depending one from the other, and it was hard to manage them from multi-level XML list of values, so y decided to manage them from Excel.
The first Drop Down was easy to map from excel, just use "Use values from rules" functionality, but when I mapped for the second Drop Down, it bringed me all the values of the column, (I was looking only the values that had reference withe the first Drop Down)
The solution it was to create an entity defined by the excel and then create a reference (one to one) to select only one instance, after that, I copy the value from the selected instance to a global attribute.