I have a process where I need to read data from column A (all rows until empty) and paste it into a search field. Problem is, I need to copy values from seven cells at a time paste another place and loop this until there is no more data in the column. I have tried with for each and assign activities but it doesn’t work. I keep getting a lot of type conversion errors for example from char to string or datatable to datarow, datatable to ienumerable. I have an idea that there must be a better way to do this than to use so many type conversions that don’t work.
If there is no other way to do it, I would love help with the current error that is “type Char to type string not possible”
Here is my current workflow: main_example.xaml (19.9 KB)