Sending mail with Microsoft Office 365 & “ApplicationIdAndSecret”

I am using O365 for the first time in reframework

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.

how to get the summary of queueitems after they are finished execution and where to put this emaiil activity inorder to send email just once
kindly help me

Hi @samantha_shah

You shouild build your data using the dt_TransactionData from the REFramework, as it will be returning all the queueitems data, also you can add some additionals columns like the date and the state of the transaction that you should be updating every time it outs from the process workflow. Your email activity should be within the Final State, and passing your transaction datatable through your email activity (you can create a excel file and attach it, or send an HTML table, that is based on your preferences)

Hope this helps, Regards

Hi @fernando_zuluaga

I have created a dispatcher and all my data is alrady in the queue

the perfromer : perfroms the task and works fine

now after the performer runs : i want to check from the orchestrator , how many queue items were successfull and how many failed , just the number for eg: success:22/fail:1

and i want to attach that into my email with todays date

can you suggest me a way

and when i send the email using Microsoft O365 activity-> where should i keep the activity in which state ??

process transaction
end process
or which state of re framework ??

Hi @fernando_zuluaga

I have created a dispatcher and all my data is alrady in the queue

the perfromer : perfroms the task and works fine

now after the performer runs : i want to check from the orchestrator , how many queue items were successfull and how many failed , just the number for eg: success:22/fail:1

and i want to attach that into my email with todays date

can you suggest me a way

and when i send the email using Microsoft O365 activity-> where should i keep the activity in which state ??

process transaction
end process
or which state of re framework ??