Not Planned

Access Dropdown Values in Rule transformation.


Userlevel 6
Badge

I understand that we can enable Bionic pickplist labels which exposes dropdown list values in the rule export or execution results. But what if, I need to do some transformation like concatenation -- framing a Product name using concat( Opportunity Name, Product Type) where Product Type is a Dropdown item. Now the result is coming like this -

ABC Opportunity 1I0054W9FAKXZ0H26HOVC484TSFM5160JI8N.

As a workaround I am using Case expression. But would like to if there is any future enhancement with regard to this? 


8 replies

Userlevel 6
Badge

Hi @shiv_kumar_katiyar 

Is that SFDC Edition or NXT Edition? Because when I executed the rule which is Concatinaing the String Data Type Field with the Picklist Data Type Field it worked and it gives me the actual data, not the Id’s of the PickList values.

I tried in SFDC Edition.

 

Thanks.

Userlevel 6
Badge

It’s NXT Edition.

Userlevel 6
Badge

Recently, I came across one customer use-case wherein they are pulling Account type picklist from SFDC and the company type dropdown from Company. They are doing field Comparison in one of transformation task using these fields but since rule renders GSIDs for the Company Type instead of value, the field comparison is not happening.

Not only this, you cannot create a merge dataset using picklist from SFDC and MDA dropdown. Can be have some thoughts over this. 

Userlevel 4
Badge

@shiv_kumar_katiyar Thank you so much for posting this!

I definitely think this issue should be addressed. I’m glad there is a workaround, but it is not intuitive. The extra steps required to make this work is very cumbersome for admins.

Userlevel 7
Badge

 

I understand that we can enable Bionic pickplist labels which exposes dropdown list values in the rule export or execution results. But what if, I need to do some transformation like concatenation -- framing a Product name using concat( Opportunity Name, Product Type) where Product Type is a Dropdown item. Now the result is coming like this -

ABC Opportunity 1I0054W9FAKXZ0H26HOVC484TSFM5160JI8N.

As a workaround I am using Case expression. But would like to if there is any future enhancement with regard to this? 

@shiv_kumar_katiyar, @Kate  and @phani_kumar since this is an enhancement request changing this to idea.

Userlevel 7
Badge

@All, please leave your vote on this idea to show your interest. Based on customers interest the priority of the road-map will be changed. 

Userlevel 3
Badge

It will be really useful if we can show 2 fields : picklist id and picklist name for the customer to select, one behaving as how we have now and the other as a normal string field.

Userlevel 4
Badge

Thank you @sai_ram!

Reply