cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
HDH1124
New Member

HTML Table issue

created a manual flow to send emails and html table from excel. its works except: i have 6 rows and two unique email addresses. it ends up sending 6 emails with the same information, 3 to one email and 3 to the other. the most baffling part is the html table. its shows correctly in the editor but when it sends the email it sends the same rows to both recipients.  

 

email recipient 1

 

HDH1124_0-1660680340430.png

 

email recipient 2


 Updating Media

 

 

2 REPLIES 2
Hardesh15
Super User
Super User

@HDH1124  Pls share your Create HTML action in edit mode and from where you are taking inputs and expression if any.

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

i finally got the flow to send one email with unique table items to me and another person. I now need to work on the format of the invoice date, invoice id and $amout.

 

 "from": [
        {
            "@odata.etag""",
            "ItemInternalId""ab76a09c-89c3-4ac9-a327-d607b224d48e",
            "Law Firm Name""Acceleron Law Group LLP",
            "CL Inv_x002e_ No_x002e_""73743569",
            "first name2""Heather",
            "Email""heather.housen@coxinc.com",
            "Matter Number""M74833867",
            "Matter Name""RapidScale â€“ General",
            "Invoice Date""44753",
            "Invoice Received Date""44756",
            "Invoice Billed Amount""3375",
            "Billed Amount""3375"
        },
        {
            "@odata.etag""",
            "ItemInternalId""919270ab-d042-4062-8c7c-45e0bfe95e38",
            "Law Firm Name""Padfield & Stout, LLP",
            "CL Inv_x002e_ No_x002e_""73695769",
            "first name2""Heather",
            "Email""heather.housen@coxinc.com",
            "Matter Number""M74374796",
            "Matter Name""Moe Araissi v. NGC",
            "Invoice Date""44744",
            "Invoice Received Date""44750",
            "Invoice Billed Amount""8257.5",
            "Billed Amount""8257.5"
        },
        {
            "@odata.etag""",
            "ItemInternalId""78880e71-62a1-4795-9a1e-93d667c334d0",
            "Law Firm Name""Padfield & Stout, LLP",
            "CL Inv_x002e_ No_x002e_""73695770",
            "first name2""Heather",
            "Email""heather.housen@coxinc.com",
            "Matter Number""M73400238",
            "Matter Name""MBK Auto Group UCC Termination case",
            "Invoice Date""44744",
            "Invoice Received Date""44750",
            "Invoice Billed Amount""1210.5",
            "Billed Amount""1210.5"
        }
    ],
    "format""Html"
}

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (2,489)