I have an Excel file with columns A to I, and column I is labeled “Note.” I am using the REFramework to upload the Excel file into Orchestrator as a queue item. During each case run, I need to add a different comment to column J for each respective case. Once all the cases are complete, I will send the data to the client, including the comments from column I
input.xlsx (25.6 KB)
in the Excel file. How can I add comments after each run?
Hi @ashishmani
So you are looking to add comments to column I of excel file, right?
I understand you must be reading excel data into datatable first before adding those into the queue.
If yes, you can use the same datatable to update the value of column I in the datatable after each run. you can run the loop for datatable, check if currentrow(“let’s say column a value”) equals in_transactionitem.specificcontent(“column a value”), then update currentrow(“column I”) with whatever comments you want.
Once all runs are completed, you can write back your datatable to excel file.
Regards
Sonali
@ashishmani
You can Use write cell activity, where you are iterating the your data table inside the loop you can write cell activity it will directly write the data to your J column. for more understading giving you sample flow snap. you can take as reference and try implement in your flow
Happy Automation!!
I would like to know how to add data to a queue after each case run.
I’m sorry to say that I am new to REFramework and queue items. It’s tough to understand the results without the XAML file.
Ok i got you now,
You are trying to adding the data from excel to Queue right?
To add the queue items you can refer below tutorial
For dispatcher in reframework refer below items
Happy automation!!
in that case, follow below post. this explains how to update the value in a queue after each run.
Queue status updates differ. My issue is that I need to add data to the queue during the bot’s runtime. Essentially, for every run, I have to add a comment to the queue.
@sonaliaggarwal47
Yes I understand that, please read the post carefully, its not about updating the status of queue item but about updating a certain value in the queue item after it has been processed.
For editing the existing item in the queue item, you can directly assign the value to the field in the required queue item
QueueItemVariable.specificcontent(“Key”) = “Value”
please note it wont get updated while its inprogress status. so ins et transaction status.xaml file, right when status is updated to success or failed, after that update your comments value like this, it should work.
Hi @ashishmani
Pls use the add queue item activity, use the item information field to pass a dictionary. create a dictionary variable like:
new dictionary(of string, object) from { {“comment”, “your comment text”} }
and assign it to the item information property.
If helpful, mark as solution. Happy automation with UiPath
Can you try to look below thread, it may help you.
i dont think so here you can update the status by using set transaction status.
meanwhile you can try below thread solution as well
Happy Automation!!
If you are using reframework, you can do this part right after invoke workflow - set transaction status.xaml
It will be in catch of process state