assignment.xaml (27.4 KB)
Please check. The basic workflow should be like this.
Cheers
@memrevh
You are my hero today!! My first fully working Robot!
Thank you so much!
Now I have to tackle 5 more!
Thanks so much!
Last question - if the submit was successful how can I write next to the row in the next cell, something like âWRewards addedâ? I need to keep an audit log and error report!
Would it not make more sense to read the excel file as a csv, work on it as a datatable, save it with the extra column added and perform actions using for each row?
After the âread rangeâ activity you can use âadd data columnâ activity and type should string.
Data table name should be the read range DT.
Then in âFor each rowâ activity after the submit.
Use âelement existsâ activity and select the element which is saying âPromotion saved successfullyâ. name any output variable, suppose âpromoSuccessâ
Then use âIf activityâ and condition should be
promoSuccess = True
Inside âThenâ
Use assign like
row.Item(âColumn name given in Add column activityâ) = âWRewards addedâ
This should work. Let me know if face any error.
Cheers
AryanS
Hi @AryanSingh,
thank you so much. I created the variable WReward_Success for Elemnt Exist with variable type Boolean.
Iâm encountering these issues in IF:
Hi @AryanSingh,
Iâve added everything, but when I execute the bot it takes a very long time after I submit to move onto the next promotion.
My files has not been updated at all eitherâŚ
Sorry for ll the questions!
Very slowâŚ
My spreadsheet was open. Could that be the reason it did not update?
Let me try again!
Excel sheet did not add the column or write the result:
This is after my bot executed:
If its slow. I cant really help from here. u can try the element exist activity on other elements on the webpage which only appear after successful promotion but keep in mind that the selectors for these elements should be static not dynamic.
Try it and see if it works.
Thanks. There is no other element that shows it was successful.
My concern is that the data column is not added to Excel. When I open the sheet o 3rd column exists after execution which mean the Add Data Column activity did not work.
If this worked, the column header would be there wouldnât it?
Still no column added on Excel:
I think it should add the data column after this. I am not sure what is the issue. i can only check after checking the workflow.