I would like to sent a email by create table header and sub table summary from an excel.

(0) Share

Report

Posted on by Jagen007

Greeting,

I have a table as shown below.

Vendor	Country	Date
HP	TH	8/23/2023
Nebraska	TH	8/23/2023
Employment Security	VN	8/23/2023
HP	LA	8/23/2023
HP	TW	8/23/2023
Oklahoma	SG	8/23/2023
Employment Security	TH	8/24/2023
HP	TH	8/24/2023
Minnesota	SG	8/24/2023
HP	SG	8/24/2023
Illinois	SA	8/24/2023
Workforce	SA	8/25/2023
HP	SA	8/25/2023
Workforce	SA	8/25/2023
Illinois	KH	8/25/2023

I would like to have an output like this, kindly please help:

All responses (7)

Answers (0)

Jagen007 16 on at

Like (0)

Report

Re: I would like to sent a email by create table header and sub table summary from an excel.

@DamoBird365 kindly really need your help on the new development due I'm still having error my end. I followed ur steps according but yet i can't obtain the desired output.
DamoBird365 8,942 Microsoft Employee on at

Like (1)

Report

Re: I would like to sent a email by create table header and sub table summary from an excel.

@Jagen007 I will let others support you with your new request as I believe I have demonstrated in this post how to achieve what you were looking for. Good luck with your development.

Damien
Jagen007 16 on at

Like (0)

Report

Re: I would like to sent a email by create table header and sub table summary from an excel.

Yes Damien, my request has changed but i would like to understand the methodology how to move forwards. Hence I have uploaded the raw data in excel.
DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report

Re: I would like to sent a email by create table header and sub table summary from an excel.

Hi @Jagen007

In my example I used a compose with a json array, instead of list rows. Both return an array. It looks like you’ve built the flow correctly and are creating a table per date but you are missing a compose in the apply to each for the html table and date header and then another compose outside of the apply to each. I have the screenshots in the original post.

I note you’ve posted another post? Have your requirements changed?

Damien
Jagen007 16 on at

Like (0)

Report

Re: I would like to sent a email by create table header and sub table summary from an excel.

If I would not like to convert into a JSON since it is extracting it from an excel file. I would like to remain using ur method. In my apply to each compose step, what should be the code?

This is my existing flow:
DamoBird365 8,942 Microsoft Employee on at

Like (2)

Report

Re: I would like to sent a email by create table header and sub table summary from an excel.

Hi @Jagen007

Based on my video https://youtu.be/pwJ73jFEtDQ you would want to get the distinct dates using select and then union. This will give you three dates. Then in an apply to each, with the union as input, filter the original data based on the current item. Then create the html table on the filtered data. Finally add a compose inside the apply to each and add the current item (date), followed by a <br> and the output of the html table. Outside of the apply to each, you can join the tables created by creating an array with outputs('nameofcompose') and joining with some more <br> tags.

The flow would look like:

I put your table into a json array, which is the same as get rows/items etc:
[
{
"Vendor": "HP",
"Country": "TH",
"Date": "8/23/2023"
},
{
"Vendor": "Nebraska",
"Country": "TH",
"Date": "8/23/2023"
},
{
"Vendor": "Employment Security",
"Country": "VN",
"Date": "8/23/2023"
},
{
"Vendor": "HP",
"Country": "LA",
"Date": "8/23/2023"
},
{
"Vendor": "HP",
"Country": "TW",
"Date": "8/23/2023"
},
{
"Vendor": "Oklahoma",
"Country": "SG",
"Date": "8/23/2023"
},
{
"Vendor": "Employment Security",
"Country": "TH",
"Date": "8/24/2023"
},
{
"Vendor": "HP",
"Country": "TH",
"Date": "8/24/2023"
},
{
"Vendor": "Minnesota",
"Country": "SG",
"Date": "8/24/2023"
},
{
"Vendor": "HP",
"Country": "SG",
"Date": "8/24/2023"
},
{
"Vendor": "Illinois",
"Country": "SA",
"Date": "8/24/2023"
},
{
"Vendor": "Workforce",
"Country": "SA",
"Date": "8/25/2023"
},
{
"Vendor": "HP",
"Country": "SA",
"Date": "8/25/2023"
},
{
"Vendor": "Workforce",
"Country": "SA",
"Date": "8/25/2023"
},
{
"Vendor": "Illinois",
"Country": "KH",
"Date": "8/25/2023"
}
]

Select and compose:

The apply to each takes the compose as input:

The HTML table is based on the filter array and the compose table is the current item, <br> and the output from the create html table.

The compose all tables - outside of the apply to each is as follows:

Here is the output:
Hope that helps and don't forget to marked as solved 😉

Cheers
Damien

Please take a look and subscribe to my YouTube Channel for more Power Platform ideas and concepts. Thanks
Jagen007 16 on at

Like (0)

Report

Re: I would like to sent a email by create table header and sub table summary from an excel.

@DamoBird365 kindly need your help on this sir