How to convert HTML or table data from outlook email to csv file

Like (0) Share

Report

Posted on 20 Mar 2022 10:01:24 by Community Power Pla...

Hi Guys,

Need you help, i want to convert html table which i recevied in email body to CSV file or excel file , then send this csv or excel file via email as attachment. Kindly suggest. Column names would be same like HTML table.

Categories:

Business Process Flows

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

v-bofeng-msft on 23 Mar 2022 at 03:52:30

Like (2)

Report

Re: How to convert HTML or table data from outlook email to csv file

Hi @Anonymous :

I've made a test for your reference:

1\My email:

2\My flow:

The Result:

Best Regards,

Bof

Was this reply helpful? Yes No
Community Power Pla... on 23 Mar 2022 at 14:16:49

Like (0)

Report

Re: How to convert HTML or table data from outlook email to csv file

Hi @v-bofeng-msft Thanks for your response.

I tried to add following expression , but getting error "The expression is invalid". Am i doing something worng ? Kindly suggest
split(replace(replace(triggerOutputs()?['body/body'],'</span>',"),'<br>',"),'</td>')

Was this reply helpful? Yes No
v-bofeng-msft on 24 Mar 2022 at 01:42:31

Like (1)

Report

Re: How to convert HTML or table data from outlook email to csv file

Hi @Anonymous :

Cause the trigger is different.

You can replace triggerOutputs()?['body/body'] with the specified HTML text.

Best Regards,

Bof

Was this reply helpful? Yes No
Community Power Pla... on 25 Mar 2022 at 15:22:38

Like (0)

Report

Re: How to convert HTML or table data from outlook email to csv file

Hi @v-bofeng-msft Thanks for the solution.

Was this reply helpful? Yes No