How skip a transaction item

input data
input.xlsx (74.4 KB)
it’s having a column HDD, I read the data by using read range activity.
In the for each loop I need to select the radio button based on HDD in the website (Server Setup )
so apart from the these 250 GB, 500 GB, 1 TB, 2 TB & 5 TB. anything comes I have to skip the transaction.

Thanks

Hi @Manju_Reddy_Kanughula

Use a Switch case to handle this condition so you can avoid unwanted data.

cheers.

Hi @Manju_Reddy_Kanughula ,

Instead of skipping the transaction while the specific HDD is encountered, you can filter the datatable before the for each to keep only the HDD 250 GB, 500 GB, 1 TB, 2 TB & 5 TB in the data table.

Regards,

1 Like

@Manju_Reddy_Kanughula ,
You can use “Switch Activity”

image

Regards,

Hi @Manju_Reddy_Kanughula ,

Put these in List

List1 =new List(of string)(new string(){“250 GB”,“500 GB”})

Use a for each row and inside that If activity with condition:

List1.Contains(currentRow(“HDD”).tostring)

Else: Use continue activity

I have send mail to user saying that 1000 TB can’t be done.

If 1000 TB comes, what will be the next step.

That you can do in Else part of If :

List1 =new List(of string)(new string(){“250 GB”,“500 GB”})

Use a for each row and inside that If activity with condition:

List1.Contains(currentRow(“HDD”).tostring)
Else: Send mail that currentRow(“HDD”).tostring cant be done.

Send an exception message that HDD Size is invalid.

Hope this might help you :slightly_smiling_face:

@Manju_Reddy_Kanughula ,
If anything other than 250 GB, 500 GB, 1 TB, 2 TB & 5 TB comes then You can send mail message in the Default section this section executes only if all the conditions doesn’t match

image

Regards,

after sending mail, bot has to be start with new transaction but here it’s not happing like that, here performing the next activity.

@Manju_Reddy_Kanughula

Use Continue activity after send mail.

I you found 1000 TB in swich case it will go to the default section, there you can throw a business exception. then in business exception you can send the mail.

Hope this might help you

incase System or Business exception bot will not be processed.

@Manju_Reddy_Kanughula ,
You can handle this using Try catch activity
Surround the activity with "Try catch "
Use “Throw activity” to throw business exception in the try section like below

and in the catch section add send outlook mail message

image

Regards,

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