How to add multiple comma separated values from a SC to a AC array at once?

Hey all,

We have a form that uses arrays to store multiple values. We give the end-user the ability to ‘save’ their search, which will essentially just send the array data to the DB via a SC action. This converts the array data into a simple comma separated string e.g:

value1, value2, value3, value4.

On one form we have over 20 arrays on the page to handle the search.

What I’d like to do as part of the user ‘loading’ the search again is to get all the above field values from the DB and then at once add them to the array but as unique values. Currently I have it working so I’ll create one array item ‘value1, value2, value3, value4’ but I want to split it into 4 array items.

Any ideas the best way to handle this, and considering we have 20 + arrays - what the most performant approach would be?

UPDATE: Just got this working with a Flow + repeat and manually typing in the array $value (as you can’t use data picker for it). Let’s see if it performs ok on 9 + filters as the first test.