Flow action
Add the action Compare Lists. Each run compares one pair of lists.
How a match is decided
Section titled “How a match is decided”List 1 is apple;banana;cherry. List 2 is banana;date. They share banana.
| Setting | Is Matched |
|---|---|
| Exact Match is true | False. The lists are not the same set. |
| Exact Match is false, minimum is 1 | True. One shared value meets the minimum. |
| Exact Match is false, minimum is 2 | False. Only banana is shared. |
When Exact Match is true, Number of Required Matches is ignored. A blank minimum is treated as zero.
Inputs
Section titled “Inputs”| Input | When to set it |
|---|---|
| List 1 | One value, or several separated by semicolons. A multi-select picklist already looks like this. |
| List 1 Collection | A text collection. Combined with List 1 when both are set. |
| List 2 | Same as List 1. Leave it empty when you only want the distinct values of List 1. |
| List 2 Collection | Same as List 1 Collection. |
| Exact Match? | Always. True when both lists must contain the same values, ignoring order. |
| Number of Required Matches | When Exact Match is false. Is Matched is true when the shared count is at least this number. A blank number is treated as zero. |
A collection item is one value, even when the text contains a semicolon. The text input splits on semicolons.
Outputs
Section titled “Outputs”| Output | What you get |
|---|---|
| Is Matched | True when the exact-match or required-match condition is met. |
| Number of Matches | How many distinct values appear in both lists. This is the count compared with the minimum. |
| Matching Values | Those shared values, sorted. |
| Unique Values List 1 | Values in the first list that are not in the second. |
| Unique Values List 2 | Values in the second list that are not in the first. |
Spaces around a value are removed. Blank values are dropped. Duplicates count once. Red and red stay separate.