TO extract data from table and paste it outlook email and send it out

[Anonymous]

Hi team I need to extract data from my excel table and paste it in outlook email in same format and send it out.

Below is the data needed to be extracted.

In below format needs to be pasted in outlook and send out.

 Pls help asap, @ADCommunity  @Commodus @community24    @ScottShearer @Anonymous 

              @CommunitySynd @Anonymous 

[Kaif_Siddique]

Hi @Anonymous ,

Use list the excel table row and covert to html table then send an email. Here is the flow:

Temp Emp Table:

Flow:

Style: 

<style>
table {
border-collapse: collapse;
width: 100%;
}

th, td {
text-align: left;
padding: 8px;
}

tr:nth-child(even){background-color: #D9E1F2}

th {
background-color: #4472C4;
color: white;
}
td, th {
border: 1px solid #AAAAAA;
padding: 2px;
}
</style>

If you like my response, please give it a Thumbs Up.
If this helps, please Accept as solution.

Regards
Kaif

[Anonymous]

Hi @Kaif_Siddique 

Thanks for your help it worked. Really appreciated.

[Kaif_Siddique · Accepted solution]

If I have solved your query, please mark my post as Solved. Thank you

Regards

Kaif

[Anonymous]

Hi @Kaif_Siddique 

when I am listing the excel table row and covert to html table then sending an email, the date time format is getting changed pls suggest on that attaching the pics below:

In excel it is like this

But it email it is coming in this format. Pls look the format and kindly ignore the values as both excel data & email data are of different dates.

pls help. 

 @ADCommunity  @Commodus @community24    @ScottShearer @Eduardoosorio23 

              @CommunitySynd @hwu @Kaif_Siddique 

[Kaif_Siddique]

Format value to Datetime.

Sample Flow:

Update your flow and use below expression(pass Start Time value)

formatDateTime(addseconds('1899-12-30',int(formatnumber(mul(float(44813.1673611111),86400),'0'))),'dd-MM-yyyy hh:mm')

Regards

Kaif

[Anonymous]

Hi @Kaif_Siddique 

I have to pass the Start time column and End time column from excel to format date time.

I wrote this query

formatDateTime(addseconds('1899-12-30',int(formatnumber(mul(float(item()?['Start Time']),86400),'0'))),'dd-MM-yyyy hh:mm')

But it's returning error, how to pass start time and end time value I am unable to understand.

formatDateTime(addseconds('1899-12-30',int(formatnumber(mul(float(item()?['Start Time']),86400),'0'))),'dd-MM-yyyy hh:mm')

In start time putting the O/P of compose 2

pls help @Kaif_Siddique  how to do that. 

 @ADCommunity  @Commodus @community24    @ScottShearer @Eduardoosorio23 

              @CommunitySynd @hwu @Kaif_Siddique 

[Anonymous]

The error I am getting

[Anonymous · Accepted solution]

Hi @Kaif_Siddique 

It's working for me now with this query

addseconds('1899-12-30', int(formatNumber(mul(float(item()?['Start Time']),86400),'0','en-us')),'yyyy-MM-dd HH:mm:ss')

Thanks for your support

[Kaif_Siddique]

Hi @Anonymous ,

Try this

formatDateTime(addseconds('1899-12-30',int(formatnumber(mul(float(item()['StartTime']),86400),'0'))),'dd-MM-yyyy hh:mm')

Regards

Kaif

[Anonymous]

Hi @Kaif_Siddique 

Thanks that problem is sorted.

But here in Time taken column I am getting the O/P as  56.233333327 like this, how can I reduce it to 2 decimal places or no decimal place. Just ignore the values after decimal.

Like below u can see in excel under time taken column value is 56 only. 

[Kaif_Siddique]

Use formatNumber()

- no decimal "#".

- up to 2 decimal "#.##"

Regards

Kaif

[Anonymous]

Hey @Kaif_Siddique 

Earlier this solution was working provided by you to Use list the excel table row and covert to html table then send an email. Now it's showing this error can u help me

Start Time: addseconds('1899-12-30', int(formatNumber(mul(float(item()?['Start Time']),86400),'0','en-us')),'yyyy-MM-dd HH:mm')

End Time:

addseconds('1899-12-30', int(formatNumber(mul(float(item()?['End Time']),86400),'0','en-us')),'yyyy-MM-dd HH:mm')

Received Date: 

addseconds('1899-12-30', int(formatNumber(mul(float(item()?['Received Date']),86400),'0','en-us')),'yyyy-MM-dd HH:mm')

Time taken:

formatNumber(float(item()?['Time Taken']),'#.')

SLA:

addseconds('1899-12-30', int(formatNumber(mul(float(item()?['SLA']),86400),'0','en-us')),'HH:mm')

pls look into it and help

[Kaif_Siddique · Accepted solution]

Hi @Anonymous ,

I tested my flow and its working fine with previously shared data. 

Is there any change in input data ? please check the input. If issue is not resolved pls share the current sample data.

Regards

Kaif

[Anonymous]

Hi @Kaif_Siddique ,

Below is the excel input, format is same just added few more Jobs which need to be added in excel sheet

Is it related to something adding more rows  so to change the code in power automate?

I am using one more power automate workflow to extract data from outlook and fill the excel sheet.

And then this power automate flow to send the email.

Kindly pls help.

[Anonymous]

Hi @Kaif_Siddique , It worked. It was not working when all columns where not updated fully. It worked when all columns where updated. thanks

One more issue I am facing, @Kaif_Siddique 

For the below email, I am trying to match condition.

Using below workflow to identify this email

But it's not able to catch that email in condition. For other jobs it was running fine. what possibly could be the

reason, can u help plz. It will be really helpful.

[Anonymous]

Hi @Support1 @support4 @Support2 @community24 pls help

[Kaif_Siddique]

Condition is unclear. The email body has "PO Mail" and "po_mail" but flow condition "PO Mail Summary".

Could you pls share the required condition or what do you want to match in email body ?

[Anonymous]

Hi @Kaif_Siddique 

Now it's clear. I want to identify this email so matching this in email body.

Other one 

[Kaif_Siddique · Accepted solution]

Hi @Anonymous ,

I created a flow and tested it. Initially the flow was failing the condition. Later, I observed that additional space at the end of the string.

Flow:

Converted HTMS Email Body to Text:

Issue in Flow condition:

I would suggest you if issues still exists then validate you Email Body Contents with Condition text. Both should be equal.

Hope this will help you.

Regards

Kaif