How to update excel status as pending or done based on excel cell details?

[Vaishnav_Tej]

Hi All,

Use Case : Update the Status as Pending or Done based on the excel cell empty or not.

So, I have read the excel file using read range workbook activity. But couldn’t build a logic for “if Condition” .

Please help me with the logic.

Thanks in Advance:-)

[Anil_G (Anil Gorthi)]

@Vaishnav_Tej

Try this

IsNothing(Row("ColumnName")) OrElse String.IsNullOrEmpty(Row("ColumnName").ToString) OrElse String.IsNullOrWhiteSpace(Row("ColumnName").ToString)

Till with check for null…empty and whitespace

cheers

[Vinit_Mhatre (BotBuilder)]

Hi @Vaishnav_Tej ,

Try this, I hope this works for you.

Test.zip (10.0 KB)

Thanks,
Vinit Mhatre

[Vaishnav_Tej]

Thank you for your immediate response.

String.IsNullOrEmpty(Row(“ColumnName”).ToString)

String.IsNullOrWhiteSpace(Row(“ColumnName”).ToString)

These 2 conditions are working correctly.

Could you please help me with any document/link to learn such type of logic building.

[Anil_G (Anil Gorthi)]

@Vaishnav_Tej

You can use whole of the statement together as well same using OrElse

You will get familiar with them as you use…

Try browsing throgh this

Technical documentation

Cheers