Updated doc: List Expressions and Aggregates

[Steve]

Completely rewritten.

help.appsheet.com

List Expressions and Aggregates

List expressions use and/or produce lists of values.

Feedback welcome.

[WillowMobileSys]

Very nicely formatted!!

I recall some discussion around List subtraction when the subtracted value appeared multiple times in the original list. Could you add an example to the Constructing a List with Subtraction section of what happens when you subtract the list {“Bob”} from the original sample list in that section?

[Steve]

WillowMobileSystems:

Could you add an example to the Constructing a List with Subtraction section of what happens when you subtract the list {“Bob”} from the original sample list in that section?

Not clear to me what this would demonstrate.

[WillowMobileSys]

Does this:

({ "Bob", "Mary", "Bob", "Alice" } - { "Bob" })

Equal this:

"Mary", "Bob", "Alice"

Or this:

"Mary", "Alice"

?

I don’t remember the result from the post and I can test it myself.

I just thought it might be beneficial to indicate in the article whether the subtraction removes only the first occurrence or ALL occurrences.

[Steve]

Got it! Good point! Done.

[Grant_Stead]

Felt inspired huh?!

[Fabian_Weller]

Very nice thank you @Steve I again learned some things

Could you add EnumList?
And perhaps an Example like this?

ENUMLIST with "Auto-Complete Other Values" set, listed in Alpabetical Order Questions

To Auto-Complete other values in alphabetical order, without duplicates: For ENUM: SORT( LIST( A, B, C, D ) +YourTable[EnumColumn] -LIST("") ) For ENUMLIST: SORT( LIST( A, B, C, D ) +SPLIT(YourTable[EnumListColumn],",") -LIST("") )

[Steve]

Fabian:

Could you add EnumList?

I considered tackling the difference between List and EnumList, but those are (technically) column types and have no distinction within expressions. Within expressions, both List and EnumList are lists. I feel the distinction is better left to the column type docs.

As for the example you referenced, I’ll have to think about it. I want to be careful about getting too expansive in an already long article.