Hello Andy,
In this scenario, you can go through the main list and perform the appropriate validations using it as a base.
In the process, create an action and select the option "Utility – Collection Manipulation" and select "Filter Collection"
In Entries select the Collection you want to filter. Create an expression that must be placed between Strings " " as a reference to what will be filtered and from which column.
Example: "[exemple] like '%temp%' "
The output will be a Collection where the filtered data will be stored. For quantity validations, you can use "count rows" for this validation;
Auxiliary references:
- https://www.csharp-examples.net/dataview-rowfilter/
- https://learn.microsoft.com/en-us/dotnet/api/system.data.datacolumn.expression?view=netframework-4.7.2
- Digital exchange - collection-manipulation - Documentation
Digitalexchange - Example Process - Collection Manipulation - Download
------------------------------
Leonardo Soares
RPA Developer
América/Brazil
------------------------------
