List filter simple will give you the ability to filter lists used in your process.
The user will merge two lists that contain furniture items and needs to know how many items of a certain type he has, in our example we will keep track of the number of couches.
Step 1. Create a new process and give it a name.
Step 2. Add the needed variables.
Step 3. Configure the Concatenate lists action.
Step 4. Configure the List filter simple action.
Exact: an exact match needs to be validated (=) against FilterExpression
FilterExpression: in our example we will filter using "couch".
The KeepIfTrue setting describes if that particular match is valid if the filter criteria should keep the record or not. If KeepIfTrue = true, then the record will be kept, otherwise, it will not be kept.
Step 5. Configure the Return List Element Count action.
Step 6. Save, Validate and Run the process.
Step 7. Add the input data and click Run.
Step 8. Click Check instances.
The variable <%count%> will show us how many couches we had in our combined input lits.
Parameters:
JSON Configuration:
Match types
Exact: an exact match needs to be validated (=) against FilterExpression.
Similar: it compares against FilterExpression to see:
Fuzzy: this should use the Algos available in StringSimilarity Action to compare the field against FilterExpression (read this for more details).
Contains: this checks if Field contains FilterExpression OR FilterExpression contains Field.
Soundex: this checks if the Field and FilterExpression are similar if you would speak them. See complementation example. This matching algorithm evaluates the distance in βsoundingβ on a scale from 0 to 4, where 4 means the most similar βsoundingβ and 0 means that the words are very different.
SimilarWordMatch: This checks if the first N words in the Field are the same as the first N words in FilterExpression OR if the last N words in the Field are the same as the last N words in FilterExpression.
RegEx: This checks if the Field is a valid match of the pattern from FilterExpression. The RegEx FilterExpression needs to be made JSON safe/encoded (e.g. by using )
FuzzyAlgorithm and FuzzyThreshold properties are only used when MatchType = Fuzzy. If MatchType is something else, those properties will be ignored so, they can be null or can even not be present.
SimilarFirstNwords and SimilarLastNwords properties are only used when MatchType = SimilarWordMatch in which case at least one should be >0. If both are =0 then the SimilarWordMatch will not be executed at all since it does not make sense. If MatchType is something else, those properties will be ignored, so, they can have any value or can even not be present.
SoundexDistance: This is used only when the MatchType = Soundex and it can be set 0, 1, 2, 3 or 4, where 4 means the words are very similar when spoken.
The KeepIfTrue setting describes if that particular match is valid if the filter criteria should keep the record or not. If KeepIfTrue = true, then the record will be kept, otherwise, it will not be kept.
IMPORTANT
ο»Ώ