Append Value to Enum List Column?

[mykrobinson]

What is the correct action/procedure for adding a value to a column? The column in question is an Enum List type, and I want to create an action that adds the value "CCM" to the column in question.

I don't think I can use the "set value of column" action, but then again, perhaps there is an expression I can use to append a value to the current values?

[mykrobinson · Accepted solution]

UPDATE: I think i may have found an answer. Trying

([NonMedical Flags]+LIST(CCM))

[mykrobinson]

This worked, though i did need to ensure that the column was actually an Enum List and not an Enum 😂

[MultiTech]

Indeed:  list math is a thing in AppSheet

FYI:  You can also remove values from the list just as easily as you added them

[mykrobinson]

thank you, i found that as well and added an inverse action. This is great for locking down the finer details of a column but allowing specific users to only adjust specific things.