I am making a SharePoint list to keep track of loans that came from a different organization. Each record is a member's loan, and one of the columns ('Current Lender') keeps a record of where the loan came from. This column needs to hold multiple values, so I concatenate the names of the different businesses together with commas when the user selects them (ex. "Wells Fargo, Capital One, Ventura").
Everything is working fine so far, but I have a list on the backend that holds all the names of the different places these loans can come from; and here I can add, update, and delete these names.
I have figured out the code for a similar field (one that only accepts one entry) so that when one of the names is updated on the backend (if I made a spelling error or something), it updates every record that has the old value:
Patch(
'My List',
LookUp('My List', 'Info Column' = OldValue),
{'Info Column': NewValue}
);
My problem is I was hoping to do this with the Current Lenders as well, but I only want to replace the name of the current lender I updated (ex. if a record has "Capital Two, Wells Fargo, Ventura", I may only want to change it to "Capital One, Wells Fargo, Ventura" without replacing the whole field). Long story short, instead of patching a whole field I need to replace part of the field. Is there a way to patch so that it keeps all of the info in every column unless it can find a specific string, like some sort of substitute?
