Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Dynamic Drop Downs from excel in OPA — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Dynamic Drop Downs from excel in OPA

Received Response
21
Views
2
Comments
edited Jul 12, 2018 7:26PM in Intelligent Advisor for Fusion Service 2 comments

Content

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!