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
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
64 | |
23 | |
16 | |
15 | |
11 |
User | Count |
---|---|
121 | |
36 | |
32 | |
28 | |
26 |