Hi,
I am trying to build a flow where the input table might look as below:
Name | manager email | ConsumerName | Consumer Email | recomm1 | recomm2 | recomm3 |
Manager1 | manager1emailID | ConsumerA | ConsumerEmail1 | reco1 | reco2 | reco3 |
Manager1 | manager1emailID | ConsumerB | ConsumerEmail2 | reco1 | reco2 | |
Manager2 | manager2emailID | ConsumerC | ConsumerEmail3 | reco1 | reco2 | reco3 |
Based on the table above we need to send a single email to Manager1 who has 2 consumers with recommendations formatted as bullet and when no recomm column is empty it should not be shown ex:
Dear Manger1,
Please find your recommendations:
ConsumerA
ConsumerB
I am unable to create a list with results grouped by ManagerEmail and dynamically list recommendation but can display it as a regular table with results. Kindly suggest.
User | Count |
---|---|
89 | |
40 | |
23 | |
20 | |
16 |
User | Count |
---|---|
130 | |
50 | |
48 | |
35 | |
26 |