Cliffs Notes Version - We keep a SharePoint list of serial numbers of all equipment sold along with customer info. When the Production Team ships a new piece of equipment, they add a new entry to the Serial Number Log.
I'm creating a flow to create a record in Salesforce for the new piece of equipment that is tied to the customer's Account.
The flow works perfectly as long as there are no special characters in the customer name. When the name has "&" in it, it janks up the entire process and returns no results.
Flow:
Output:
Try as a I might, I can't find a function that will actually remove or replace the "&" from the string. It would be fine to remove all special characters because Salesforce's "LIKE" parameter works well and I could find the proper Account just as easily with "LESTER FEED GRAIN CO"
ETA: I've tried the Replace and Split/Concat functions. Could the issue be related to the Customer Name column being managed metadata? Wouldn't putting the name into a string remove any connection to the term set?
Any help would be greatly appreciated.
