Components All New MacOS Windows Linux iOS
Examples Mac & Win Server Client Guides Statistic FMM Blog Deprecated Old

List.Intersection

Returns a list with values which are contained in all lists.

Component Version macOS Windows Linux Server iOS SDK
List 14.5 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes
MBS( "List.Intersection"; List1; Lists... )   More

Parameters

Parameter Description Example
List1 The first list. "Hello" ¶ "World"
Lists... The second list or more lists. "Hello" ¶ "Friends"

Result

Returns list or error.

Description

Returns a list with values which are contained in all lists.
Performs a logical AND operation.
Same as List.And, but with variable number of arguments.
The returned list ends with a newline character.

This function takes variable number of parameters. Pass as much parameters as needed separated by the semicolon in FileMaker.
Please repeat Lists parameter as often as you need.

Examples

Intersect three lists:

MBS("List.Intersection"; "A"; "B¶A"; "A¶C")

Example result: A

See also

Release notes

Blog Entries

This function checks for a license.

Created 24th October 2024, last changed 24th October 2024


List.InsertValue - List.MapEntries