Need to send an consolidated email by grouping the data from foreach loop iterations in Tibco cloud (Scribe)

[Sandeep Jain 2]

We need to send an email to users which will highlight the number of records and the actual record which got inserted into the Oracle SQL table in a day.

For this we have developed a test notification flow using SMTP connector as well as variables.

We have developed a flow, however the flow sends an email everytime when an item is added to Oracle SQL.

We need to consolidate all the items and then send an email. Can please let us know how to achieve this using Scribe? We don't find any related article in the forum for the same. 

Attached is the flow screenshot for the same.