This is an odd scenario, and yet again, it involves the limitations of iPads, but the potential answer(s) could be very useful for many other situations.
Basically, for a Choice Column with multi-selection (checkboxes) enabled, I am trying to figure out how a Button click Action can: keep it's current value(s) and add a new value. [Append, basically.]
Example: MultiChoice column has a value of "Status 1, Status 4". After clicking a button, I want the value to be "Status 1, Status 4, Status 2". [It keeps the current value(s), and appends the new value(s).]
I have found that Set Field Value & Update Item both wipe out the current value(s). I have used Set Field Value to solve almost this identical problem, using something like this:
Visibility for 'Progress Image 3'
However, in the current situation, things aren't quite as "linear". The choices aren't linearly progressing & the end user could need add (make visible) fields in semi-infinite combinations.
In the current situation, the options look like this:
Any suggestions on possible options here? If REST is the answer, is there a nuanced approach to use? Or if REST, would Patch vs. Merge factor into this? Am I missing different approaches with Update Item or Set Field Value?
As always, I appreciate your time,
Please sign in to leave a comment.