Hi,
Requirement is to send single email to employee with his respective rows and CC to his respective Manager.
Data from sharepoint list
DOC_ID | Invoice_Num | Employee Email | Manager Email |
AB12X | 12SUM | 11email | 22email |
SD12Z | 1qwe2 | 12email | 33email |
asdas | asadsd | 11email | 22email |
SD12Zw | 1qwe2w | 11email | 22email |
Expectation:
Employee 1:
DOC_ID | Invoice_Num | Employee Email | Manager Email |
AB12X | 12SUM | 11email | 22email |
asdas | asadsd | 11email | 22email |
SD12Zw | 1qwe2w | 11email | 22email |
Employee 2:
DOC_ID | Invoice_Num | Employee Email | Manager Email |
SD12Z | 1qwe2 | 12email | 33email |
I have tried with initializing array and append to array but missing something.
Thanks in Advance.
Solved! Go to Solution.
Hi @rpskt :
Please try this flow:
1\My Data Source is a Excel table
2\My flow
Reference Expression:
1\
Hi @rpskt :
Please try this flow:
1\My Data Source is a Excel table
2\My flow
Reference Expression:
1\
This looks like working when manager email in cc not added.
The requirement is to CC manager email in the single to each employee.
Thanks in advance
Hi @rpskt :
Sorry, expression 4 should be placed under the CC parameter:
body('Filter_array')[0]['Manager Email']
Best Regards,
Bof
Then, 4 emails are being received.
Just tried this and works.
Is it possible to create HTML table customized with table lines?
Hi @rpskt :
Custom html table is possible.I recommend two methods:
Method1:Customize column in create html action
Method2:First use Select action to get the custom table you want, and then use create html action to automatically generate html table.
Best Regards,
Bof
Thanks @v-bofeng-msft
Can we add the same row data per user as an attachment to the email. Please to help.
Thanks
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
User | Count |
---|---|
85 | |
58 | |
47 | |
38 | |
34 |
User | Count |
---|---|
91 | |
75 | |
74 | |
61 | |
41 |