I have the string value 'National Unified Number' in cell A3. I want to set a condition that stops execution if cell A3 contains a string; otherwise, it should continue

Help Forum
, , ,
1

I have the string value ‘National Unified Number’ in cell A3. I want to set a condition that stops execution if cell A3 contains a string; otherwise, it should continue.

2

@Mohammad_Rizwan_03

Use Read cell value activity

 If (String.IsNullOrEmpty(cellValue.ToString.Trim) = False)
        Break
else
your flow
3

@Mohammad_Rizwan_03,

I’m assuming you are using For Each Row in Excel activity. Inside it use If condition to check the cell value and in true sequence, use Break activity.

This will break the loop and you can have further logic after the for each.

Thanks,
Ashok :slight_smile:

4

I’m using a ‘For Each Row’ activity, but the ‘If’ condition always evaluates as true, even when it shouldn’t.

5

Hi @Mohammad_Rizwan_03

By using For Each Row in Data Table activity

The image illustrates a UiPath sequence workflow that reads data from an Excel file and checks each row for a specific condition, throwing an exception if the condition is met and writing "Processing" otherwise. (Captioned by AI)
The image illustrates a UiPath sequence workflow that reads data from an Excel file and checks each row for a specific condition, throwing an exception if the condition is met and writing "Processing" otherwise. (Captioned by AI)818×1088 44 KB

CurrentRow("Name").ToString.Trim.Equals("National Unified Number")

Input:

image

Output:

The UIPath output panel displays an error indicating a business rule exception due to the A3 cell containing a National Unified Number, causing the process to terminate. (Captioned by AI)
The UIPath output panel displays an error indicating a business rule exception due to the A3 cell containing a National Unified Number, causing the process to terminate. (Captioned by AI)1217×380 24.9 KB

By Using Read Cell activity

This image depicts a workflow sequence in UiPath that reads a cell value from an Excel sheet and throws a BusinessRuleException if the value is "National U," otherwise it writes "Processing" to the console. (Captioned by AI)
This image depicts a workflow sequence in UiPath that reads a cell value from an Excel sheet and throws a BusinessRuleException if the value is "National U," otherwise it writes "Processing" to the console. (Captioned by AI)818×811 32.6 KB

Output:

The image shows an output window from UiPath indicating an execution of "BlankProcess23" that ended with a BusinessRuleException, triggered by cell A3 containing a National Unified Number. (Captioned by AI)
The image shows an output window from UiPath indicating an execution of "BlankProcess23" that ended with a BusinessRuleException, triggered by cell A3 containing a National Unified Number. (Captioned by AI)1217×379 24.2 KB

Sequence16.xaml (17.5 KB)

Regards,

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.