I have a VC that creates a list if values (postcode districts). I have an action button that saves that list of values to another table in a cell. Currently the list is saved as below with out a space either side of the “,”. As a result the IN() function when searching for values does not work.
BA1 , BA2 , BS31 , BA3
This is the expression to get the list. Can I change the expression to space the postcodes properly?
SELECT(Full List Table[Spare], ([Real User] = [District User]), TRUE)