Hello there! I am trying to follow up the advanced lessons and there’s a part asking me to do a For each Row inside a Transactions.slsx, the guide ask to try and run it, i assume that it does work but whenever I try it its giving me that error ( tittle)
can you attach a screenshot of the specific activities responsible for the error?
This is whats been show up as an error and as for activities what i am doing is:
Creating a sequence
Read range ( Selecting the correct file and sheet , as showed in the guide there’s no range)
For each row (the dt_transactions its a System.datatable.datatable)
the guide its asking me to also create a Add queue item but its first time i tried it so i dunno if what i am typing in it its correct or not the guide just said to add a name to it
Do you have dt_transactions as the output of the Read Range Activity?
Ok, I suppose the output property in the read range was empty, meaning that the read range activity wasn’t filling any dataTable inside your workflow.
So after solving this now we have the dataTable read from the excel and the problem now is in the collection property in the input of the Add Queue Item activity, can you expand the collection and attach a screenshot of it, because there is a column that should be in the input but it is not provided.
my answer splitted up sorry
" As for the Collection i do have information inside of it but yet nothing, here is whats inside of"
So as the error states, it’s either you don’t have the column OnUsCheck in your dataTable or it is misspelled in the excel, can you check this out please.
I assume it has to do with the Queue name but as i said before i never used this so i have no idea what to type on it, just a string? or it has to be a Var? as a string? i really dont know