The source contains no datarow - error

[sullivanne]

Hello Can I add a condition to this sentence that if there is nothing in the data table then do nothing?

dt_nieobecnosci.AsEnumerable().Where(Function(X) DateTime.ParseExact(X(“Koniec”).ToString(), “dd.MM.yyyy”, System.Globalization.CultureInfo.InvariantCulture) > DateTime.Now).CopyToDataTable()

I get an error: the source contains no datarow

[SorenB]

Hello @sullivanne

You could use an If-sentence and check the rowcount:

If(dt_nieobecnosci.AsEnumerable().Where(Function(X) DateTime.ParseExact(X(“Koniec”).ToString(), “dd.MM.yyyy”, System.Globalization.CultureInfo.InvariantCulture) > DateTime.Now).RowCount>0,dt_nieobecnosci.AsEnumerable().Where(Function(X) DateTime.ParseExact(X(“Koniec”).ToString(), “dd.MM.yyyy”, System.Globalization.CultureInfo.InvariantCulture) > DateTime.Now).CopyToDataTable(), Nothing)

Regards
Soren

[ashokkarale]

@sullivanne,

You can split the logic like this.

Get the data rows filtered first using this:

filteredRows = dt_nieobecnosci.AsEnumerable().Where(Function(X) DateTime.ParseExact(X("Koniec").ToString(), "dd.MM.yyyy", System.Globalization.CultureInfo.InvariantCulture) > DateTime.Now)

Once filtered, use If activity to check if they are any rows or not like this:

If filteredRows.Any() Then
    dt_nieobecnosci = filteredRows.CopyToDataTable()
Else
    ' Handle the case where there are no rows, e.g., log a message or do nothing
    Console.WriteLine("No rows found matching the condition.")
End If

[sullivanne]

Thank You very much and Happy Birthday to You!

[ppr (Peter Preuss)]

[FirstAid] Handling of The source contains no DataRows exception - News / Tutorials - UiPath Community Forum

[ashokkarale]

Thanks a lot @sullivanne Cheers!