Bi-directionally sync multi-select dropdown/picklist field values | Community
Skip to main content
N
NickVa7
Level 9
April 5, 2024
Solved

Bi-directionally sync multi-select dropdown/picklist field values

  • April 5, 2024
  • 1 reply
  • 1668 views

Hi Fusion Community,

 

We have field called 'Service Area' in our Salesforce Org.  It is a (single select) picklist field, but is changing to a multi select picklist field.  This field currently syncs data bi-directionally (SFDC --> WF and WF --> SFDC) to a related Service Area field on a program custom form in Workfront.

 

It's looking like I need to change my Workfront field from a dropdown field to a text field to house what's coming from Salesforce if more than one value is being passed (e.g. Strategy, Implementation, Assessment).  However, making the Workfront Service Area field a text field leaves us open to data quality issues if someone updates these values in Worfkront, and inputs an incorrect value, and the system then needs to sync data back to Salesforce.

 

Is there anything in Fusion I can do whereby I can keep both Service Area fields in each system as multi select picklists and still pass data bi-directionally (e.g. parse incoming data into an array and map each value to the existing values predefined in each systems' field)?

 

Thanks!
Nick

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by lgaertner

Thanks, Chris and Lars.

I've tried both without success so far.  

 

Lars, this is what I got when using Text Parse Match Pattern:

 

This is how I set it up:

 

 

Chris, here's what I'm getting when I try your method:

 

 

This is how I set it up:

 

Might I have misinterpreted some of the direction?
Thanks!


Hello Nick,

 

Sorry, I think I accidentally posted the wrong expression...

This is my setup of the module:

 

 

I'll keep my fingers crossed that it works for you.

 

Regards

Lars

1 reply

ChrisStephens
Community Advisor
ChrisStephensCommunity Advisor
Community Advisor
April 6, 2024

Nick

 

I'm not sure why you need to change the WF field to a text field? You can have a dropdown be multiselect in Workfront, or you could use a checkbox field as well.

N
NickVa7Author
Level 9
April 6, 2024

Hey Chris - 

The data coming in from Salesforce is one bug clump of many values separated by semicolons:

 

When Fusion goes to map this data to the multi select dropdown field in Workfront (Service Area), it looks at the massive clump of values coming from Salesforce as one value and tries to find the related value in my Workfront Service Area field.  

 

I need it to parse out all of the semicolon separate values and then go and find and select its sister value in my Workfront Service Area field.  All the same values exist in the Service Area field in both systems.

N
NickVa7Author
Level 9
April 8, 2024

If you pass the string thru a split(;{your field};;), then it should give you an array, then you should be able to map it directly. Note, put the semicolon you want to use for the split in before anything else, or fusion will think it's part of the code and it won't work. (There shouldn't be the grey box around it) 


Thanks, Chris and Lars.

I've tried both without success so far.  

 

Lars, this is what I got when using Text Parse Match Pattern:

 

This is how I set it up:

 

 

Chris, here's what I'm getting when I try your method:

 

 

This is how I set it up:

 

Might I have misinterpreted some of the direction?
Thanks!

Terms & ConditionsAccessibility statement

Loading footer...