so i’m trying to make a thing that reads excel into dt1 then merge dt2 into dt1 and remove duplicates to produce dt3, then take a row from a dt3, send some data from it in email, save the row in dt2 and then remove this row from the dt3.
I have the “add data row” function located inside “For each row” loop
Problem i have, is with this essentially a copy/paste function called “add data row”, that prevents me from copy pasting this row from dt3 into dt2. Apparently…and this is the funny part…because i’m trying to copy from one datatable to another!
I’ve read through forums and I find that this problem has been discussed on multiple occasions since 2016 if not earlier. I’ve tried “invoke method” solution that does not accept “Add” as a method, I’ve tried “get row item” that is now producing “TypeConverter cannot convert from System.string”- error… Every solution I find seems to be producing more errors that are very confusingly described, help articles are useless and hours are now wasted on trying
Also, I have been wondering as to why aren’t these errors noticed automatically? They are completely ignored until i run the software… that is so demoralizing after 100th try.