When file or table is not static i.e. retrieved dynamically, we always get this error if we use the column fields to insert data. (i am refering to item.Item/SurveyType
etc). When dynamic, use the 'Row
' object to insert data as an object like the example below.
create an object
and then pass it to the Row field
this will work fine for dynamic object selection
for this example, i have stored table and file names as strings in the variables.