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.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
At the monthly call, connect with other leaders and find out how community makes your experience even better.
User | Count |
---|---|
26 | |
25 | |
23 | |
23 | |
20 |
User | Count |
---|---|
60 | |
40 | |
40 | |
29 | |
25 |