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


Checks if list has duplicates.

Component Version macOS Windows Linux Server iOS SDK
List 7.5 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes
MBS( "List.HasDuplicateItems"; List { ; CaseInsensitive } )   More


Parameter Description Example Flags
List The list to process. "Hello" ¶ "Hello" ¶ "World"
CaseInsensitive Available in MBS FileMaker Plugin 14.0 or newer.
Whether to perform comparison case insensitve.
By default we do case sensitive operations, which are faster.
Pass 1 for insensitve or 0 for sensitive.
0 Optional


Returns 1, 0 or error.


Checks if list has duplicates.
Returns 1 if duplicate lines are found or 0 if not.


Try it:

MBS( "List.HasDuplicateItems"; "Hello¶Test¶World¶Test" )

Example result: 1

Try with case sensitive and case insenstive:

MBS( "List.HasDuplicateItems"; "a¶A"; 0) & MBS( "List.HasDuplicateItems"; "a¶A"; 1)

Example result: 01

See also

Release notes

Blog Entries

This function checks for a license.

Created 21st October 2017, last changed 10th December 2023

List.GetValue - List.HasValue