`ListAppend` formula for Nested Lists

Suggestion Box
2

Ok, there is a way to do this. It’s super hacky but I guess the community could benefit from it since I didn’t see any posts on how to make nested lists.

Let’s say you have an existing formula called MyList that looks like this:

image
image1110×380 14.3 KB

You can append List("C", 3) to that list with the formula:

Sequence(1, MyList.Count() + 1).FormulaMap(
  If(CurrentValue <= MyList.Count(),
    List(
      MyList.Nth(CurrentValue).Nth(1),
      MyList.Nth(CurrentValue).Nth(2)
    ), 
    List("C", 3)
  )
)

Just to show it works:
Shared with CloudApp

Of course all of this could be solved much more elegantly with syntax like:

MyList.ListAppend(List("C", 3))
1 Like