ISREPEATED

Syntax

ISREPEATED ("field_name")

Description

ISREPEATED checks to see if the source field in the current record is equal to the source field in the preceding record.

Arguments

field_name

The name of the source field.

Returns

If the field specified by field_name has the same value in the current and previous record, returns a Boolean True.

If the field specified by field_name has different values in the current and previous record, returns a Boolean False.

Remarks

ISREPEATED only checks the previous record; it does not find other duplicates in your data.
Field name must be in quotes. Using a field name without quotes prevents the associated flow from preparing and saving correctly.

Note: Since the field name must be in quotes, if you change the name of the Connection that is the source for the field name used in this function, the name change does not propagate to the field name. If you change the Connection name, you must manually update this function.

Examples

If the current record of MyEntity.Customer contains the value "Microsoft" and the previous record of MyEntity.Customer contains the value "Google", then the following formula:

IF(ISREPEATED("MyEntity.Customer"),"Value is repeated", "Value does not repeat")

Returns:

"Value does not repeat"

If both records contain the value “Microsoft” , then:

IF(ISREPEATED("MyEntity.Customer"),"Value is repeated", "Value does not repeat")