Skip to main content

Hello everyone

 

We currently have a use case where we want Purchase Order Requesters to receive, once a week, an e-mail detailing all PO Items - that have not yet been reported, in previous weeks - that have 20% or less of their budget remaining.

 

Where we need some input is, how do we send 1 e-mail per week, per Requester, containing only the Purchase Order Items assigned to them?

 

We're currently only capable of sending 1 e-mail to all the requestors present in the data, so what we seem to need is a way to Parse E-mails, based on Requestor, with all their aggregated data!

 

This information is present in a table's Columns, i.e:

image 

Thank you very much in advance!

 

 

P.S: Bear in mind we cannot use Google's Services, so we're limited to using an E-mailing Skill:

Emailing Skill 

 

Best Regards,

 

Vasco Carona

Hi Vasco,

 

in the Action Flow you can use the Tool - "Text Aggregator" to Aggregat the Data.

 

After Query Data in the Action Flow you can take the Text Aggregator.

 

In your case:

 

Group By (Key): "Requester E-Mail"

Text: POs

 

Output will be:

{1}

text: 2504456836 2505610726...

key: A@Solay.com

{2}

text:2504423326 2509563147

key: B@solay.com

...

 

After this you can send the Mail.

 

I hope the answer helps you.

 

Best Regards

Linus


Reply