Share
Report
12Hi all,
I have a flow connected to Salesforce that updates a multi-select picklist field (based on values entered into a multi-select field in a SharePoint list item). This flow works fine most of the time (I originally had issues getting it to work but solved it here), except for when I need to update the multi-select picklist field with an array with no values.
This might seem counterintuitive, but there are times when the Salesforce record field was originally populated with values, and later on, we need to take those values away and leave it as a blank/empty.
In my flow, I Initialize an array variable and append the values from the SharePoint item multi-select field. When I use the Update Salesforce Record action in my flow, I drop the Array variable in the field value. When the array has values it's fine. But when the array has no values,
[]and the flow tries to update the SF record, it gives me an error.
It's definitely the array that is giving me the error, and not any other field. I've also tried hardcoding the array in with what would be a blank value
[""]and it still gives me the same error.
I also can't leave the field blank because it would just leave the SF record field value as-is, and not update it to an empty value.
Any ideas?
All responses (
Answers (
