Any one please help me to add data to a data table using add data row activity inside a for each row because I am getting below error while doing this.
For Each Row in Data Table: Collection was modified; enumeration operation might not execute.
Have a look on this starter help, taking 2 cols for Duplication check and show cases on how to retrieve all Dups, Non Dups and first from Dups: FindDupsUniquesFirstFromGroup_By2Cols.xaml (12.4 KB)
so we would recommend:
use first from dups approach for the other Worksheet
use non dups for the duplicate removal