6 Replies Latest reply on Oct 6, 2016 9:54 PM by Malcolm

# Is there a Parameter limit in the List() Function?

Working in the Calculation Dialog box I've just handed the List function a list of 1743 items. I get a warning saying that there are too many parameters in the function. The warning does not go away until the number of items is 1000.

Can anyone confirm this limit in the function or is it a Calculation Dialog limit?

• ###### 1. Re: Is there a Parameter limit in the List() Function?

There are three ways to set up the List function.

List ( RelatedTable::Field )

List ( repeatingField )

List ( Field1 ; Field2 ; field3... )

Am I correct that you used the last option?

• ###### 2. Re: Is there a Parameter limit in the List() Function?

It may be limit in calculation parser. Substitute() have 999 documented in help.

No error on

Let(e=substitute(10^333-1;9;"1;");

Evaluate("List(" & e & e & e & "2)")

)

Error on

Let(e=substitute(10^333-1;9;"1;");

Evaluate("List(" & e & e & e & "2;3)")

)

"too many parameters"

• ###### 3. Re: Is there a Parameter limit in the List() Function?

I'm setting up the list in a text editor. It looks like this.

List ("aa";"bb";"cc")

I'm curious because I've worked with lists in large data sets and I don't remember bumping into this before.

• ###### 4. Re: Is there a Parameter limit in the List() Function?

Resulted list can have more than 1000 values of course, but functions have limit on number of parameter.

Let(l=Substitute(10^100-1;9;Substitute(10^100-1;9;"a¶"));

ValueCount(l)

)

get 10000

1 of 1 people found this helpful
• ###### 5. Re: Is there a Parameter limit in the List() Function?

It seems like it is a hard limit, at least for FMPv15

I put your two formulae into a script and added a ValueCount(). The first example returns a value of 1000, the second returns an value of 1. When I get the text of the second it returns "?".

• ###### 6. Re: Is there a Parameter limit in the List() Function?

user19752 is right. The limit is imposed on the number of parameters passed into the function, not on the number of items that the function can return.

If a related table contains thousands of records then list ( related::field ) may return thousands of items. However, the example is only using a single parameter.