I have figured out how to use ModifyRows() for a button, to set the cell value of a certain column. The column type is a lookup with “allow multiple selections = on”. But when I use the button with ModifyRows() , it replaces the previous cell value, rather than adding a new value to the cell, amon…

Activate() doesn’t return a row, that’s why you cannot pass it to the outer formula unlike AddRow() that unconventionally returns one. You need to do this in two steps. First add the element to the list, then activate: RunActions( thisRow.ModifyRows(aRT.blueColumn, ListCombine(thisRow.blueColumn…

ModifyRows for adding (not replacing) a value to a column of type "allow multiple selections"

mallika April 17, 2020, 10:16pm 2

Hi @Johan_Nyman, can you take a look at Ways to use a button to append/add to a multi-select column to see if Listcombine helps you.

3 Likes

Topic		Replies	Views
Add/Remove an item from multi-select cell via Button	14	2559	April 11, 2023
How do I force a formula action to run even when calling it inside a Concatenate or ListCombine?	4	415	April 5, 2023
Modify Rows On a Select List Column	3	84	October 30, 2025
Add new elements to the lookup column	5	534	March 31, 2022
Add an array to a list of arrays	3	1240	February 1, 2020

ModifyRows for adding (not replacing) a value to a column of type "allow multiple selections"

Related topics