I have a Cognito form with multiple choice that populates a SharePoint Column. I'm using the "initialize variable" string and "Append to string variable" method to get rid of all the weird other brackets that it makes.
I want this column to be filterable by the individual multi-choice selections in the Cognito form, which I've also put as Choice fields in the SharePoint column. It's clearly a string and is only filterable as the entire string rather than each choice being a separate thing. Any helpful tips on how to split these things up? (I have several columns where this needs to happen, with long lists of up to 20 choice items).