Hi All, Use Case : Update the Status as Pending or Done based on the excel cell empty or not. [image] So, I have read the excel file using read range workbook activity. But couldn’t build a logic for “if Condition” . [image] Please help me with the logic. Thanks in Advance:-)

@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

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

Help Studio

Vinit_Mhatre (BotBuilder) December 28, 2022, 5:42pm 3

Hi @Vaishnav_Tej ,

Try this, I hope this works for you.

Test.zip (10.0 KB)

Thanks,
Vinit Mhatre

1 Like

Topic		Replies	Views
If condition issue Help	2	1317	July 9, 2018
Checking whether certain cells have been filled in an excel sheet Studio	3	905	February 18, 2020
How to validate if the cell of excel is empty Activities excel , robot , activities , studio , question	3	5752	February 10, 2022
Condition in database read row from empty row Activities database , activities , question	5	72	November 15, 2024
How to do an Excel ReadCell/WriteCell sequence WHILE cells are not either empty or specific text? Help	5	748	October 8, 2019

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

Related topics