Add in logic where bot sends email with summary of how many items were processes along with total success and failures. Also, use O365 activities to send email using oAuth

I am using O365 for the first time in reframework and i need guidance

where should i use this activity ?? like i want the email to be send once a day for all the transaction which are processed
for example my email 2will look like : transaction 22 , successfull:21/failed: 1 , 02/03/2024

how to achieve this ??
like how can i get the transaction summary from my orchestrator ?? like number and status
and where should i write the email in order to be sent just only once.

kindly help me please

Hi @samantha_shah

The Performer might be running in some intervals right???

You can create a separate process which you can trigger at the end of the day.

In the properties you can pass the date and get information from there in the output.

Thanks
Happy Automation!

Hi @adiijaiin

i am usingperformer for this porocess only for one time , as this is a one time process

yes i can create a seperate process to send email sumary

but the question is how can i get the number of successfull/failed items after the process is run

Hi @adiijaiin

i am usingperformer for this porocess only for one time , as this is a one time process

yes i can create a seperate process to send email sumary

but the question is how can i get the number of successfull/failed items after the process is run

Hi @samantha_shah

You can try using Get Queue Items activity, use the properties of From and To to provide the date and timestamp,
Select Successful and Failed Transactions.
TOp 1000
And get the output.
Loop through the QueueItems retrieved, use 2 counter variables to read the status and increment the counters if status is Successful/ Failed.
Later you can send these variable in the mail body.

I’ll suggest to keep this at the end of your performer.
Or else keep this altogether a separate process.
Tryqueue.zip (3.4 KB)

Attached the project for your reference.

Hope it helps!

Happy Automation!
Please mark it as a solution if that works :smiley:

1 Like