How to check the column value is null and update with string using linq query

Help Studio
, ,
5

Hi @Manaswini_UI

Please try to use this linq query in invoke code activity

dtInput.AsEnumerable().Where(Function(row) String.IsNullOrEmpty(row("Comments").ToString())).
ToList().ForEach(Sub(row) row("Comments") = "No record")

The image shows the "Invoke Code" activity in UiPath with a code snippet and the "Invoked code arguments" window detailing the input/output arguments for a DataTable variable named "dtInput". (Captioned by AI)
The image shows the "Invoke Code" activity in UiPath with a code snippet and the "Invoked code arguments" window detailing the input/output arguments for a DataTable variable named "dtInput". (Captioned by AI)1081×442 22 KB

2 Likes