Parsing table from email and updating select information into existing SharePoint Item

[WHSBPjM]

My team receives an email update from another team that includes a table of data we utilize in determining next steps for projects. The goal is to extract the bolded data and map it to update specific columns in an existing SharePoint list.

For my Flow, I've gotten as far as extracting the data from the email and converting the HTML to TEXT. However, I've searched and tried multiple ways based on other solutions (comprising of compose, splits, and arrays), but I cannot seem to be able to extract specific items based on the current format of the table. 

This is the format of the table being sent to my team, where there can be a dynamic number of Feature ID's at any given week (up to 16 at one point). In this example, I would like to extract the three bolded items: Feature ID, Total T-shirt Size, and Total T-shirt Cost (Most Likely); then use this information and update a SharePoint list with this information.

Feature ID	12345	23456	34567
Team 1	s	m	xl
Team 2	s	m	xl
Team 3	s	m	xl
Team 4	s	m	xl
Team 5	s	m	xl
Team 6	s	m	xl
Team 7	s	m	xl
Team 8	s	m	xl
Team 9	s	m	xl
Total T-shirt Size	M	L	XL
Total T-shirt Cost (Low)	$24,000	$ 48,000	$   96,000
Total T-shirt Cost (Most Likely)	$32,000	$ 64,000	$ 128,000

Feature ID: 12345

Total T-shirt Size: M
Total T-shirt Cost (Most Likely): 32,000 

Feature ID: 23456

Total T-shirt Size: L
Total T-shirt Cost (Most Likely): 64,000 

Feature ID: 34567

Total T-shirt Size: XL
Total T-shirt Cost (Most Likely): 128,000 

Is it possible to map and update a SharePoint List item using the Feature ID from the email? (Note: Feature ID is not the SharePoint List ID) and the information highlighted below is from the table is updated in SharePoint as a result of processing the table from the email.

[v-jefferni]

Hi @WHSBPjM ,

I think you will need to transpose the HTML table first (because of the number of dynamic IDs), so that you will be able to get values easily. However, there is no way to achieve that in Power Automate. Please consider vote for below idea:

A possibility to transpose/rotate "create HTML tab... - Power Platform Community (microsoft.com)

Best regards,

[WHSBPjM]

Hello @v-jefferni ,

So what you are saying, which kind of confirms what I have been suspecting this entire time, is that we would need to transpose or rotate the table so that the Feature IDs are located in the first column as rows and the following attributes as columns?

Example:

Feature ID

Team 1

Team 2

Team 3

Team 4

Team 5

Team 6

Team 7

Team 8

Team 9

Total T-shirt Size

Total T-shirt Cost (Low)

Total T-shirt Cost (Most Likely)

12345

s

s

s

s

s

s

s

s

s

M

$24,000

$32,000

23456

m

m

m

m

m

m

m

m

m

L

$ 48,000

$ 64,000

34567

xl

xl

xl

xl

xl

xl

xl

xl

xl

XL

$   96,000

$ 128,000

[v-jefferni]

Hi @WHSBPjM ,

Exactly! This table will grow on the items and columns will be static, which is required for the flows to map on the table and find the fields.

Best regards,