Hi team,
I have a scenario where I have to depend on the availability of data in certain columns and I navigate to application’s screen and do the update using the input data in the spreadsheet, attached with this post. Please see the first sheet (Changes).
SampleData_Test.xlsx (20.7 KB)
Scenario 1: If Columns (A,B,C,D,E,F) have data but column H does NOT have data - the bot has to go the first screen (Screen1) of the application and does the update using the data from Columns (A,B,C,D,E,F).
Scenario 2: If Columns (A,B,C,D,E,F) have data AND column H also has data - the bot has to go the second screen (Screen2) of the application to do the date update using the expiration date data from Column H. Next step is, the bot comes to the first screen (screen1) and updates with the values it gets from columns (A,B,C,D,E,F).
Here is the expression I was trying to write in the if the IF condition
Isnothing(in_qi_TransactionItem.SpecificContent(“Expiration Date”)) OrElse string.IsNullOrEmpty(in_qi_TransactionItem.SpecificContent(“Expiration Date”).ToString.Trim)
Can anyone help rewriting the above expression using the scenarios I was trying to establish in the above? Or even if there’d be another activity outside of IF condition?
Please let me know if you’d need more information.
Thanks a lot,
Sisay