Populate HTML table from email to SharePoint list

[FlorentMerieux1]

Hello to the great PA community,

I'm trying to build a workflow where I'd like to automate email responses into SharePoint List

The Process is the following:

I send an email including an HTML table to be filled in by various suppliers :

Whenever they reply to me with the filled columns, I'd like their answers to be populated into a SharePoint list

My issue is that the received HTML table includes inline css values and is different from one supplier to another...

Has anyone ever handled this type of workflow ?

So my part solution is to use the HTML to text step to eliminate any CSS and create an array from it but I can't figure out how to handle it

The Output from the HTML to text step looks like this:

ID_Request

PartNumber_Request

Quantity_Request

PartNumber_Quote

Manufacturer_Quote

Quantity_Quote

Price_Quote

LeadTime_Quote

Comments

QJXPTM94

24LC16B-I/P

200

24LC16B-I/P

MANUF1

200

0.85

2022/04/05

Comments 1

...

Any help would be really appredciated

Thank you very much

[FlorentMerieux1 · Accepted solution]

Problem solved. Found a great video here :

(649) How to use Power Automate to parse a HTML Table and convert to JSON - YouTube