Dear Supporter,
I have a scenario which I need to send email based on master table.
Master table:
| Email Template Code | Invoice Number | Invoice Date | Client ID | Amount | Attach file |
| 001 | ABC112 | 06-Jun-2023 | AA123 | $10 | NO |
| 002 | ABC113 | 06-Jun-2023 | BB789 | $20 | YES |
According to Email Template Code, I need to lookup To, Cc, Subject and email content from other table.
Email Template table:
| Email Template Code | To | Cc | Subject | Content |
| 001 | abc@outlook.com;efg@outlook.com | qwe@outlook.com | AAA company Invoice Number: {var: Invoice Number from master table} | Dear all, Please see the data as below:
{var: Invoice Number}
{var: Invoice Date} |
| 002 | hijk@outlook.com;opq@outlook.co | nnm@outlook.com | BBB company Client ID: {var: Client ID from master table} | Dear all, Please find attached file for the client:
Client ID: {var: Client ID}
Amount: {var: Amount} |
At the beginning, I think Power Automate flow can be stored variable name in excel file as img 1, but the result fail to show as img 2. Is there anyone has idea to achieve my scenario by Power Automate Flow? Appreciated for any response.
img 1
img 2
expected result:
email subject: AAA company Invoice Number: ABC112
