Error: Sequence contains no elements

[Evert_Randers]

Hi, I get an error in a Assign activity.

Message: Sequence contains no elements
Exception type: System.InvalidOperationException.

The code in the assign activity is:

Save to: DT_filtered_empty_rows

Value to save: DT_filtered_empty_rows.AsEnumerable.Skip(DT_filtered_empty_rows.Rows.IndexOf(DT_filtered_empty_rows.AsEnumerable.Where(Function(r) r(1).ToString=“Tracktor”).Last)).CopyToDataTable

There is data in the data table, so what can cause this?

[supermanPunch (Arpan)]

@Evert_Randers

Last)).CopyToDataTable

Hi @Evert_Randers ,

The Error is due to the use of Direct CopyToDatatable in the Expression, Check the below post on handling this case :

[FirstAid] Handling of The source contains no DataRows exception

This FirstAid Tutorial will describe how a the source contains no DataRows EXCEPTION can be handled. Introduction Let’s have a look at the following filter data table scenario: Name CCode Tom US Charlotte FR Seema IN Jean FR Assignment: Filter all rows on a particular Country Code like FR, UK, ES, UK… Ensure that all CCode data column values are trimmed Ensure that the Filter check is case insensitive we can implement it e.g. with the help of a LINQ statement: dtData.As…

[Evert_Randers]

Hi, if understand this article correctly, this is for a situation where the filtered table has no rows, but in my case it do have rows. (and will always have). Am I missing something here?

[supermanPunch (Arpan)]

@Evert_Randers

DT_filtered_empty_rows.AsEnumerable.Skip(DT_filtered_empty_rows.Rows.IndexOf(DT_filtered_empty_rows.AsEnumerable.Where(Function(r) r(1).ToString=“Tracktor”).Last)).CopyToDataTable

@Evert_Randers ,

In that case, you could try Debugging this Expression in Parts, Go for the Inner Most Expression to validate using the Immediate Panel.

DT_filtered_empty_rows.AsEnumerable.Where(Function(r) r(1).ToString="Tracktor").Last

Next,

DT_filtered_empty_rows.Rows.IndexOf(DT_filtered_empty_rows.AsEnumerable.Where(Function(r) r(1).ToString="Tracktor").Last)

From the above two outputs we should be able to get to understand why the error occurs.

[Evert_Randers]

When testing the first part I get this error:

When testing the second part I get this error:

[supermanPunch (Arpan)]

@supermanPunch

you could try Debugging this Expression in Parts, Go for the Inner Most Expression to validate using the Immediate Panel.

@Evert_Randers ,

This seems a check in the workflow. Was a Check done using the Immediate Panel as mentioned ?

Also, I guess the First Expression used was having a Typo Error in the Expression.

Check more on Debugging below :

Understanding the 6 Debugging Panels of UiPath in the easiest way possible!

One of the very important topic of UiPath in Debugging is understanding the different debugging panels and when to use which panel during debugging. In this video, we will understand all the 6 debugging panels of UiPath in the easiest way possible. Video Link: Understanding the 6 Debugging Panels of UiPath in the easiest way possible! - YouTube