Add new elements to the lookup column

1

Hello!
I want to add new elements to the lookup column. I want to add new ones to the existing elements using the button. But if I choose “modify” all the existing elements are replaced with one new one. Help please.

я использую: Modify row(this Row, [table].[column], this Row.[column 2])

Maybe you need to use “Concatenate”, but I don’t understand how.

2

Hi there. Just to ensure I understand your question, are you trying to (1) add new items to the list of options available for selection in a lookup column, or (2) add extra items to a selection of items that has already been populated in a particular row for that lookup column?

1 Like
3

Hi!
(2) variant

Untitled - Frame 1
Untitled - Frame 1919×1087 82.6 KB

1 Like
4

No problem.

Set the button options as follows:

  • Action: ‘Modify rows’
  • Table: ‘Table2’
  • Apply to: ‘This row’
  • ‘Update values’: column1 > ListCombine(thisRow.[column1], thisRow.[column2]).Filter( CurrentValue.IsNotBlank() )

The extra ‘filter’ component is needed for rows where one of the two columns is blank. Otherwise you get unwanted ‘blank’ entries in the target cell.

Or if you are configuring the button action entirely as a formula, then:
ModifyRows(thisRow, Table2.[column1], ListCombine( thisRow.[column1], thisRow.[column2] ).Filter( CurrentValue.IsNotBlank() ) )

2 Likes
5

It works great. I’m dancing with joy. Thanks

1 Like
6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.