Can some one help how to write Appropriate status in excel

Help Automation Suite
,
1

Hi,

I need to get Invoice from Excel and search in “Acme” website and get all the relevant data.if invoice is not found i need to write as invalid invoice number.

2

@AzeemK,

Please mention where exactly you are stuck or any specific error you are getting.

3

To the invalid Invoice status was correctly updated in “G” column , But the next Transaction (Invoice) details are updated in the incorrect columns. please see the below screen shot:
The image shows a spreadsheet with columns for Invoice Number, Vendor, Item, Total, and Date, where some entries are highlighted and one row is marked with "Invalid Invoice Number." (Captioned by AI)

I have placed Excel Activity in Business Rule Exception in Set Transaction Activity
and i have attached the project Could you please help on this.
HappyAutomation_REF (2).zip (2.1 MB)

4

@AzeemK,

Try putting your Excel file update login in Process Transaction Finally Block in Main.xaml.

The image shows a "Process Transaction" workflow with sections for "Try," "Catches" including BusinessRuleException and Exception handlers, and a "Finally" block with a space for dropping an activity. (Captioned by AI)
The image shows a "Process Transaction" workflow with sections for "Try," "Catches" including BusinessRuleException and Exception handlers, and a "Finally" block with a space for dropping an activity. (Captioned by AI)852×1278 40.1 KB