Is there an out of the box way to translate a Property Display text to a Value in a data transform

General
,
1

I’m doing a data transform during an Excel Import where the user inputs Display values and I would like to store the actual value in the Data Type Table. I tried getStandardValue, but it doesn’t seem to be working.

2

@AdamH914

  1. Create a decision table:

    • Define a decision table in your application that maps the Property Display text to its corresponding Value. The decision table should have two columns: one for the Property Display text and another for the corresponding Value.

  2. Use the Property-Map-Decision function in a data transform:

    • In your data transform, use the Property-Map-Decision function to perform the mapping. This function takes three parameters: the target property, the decision table name, and the property whose value you want to map.
    • Set the target property as the property where you want to store the mapped Value.
    • Specify the decision table name that contains the mapping rules.
    • Set the property whose value you want to map as the third parameter.
3

@Hitesh Jain I ended up doing something similar and using a Data Page to do a lookup. I’m surprised there isn’t an OOB way to do this though.