There is an error when I write the expression editor: If String.IsNullOrEmpty(Row("Shipment ID1").ToString)

[Evelyn_Lu]

Hi,
Is there anyone know how to fix this error? I try to use If activity to skip the row if empty or null in “Shipment ID1” column of google spreadsheet. but there is an error as attached screenshot. Thanks.

If String.IsNullOrEmpty(Row(“Shipment ID1”).ToString)

[mkankatala (Mahesh Kankatala)]

Hi @Evelyn_Lu

You can write it as
String.IsNullOrEmpty(Row(“Shipment ID”).toString or String.IsNullorWhiteSpace(Row(“Shipment ID”).toString

Regards.

[Anil_G (Anil Gorthi)]

@Evelyn_Lu

Welcome to the community please remove if fromthe statement

Cheers

[Evelyn_Lu]

Hi @mkankatala and @Anil_G
Thank you so much!

[Anil_G (Anil Gorthi)]

@Evelyn_Lu

Happy Automation

Cheers

[mkankatala (Mahesh Kankatala)]

Welcome @Evelyn_Lu for considering the solution.

Regards.