Hello, currently I am trying to obtain a loop of the director’s name with the use of Datatable. However, it keeps appearing the error of Assign: Exception has been thrown by the target of an invocation. In my Datatable, the name is DirectorName and this is my formula in the For Each → row.item(“Fi…

Error --> Assign: Exception has been thrown by the target of an invocation

Srini84 (Srinivas) November 5, 2020, 2:34pm 2

Can you tell me what you are assigning?

Do you want to set the value to the Datatable back?

If so, then you have to write as
DT.Rows(index).Item("ColumnName").ToString = "Your Value"

Where Index is the variable created for For Each row Index in properties

For reference you can check as below

Hope this helps you

Thanks

Topic		Replies	Views
Assign: Exception has been thrown by the target of an invocation (Loop Name) Help datatable , uiautomation , activities , question	1	1216	November 7, 2020
Getting Error: "Assign: Exception has been thrown by the target of an invocation." in For Each Row activity Studio	10	14953	April 12, 2020
Exception thrown by target of invocation when trying to assign output of get text to a row of a data table Help datatable , activities , workflow , error	3	1332	January 20, 2020
Assign: exception has been thrown by the target invocation Help activities	1	1761	March 25, 2020
Assign: Exception has been thrown by the target of an invocation.Assign Studio studio , question , output_panel	2	346	June 23, 2023