I didn’t know how to properly formulate my inquiry in one short search on the Forum, so please feel free to remove it if this creates a duplicate.
My question is how to send messages via email, in bulk, for customers with a specific code in the excel file.
I have an excel file and an orchestrator queue. All the information, line by line goes from excel to the Orchestrator, as a queue item.
When it comes to Send Outlook Activity, I’d like to group all transactions corrisponding to a certain customer, to be able to extract all information from the queue for that particular customer and build an email with details from queue items.
Process is supposed to be built with ReFramework, so general initialization\get transactions happen in corresponding parts of the state machine provided by UiPath.
Please, can someone share ideas on how to achieve this? Thanks
Sorry, so I get the list of all the queue items on Orchestrator. Now I am going to iterate over the items with the help of “For each”. The queue is full of items and some elements have same ‘reference’. Can I group them? When I group them I can’t proceed with creation of an email just yet, can I?
This is actually what my Orchestrator queue looks like
I am going to have to make something like that:
Get all transactions with the reference “X” and create one email.
Get all transactions with the reference “Y” and create one email.
…and so on.
Thank you @rahulsharma ,
Even if I can’t know the IDs that will be uploaded to the Queue beforehand, will I be still able to use this approach?
Here’s my kind of input file. I am going to upload each line to the Orchestrator first. Then I want to send only one email to the recipient who has 123 code, and the second email will be sent to the 321 code. The tricky part actually is that I never know values in column 2, so I can’t build a dictionary, can I?
Sorry @rahulsharma, could we in theory get the inner fields out of the queue items this way by using in_Transaction argument?
Or how can this activity be adjusted to accept more fields, like TransactionItem.SpecificContent…?
Thank you very much @rahulsharma for bearing with me, can you clarify please if the values in the table have to be explicitly accessed with number (e.g. dt.Row(0)(0).toString) or is there any way to get them differently?
I’d like to be able to access the value of transaction.specificitem(“first argument”) and so on… but the tricky part is that I don’t know the final number of records in filtered data table and might lose some data, am I wrong?