Solved

Consolidated email in process flow

  • 12 January 2024
  • 2 replies
  • 48 views

Userlevel 4
Badge +11

Hi,

We would like to send a consolidated email to a technician with some data.

For that reason, we use a PF with a SQL action which give a list (list of PM SV for equipement with a certain status)

Below, the list give 3 service orders for the same technicians

 

 

Then we use this SQL in a process flow with an email action. In the PF,  we use the field pm_sa_person_id in the field consolidated (we also tried with this field in the Key field)

This field is present in the SQL.

 

The result is always the same : We have n emails (here in our example 3)  and not 1 email with consolidated data

 

Could you explain the settings needed to send only 1 email.

Thanks and Regards

icon

Best answer by ktolkacevic 12 January 2024, 15:32

View original

2 replies

Userlevel 4
Badge +9

Maybe one option using SQL

I had a similar experience with multiple Material requests from mobile user and needing all material requests in one email. I used the SQL stuff command to consolidate all material demands into one field.

 

 

 

Userlevel 4
Badge +11

Hi @ktolkacevic 

Thanks for your help.
We will try your way. 

Thanks and Regards

 

anthony

Reply