Hi folks! I was hoping to get some advice on a flow I'm building.
I have a group of campaigns indicating participation in different initiatives. When those contacts are added to one of those campaigns, I now need that to trigger an update on the contact's record to append to a multiselect. The name of the Campaign matches the value in the multiselect.
This is what I have so far:
- Record Trigger: When a campaign member is created AND the Parent Campaign = Initiative Participants
- Get Records: Where the Contact ID equals {!$Record.Contact.Id}
- Update Records: Related to the campaign member, selected triggering campaign member contact ID.
- Set the field Values to Field: Initiative (this is the multiselect) -< Value: Formula resource
- Formula resource: "Get_Related_Contact_s_Existing_Picklist.Initiative__c" & ";" & "$Record.Campaign.Name"
When I attempted to add a new campaign to a contact to test, I got an error: "We can't save this record because the “Initiative Field” process failed. Give your Salesforce admin these details. This error occurred when the flow tried to update records: INVALID_OR_NULL_FOR_RESTRICTED_PICKLIST: Initiative: bad value for restricted picklist field: Get_Related_Contact_s_Existing_Picklist.Initiative__c. You can look up ExceptionCode values in the SOAP API Developer Guide. Error ID: 1353995691-131230 (-38227967)"
Any thoughts? I know the multiselect is going to be a problem, but I am loath to otherwise add a bunch of checkboxes to the record. Thank you!
@Bethany Shenise Ahhh yes, I feared that might happen. Ok here’s the way I’ve had to modify this in the past:
In an Assignment Flow
1) create a text variable (in the example pic, v_Comm_Exclue_Text) and assign the current multi-select picklist values to that variable.
2) using the same variable, ADD your new value, starting with a semi-colon: “;Phone Calls” in the example.
3) I then have the record’s multi-select picklist field = my text variable. But in your case you can just use the variable in the Update Record element.
I’ve attached an image, I hope that helps!
