cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
iko_chen
Advocate I
Advocate I

extract the content from table in email to sharepoint list

Notification

FLOC

FLOC Descr.

Short text

Long description

Work order

2200025222

RCS-C-000

RECEIVING,RAW MATERIALS, MIXING, OTHER

热熔胶房,罐区桥架内线缆检查

* 08.09.2020 01:53:54热熔胶房,罐区桥架内线缆检查

310083157

2400027317

RCS-C-000

RECEIVING,RAW MATERIALS, MIXING, OTHER

08:00-16:00 早班电气巡检

 

330003723

@Django 

1 ACCEPTED SOLUTION

Accepted Solutions

However... if you absolutely cannot change your email content there may be a way:

My table = 

HTMLtable00Example.png

 

Read the HTML of your email body to count the number of <TR> tags in the HTML code. In my case an expression like:

 

length(split(outputs('Compose_BodyHTML'),'<tr>'))​

 

This gives you the number of pieces of texts/strings separated by.

So my table has 5 rows of which the first row contains only the header but because there is text before the first row we end up with 6 pieces pieces of texts/strings.

We can use this number 6 to loop through every piece of text so we can isolate the data of every row in a Do until loop (do this action until max number is reached) using an expression to extract the text:

 

last(take(split(outputs('Compose_BodyHTML'),'<tr>'),variables('varNRrowsLooped')))

 

​This gives you the data of a whole row in a variable number of loops: in my case my second loop (the one with row data in it) would result in the HTML of the whole header row:

 

<td style="border-style:solid; border-color:#A3A3A3; border-width:1pt; vertical-align:top; width:1.8513in; padding:4pt 4pt 4pt 4pt"><p lang="en-US" style="margin:0in; font-family:Calibri; font-size:11.0pt"><span style="font-weight:bold">Investment Approval Request</span></p></td><td style="border-style:solid; border-color:#A3A3A3; border-width:1pt; vertical-align:top; width:1.2937in; padding:4pt 4pt 4pt 4pt"><p lang="en-US" style="margin:0in; font-family:Calibri; font-size:11.0pt"><span style="font-weight:bold">Investment Approval Step</span></p></td><td style="border-style:solid; border-color:#A3A3A3; border-width:1pt; vertical-align:top; width:1.8076in; padding:4pt 4pt 4pt 4pt"><p lang="en-US" style="margin:0in; font-family:Calibri; font-size:11.0pt"><span style="font-weight:bold">Investment Approval Configuration</span></p></td><td style="border-style:solid; border-color:#A3A3A3; border-width:1pt; vertical-align:top; width:1.7159in; padding:4pt 4pt 4pt 4pt"><p lang="en-US" style="margin:0in; font-family:Calibri; font-size:11.0pt"><span style="font-weight:bold">Investment Approval Log</span></p></td></tr>

 

Within the loop we also need to extract every cell of the row separately --> we use the same concept with the Do until here but then for every cell looking for the end of the cell with the </td> tag

 

length(split(outputs('Compose_ItemData'),'</td>'))

 

This gives you the data of a cell in your row: in my case the first loop would be the HTML of the cell with Investment Approval Request in it:

 

<td style=\"border-style:solid; border-color:#A3A3A3; border-width:1pt; vertical-align:top; width:1.8513in; padding:4pt 4pt 4pt 4pt\"><p lang=\"en-US\" style=\"margin:0in; font-family:Calibri; font-size:11.0pt\"><span style=\"font-weight:bold\">Investment Approval Request</span></p>

 

Then we append this data to a new array of celldata within the array of items (rows)

This gives you the chance to determine what you want to do with every row: in my case the new array looks like

 

[
  {
    "Itemnumber": 2,
    "celldata": [
      {
        "CellData1": "<td style=\"border-style:solid; border-color:#A3A3A3; border-width:1pt; vertical-align:top; width:1.8513in; padding:4pt 4pt 4pt 4pt\"><p lang=\"en-US\" style=\"margin:0in; font-family:Calibri; font-size:11.0pt\"><span style=\"font-weight:bold\">Investment Approval Request</span></p>"
      },
      {
        "CellData2": "<td style=\"border-style:solid; border-color:#A3A3A3; border-width:1pt; vertical-align:top; width:1.2937in; padding:4pt 4pt 4pt 4pt\"><p lang=\"en-US\" style=\"margin:0in; font-family:Calibri; font-size:11.0pt\"><span style=\"font-weight:bold\">Investment Approval Step</span></p>"
      },
      {
        "CellData3": "<td style=\"border-style:solid; border-color:#A3A3A3; border-width:1pt; vertical-align:top; width:1.8076in; padding:4pt 4pt 4pt 4pt\"><p lang=\"en-US\" style=\"margin:0in; font-family:Calibri; font-size:11.0pt\"><span style=\"font-weight:bold\">Investment Approval Configuration</span></p>"
      },
      {
        "CellData4": "<td style=\"border-style:solid; border-color:#A3A3A3; border-width:1pt; vertical-align:top; width:1.7159in; padding:4pt 4pt 4pt 4pt\"><p lang=\"en-US\" style=\"margin:0in; font-family:Calibri; font-size:11.0pt\"><span style=\"font-weight:bold\">Investment Approval Log</span></p>"
      }
    ]
  },
  {
    "Itemnumber": 3,
    "celldata": [
      {
        "CellData1": "<td style=\"border-style:solid; border-color:#A3A3A3; border-width:1pt; vertical-align:top; width:1.8513in; padding:4pt 4pt 4pt 4pt\"><p lang=\"en-US\" style=\"margin:0in; font-family:Calibri; font-size:9.0pt\">Purpose:<br>save data of the request</p>"
      },
      {
        "CellData2": "<td style=\"border-style:solid; border-color:#A3A3A3; border-width:1pt; vertical-align:top; width:1.302in; padding:4pt 4pt 4pt 4pt\"><p lang=\"en-US\" style=\"margin:0in; font-family:Calibri; font-size:9.0pt\">Purpose:</p><p lang=\"en-US\" style=\"margin:0in; font-family:Calibri; font-size:9.0pt\">save data of approval steps linked to a single request</p>"
      },
      {
        "CellData3": "<td style=\"border-style:solid; border-color:#A3A3A3; border-width:1pt; vertical-align:top; width:1.8076in; padding:4pt 4pt 4pt 4pt\"><p lang=\"en-US\" style=\"margin:0in; font-family:Calibri; font-size:9.0pt\">Purpose:</p><p lang=\"en-US\" style=\"margin:0in; font-family:Calibri; font-size:9.0pt\">Save approval step configuration based on properties of the Investment Approval Request</p><p lang=\"en-US\" style=\"margin:0in; font-family:Calibri; font-size:9.0pt\">&nbsp;</p>"
      },
      {
        "CellData4": "<td style=\"border-style:solid; border-color:#A3A3A3; border-width:1pt; vertical-align:top; width:1.6201in; padding:4pt 4pt 4pt 4pt\"><p lang=\"en-US\" style=\"margin:0in; font-family:Calibri; font-size:9.0pt\">Purpose:</p><p lang=\"en-US\" style=\"margin:0in; font-family:Calibri; font-size:9.0pt\">Save important milestones of the process as individual records linked to a single request</p>"
      }
    ]
  },
  {
    "Itemnumber": 4,
    "celldata": [
      {
        "CellData1": "<td style=\"border-style:solid; border-color:#A3A3A3; border-width:1pt; vertical-align:top; width:1.8708in; padding:4pt 4pt 4pt 4pt\"><p lang=\"en-US\" style=\"margin:0in; font-family:Calibri\"><span style=\"font-size:11.0pt\">IA Name<br></span><span style=\"font-size:9.0pt\">(a unique name combination created by Power App during submission so linked entities will have meaningful lookup name)</span></p>"
      },
      {
        "CellData2": "<td style=\"border-style:solid; border-color:#A3A3A3; border-width:1pt; vertical-align:top; width:1.3048in; padding:4pt 4pt 4pt 4pt\"><p lang=\"en-US\" style=\"margin:0in; font-family:Calibri; font-size:11.0pt\">n:1 lookup with </p><p lang=\"en-US\" style=\"margin:0in; font-family:Calibri; font-size:9.0pt\"><span style=\"font-weight:bold\">Investment Approval Request</span></p>"
      },
      {
        "CellData3": "<td style=\"border-style:solid; border-color:#A3A3A3; border-width:1pt; vertical-align:top; width:1.8076in; padding:4pt 4pt 4pt 4pt\"><p lang=\"en-US\" style=\"margin:0in; font-family:Calibri; font-size:11.0pt\">&nbsp;</p>"
      },
      {
        "CellData4": "<td style=\"border-style:solid; border-color:#A3A3A3; border-width:1pt; vertical-align:top; width:1.4694in; padding:4pt 4pt 4pt 4pt\"><p lang=\"en-US\" style=\"margin:0in; font-family:Calibri; font-size:11.0pt\">n:1 loookup</p>"
      }
    ]
  },
  {
    "Itemnumber": 5,
    "celldata": [
      {
        "CellData1": "<td style=\"border-style:solid; border-color:#A3A3A3; border-width:1pt; vertical-align:top; width:1.8513in; padding:4pt 4pt 4pt 4pt\"><p lang=\"en-US\" style=\"margin:0in; font-family:Calibri\"><span style=\"font-size:11.0pt\">IA Type<br></span><span style=\"font-size:9.0pt\">(a text field to store the types of IA processes) </span></p><p lang=\"en-US\" style=\"margin:0in; font-family:Calibri; font-size:11.0pt\">&nbsp;</p><p lang=\"en-US\" style=\"margin:0in; font-family:Calibri; font-size:9.0pt\"><span style=\"background:#FF99CC\">Option set better??</span></p>"
      },
      {
        "CellData2": "<td style=\"border-style:solid; border-color:#A3A3A3; border-width:1pt; vertical-align:top; width:1.2937in; padding:4pt 4pt 4pt 4pt\"><p lang=\"en-US\" style=\"margin:0in; font-family:Calibri; font-size:11.0pt\">&nbsp;</p>"
      },
      {
        "CellData3": "<td style=\"border-style:solid; border-color:#A3A3A3; border-width:1pt; vertical-align:top; width:1.8076in; padding:4pt 4pt 4pt 4pt\"><p lang=\"en-US\" style=\"margin:0in; font-family:Calibri; font-size:11.0pt\">&nbsp;</p>"
      },
      {
        "CellData4": "<td style=\"border-style:solid; border-color:#A3A3A3; border-width:1pt; vertical-align:top; width:1.5006in; padding:4pt 4pt 4pt 4pt\"><p lang=\"en-US\" style=\"margin:0in; font-family:Calibri; font-size:11.0pt\">&nbsp;</p>"
      }
    ]
  },
  {
    "Itemnumber": 6,
    "celldata": [
      {
        "CellData1": "<td style=\"border-style:solid; border-color:#A3A3A3; border-width:1pt; vertical-align:top; width:1.8513in; padding:4pt 4pt 4pt 4pt\"><p lang=\"en-US\" style=\"margin:0in; font-family:Calibri; font-size:11.0pt\">&nbsp;</p>"
      },
      {
        "CellData2": "<td style=\"border-style:solid; border-color:#A3A3A3; border-width:1pt; vertical-align:top; width:1.2937in; padding:4pt 4pt 4pt 4pt\"><p lang=\"en-US\" style=\"margin:0in; font-family:Calibri; font-size:11.0pt\">&nbsp;</p>"
      },
      {
        "CellData3": "<td style=\"border-style:solid; border-color:#A3A3A3; border-width:1pt; vertical-align:top; width:1.8076in; padding:4pt 4pt 4pt 4pt\"><p lang=\"en-US\" style=\"margin:0in; font-family:Calibri\"><span style=\"font-size:11.0pt\">IA Configuration<br></span><span style=\"font-size:9.0pt\">(a unique name combination created by Power App during submission so linked entities will have meaningful lookup name)</span></p>"
      },
      {
        "CellData4": "<td style=\"border-style:solid; border-color:#A3A3A3; border-width:1pt; vertical-align:top; width:1.5006in; padding:4pt 4pt 4pt 4pt\"><p lang=\"en-US\" style=\"margin:0in; font-family:Calibri; font-size:11.0pt\">&nbsp;</p>"
      }
    ]
  }
] 

 

Put this array in an own Apply to each loop and here you can do anything you like with the collected row data.

Like create a SharePoint item for every row or clean up the HTML using the preview action of HTML to text:

View solution in original post

11 REPLIES 11
fchopo
Super User
Super User

Hello @iko_chen 

Have a look at the following post on how to extract data from an email and parse it: https://365basics.com/microsoft-flow-parse-email-and-extract-information/

Hope it helps!

Ferran

Did I answer your question? Please consider to mark my post as a solution to help others.
Proud to be a Flownaut!

Hi @fchopo 

thank you very much, i had get the solution to extract the content from email, the challenge is my current standardize the notification is a html table, so i need to convert this table to sharepoint list.

 

thank you very much.

br

iko

Hi @iko_chen,

If you are able to extract the data --> what do you with it then?

 

If you want every row of your table to be a newly created item in a SharePoint list:

  1. Create an array and append every table row to that array
  2. Use the array in Apply to each-loop (https://docs.microsoft.com/en-us/power-automate/apply-to-each)
  3. In the loop use the SharePoint Create item action

Hi @Django 

yes, i can extract the content with table(standardized short content) by follow steps, it's not a smart way, so i can't use this way for the tables.

 

thanks!

iko_chen_0-1600130155492.png

 

Just tried to explain in a post (took me over an hour and then lost all my text 😒 because the Forum Site timed out and now is blocking me) so I will try to do in parts.

Hi @iko_chen ,

Because this can get very messy, very fast --> I always recommend to focus on the weakest link in your chain.

Based on the concept of "Garbage in, Garbage out", my advise would be to change your email content in a way that gives you the most flexibility and less headache. You already found my concept here: https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Extract-and-parse-data-from-an-email/td-.... If you could change the content of your email to match keys with values, I think you have the most flexibility.

However... if you absolutely cannot change your email content there may be a way:

My table = 

HTMLtable00Example.png

 

Read the HTML of your email body to count the number of <TR> tags in the HTML code. In my case an expression like:

 

length(split(outputs('Compose_BodyHTML'),'<tr>'))​

 

This gives you the number of pieces of texts/strings separated by.

So my table has 5 rows of which the first row contains only the header but because there is text before the first row we end up with 6 pieces pieces of texts/strings.

We can use this number 6 to loop through every piece of text so we can isolate the data of every row in a Do until loop (do this action until max number is reached) using an expression to extract the text:

 

last(take(split(outputs('Compose_BodyHTML'),'<tr>'),variables('varNRrowsLooped')))

 

​This gives you the data of a whole row in a variable number of loops: in my case my second loop (the one with row data in it) would result in the HTML of the whole header row:

 

<td style="border-style:solid; border-color:#A3A3A3; border-width:1pt; vertical-align:top; width:1.8513in; padding:4pt 4pt 4pt 4pt"><p lang="en-US" style="margin:0in; font-family:Calibri; font-size:11.0pt"><span style="font-weight:bold">Investment Approval Request</span></p></td><td style="border-style:solid; border-color:#A3A3A3; border-width:1pt; vertical-align:top; width:1.2937in; padding:4pt 4pt 4pt 4pt"><p lang="en-US" style="margin:0in; font-family:Calibri; font-size:11.0pt"><span style="font-weight:bold">Investment Approval Step</span></p></td><td style="border-style:solid; border-color:#A3A3A3; border-width:1pt; vertical-align:top; width:1.8076in; padding:4pt 4pt 4pt 4pt"><p lang="en-US" style="margin:0in; font-family:Calibri; font-size:11.0pt"><span style="font-weight:bold">Investment Approval Configuration</span></p></td><td style="border-style:solid; border-color:#A3A3A3; border-width:1pt; vertical-align:top; width:1.7159in; padding:4pt 4pt 4pt 4pt"><p lang="en-US" style="margin:0in; font-family:Calibri; font-size:11.0pt"><span style="font-weight:bold">Investment Approval Log</span></p></td></tr>

 

Within the loop we also need to extract every cell of the row separately --> we use the same concept with the Do until here but then for every cell looking for the end of the cell with the </td> tag

 

length(split(outputs('Compose_ItemData'),'</td>'))

 

This gives you the data of a cell in your row: in my case the first loop would be the HTML of the cell with Investment Approval Request in it:

 

<td style=\"border-style:solid; border-color:#A3A3A3; border-width:1pt; vertical-align:top; width:1.8513in; padding:4pt 4pt 4pt 4pt\"><p lang=\"en-US\" style=\"margin:0in; font-family:Calibri; font-size:11.0pt\"><span style=\"font-weight:bold\">Investment Approval Request</span></p>

 

Then we append this data to a new array of celldata within the array of items (rows)

This gives you the chance to determine what you want to do with every row: in my case the new array looks like

 

[
  {
    "Itemnumber": 2,
    "celldata": [
      {
        "CellData1": "<td style=\"border-style:solid; border-color:#A3A3A3; border-width:1pt; vertical-align:top; width:1.8513in; padding:4pt 4pt 4pt 4pt\"><p lang=\"en-US\" style=\"margin:0in; font-family:Calibri; font-size:11.0pt\"><span style=\"font-weight:bold\">Investment Approval Request</span></p>"
      },
      {
        "CellData2": "<td style=\"border-style:solid; border-color:#A3A3A3; border-width:1pt; vertical-align:top; width:1.2937in; padding:4pt 4pt 4pt 4pt\"><p lang=\"en-US\" style=\"margin:0in; font-family:Calibri; font-size:11.0pt\"><span style=\"font-weight:bold\">Investment Approval Step</span></p>"
      },
      {
        "CellData3": "<td style=\"border-style:solid; border-color:#A3A3A3; border-width:1pt; vertical-align:top; width:1.8076in; padding:4pt 4pt 4pt 4pt\"><p lang=\"en-US\" style=\"margin:0in; font-family:Calibri; font-size:11.0pt\"><span style=\"font-weight:bold\">Investment Approval Configuration</span></p>"
      },
      {
        "CellData4": "<td style=\"border-style:solid; border-color:#A3A3A3; border-width:1pt; vertical-align:top; width:1.7159in; padding:4pt 4pt 4pt 4pt\"><p lang=\"en-US\" style=\"margin:0in; font-family:Calibri; font-size:11.0pt\"><span style=\"font-weight:bold\">Investment Approval Log</span></p>"
      }
    ]
  },
  {
    "Itemnumber": 3,
    "celldata": [
      {
        "CellData1": "<td style=\"border-style:solid; border-color:#A3A3A3; border-width:1pt; vertical-align:top; width:1.8513in; padding:4pt 4pt 4pt 4pt\"><p lang=\"en-US\" style=\"margin:0in; font-family:Calibri; font-size:9.0pt\">Purpose:<br>save data of the request</p>"
      },
      {
        "CellData2": "<td style=\"border-style:solid; border-color:#A3A3A3; border-width:1pt; vertical-align:top; width:1.302in; padding:4pt 4pt 4pt 4pt\"><p lang=\"en-US\" style=\"margin:0in; font-family:Calibri; font-size:9.0pt\">Purpose:</p><p lang=\"en-US\" style=\"margin:0in; font-family:Calibri; font-size:9.0pt\">save data of approval steps linked to a single request</p>"
      },
      {
        "CellData3": "<td style=\"border-style:solid; border-color:#A3A3A3; border-width:1pt; vertical-align:top; width:1.8076in; padding:4pt 4pt 4pt 4pt\"><p lang=\"en-US\" style=\"margin:0in; font-family:Calibri; font-size:9.0pt\">Purpose:</p><p lang=\"en-US\" style=\"margin:0in; font-family:Calibri; font-size:9.0pt\">Save approval step configuration based on properties of the Investment Approval Request</p><p lang=\"en-US\" style=\"margin:0in; font-family:Calibri; font-size:9.0pt\">&nbsp;</p>"
      },
      {
        "CellData4": "<td style=\"border-style:solid; border-color:#A3A3A3; border-width:1pt; vertical-align:top; width:1.6201in; padding:4pt 4pt 4pt 4pt\"><p lang=\"en-US\" style=\"margin:0in; font-family:Calibri; font-size:9.0pt\">Purpose:</p><p lang=\"en-US\" style=\"margin:0in; font-family:Calibri; font-size:9.0pt\">Save important milestones of the process as individual records linked to a single request</p>"
      }
    ]
  },
  {
    "Itemnumber": 4,
    "celldata": [
      {
        "CellData1": "<td style=\"border-style:solid; border-color:#A3A3A3; border-width:1pt; vertical-align:top; width:1.8708in; padding:4pt 4pt 4pt 4pt\"><p lang=\"en-US\" style=\"margin:0in; font-family:Calibri\"><span style=\"font-size:11.0pt\">IA Name<br></span><span style=\"font-size:9.0pt\">(a unique name combination created by Power App during submission so linked entities will have meaningful lookup name)</span></p>"
      },
      {
        "CellData2": "<td style=\"border-style:solid; border-color:#A3A3A3; border-width:1pt; vertical-align:top; width:1.3048in; padding:4pt 4pt 4pt 4pt\"><p lang=\"en-US\" style=\"margin:0in; font-family:Calibri; font-size:11.0pt\">n:1 lookup with </p><p lang=\"en-US\" style=\"margin:0in; font-family:Calibri; font-size:9.0pt\"><span style=\"font-weight:bold\">Investment Approval Request</span></p>"
      },
      {
        "CellData3": "<td style=\"border-style:solid; border-color:#A3A3A3; border-width:1pt; vertical-align:top; width:1.8076in; padding:4pt 4pt 4pt 4pt\"><p lang=\"en-US\" style=\"margin:0in; font-family:Calibri; font-size:11.0pt\">&nbsp;</p>"
      },
      {
        "CellData4": "<td style=\"border-style:solid; border-color:#A3A3A3; border-width:1pt; vertical-align:top; width:1.4694in; padding:4pt 4pt 4pt 4pt\"><p lang=\"en-US\" style=\"margin:0in; font-family:Calibri; font-size:11.0pt\">n:1 loookup</p>"
      }
    ]
  },
  {
    "Itemnumber": 5,
    "celldata": [
      {
        "CellData1": "<td style=\"border-style:solid; border-color:#A3A3A3; border-width:1pt; vertical-align:top; width:1.8513in; padding:4pt 4pt 4pt 4pt\"><p lang=\"en-US\" style=\"margin:0in; font-family:Calibri\"><span style=\"font-size:11.0pt\">IA Type<br></span><span style=\"font-size:9.0pt\">(a text field to store the types of IA processes) </span></p><p lang=\"en-US\" style=\"margin:0in; font-family:Calibri; font-size:11.0pt\">&nbsp;</p><p lang=\"en-US\" style=\"margin:0in; font-family:Calibri; font-size:9.0pt\"><span style=\"background:#FF99CC\">Option set better??</span></p>"
      },
      {
        "CellData2": "<td style=\"border-style:solid; border-color:#A3A3A3; border-width:1pt; vertical-align:top; width:1.2937in; padding:4pt 4pt 4pt 4pt\"><p lang=\"en-US\" style=\"margin:0in; font-family:Calibri; font-size:11.0pt\">&nbsp;</p>"
      },
      {
        "CellData3": "<td style=\"border-style:solid; border-color:#A3A3A3; border-width:1pt; vertical-align:top; width:1.8076in; padding:4pt 4pt 4pt 4pt\"><p lang=\"en-US\" style=\"margin:0in; font-family:Calibri; font-size:11.0pt\">&nbsp;</p>"
      },
      {
        "CellData4": "<td style=\"border-style:solid; border-color:#A3A3A3; border-width:1pt; vertical-align:top; width:1.5006in; padding:4pt 4pt 4pt 4pt\"><p lang=\"en-US\" style=\"margin:0in; font-family:Calibri; font-size:11.0pt\">&nbsp;</p>"
      }
    ]
  },
  {
    "Itemnumber": 6,
    "celldata": [
      {
        "CellData1": "<td style=\"border-style:solid; border-color:#A3A3A3; border-width:1pt; vertical-align:top; width:1.8513in; padding:4pt 4pt 4pt 4pt\"><p lang=\"en-US\" style=\"margin:0in; font-family:Calibri; font-size:11.0pt\">&nbsp;</p>"
      },
      {
        "CellData2": "<td style=\"border-style:solid; border-color:#A3A3A3; border-width:1pt; vertical-align:top; width:1.2937in; padding:4pt 4pt 4pt 4pt\"><p lang=\"en-US\" style=\"margin:0in; font-family:Calibri; font-size:11.0pt\">&nbsp;</p>"
      },
      {
        "CellData3": "<td style=\"border-style:solid; border-color:#A3A3A3; border-width:1pt; vertical-align:top; width:1.8076in; padding:4pt 4pt 4pt 4pt\"><p lang=\"en-US\" style=\"margin:0in; font-family:Calibri\"><span style=\"font-size:11.0pt\">IA Configuration<br></span><span style=\"font-size:9.0pt\">(a unique name combination created by Power App during submission so linked entities will have meaningful lookup name)</span></p>"
      },
      {
        "CellData4": "<td style=\"border-style:solid; border-color:#A3A3A3; border-width:1pt; vertical-align:top; width:1.5006in; padding:4pt 4pt 4pt 4pt\"><p lang=\"en-US\" style=\"margin:0in; font-family:Calibri; font-size:11.0pt\">&nbsp;</p>"
      }
    ]
  }
] 

 

Put this array in an own Apply to each loop and here you can do anything you like with the collected row data.

Like create a SharePoint item for every row or clean up the HTML using the preview action of HTML to text:

I realize my explanation is too big / too complex for the site to load it nicely so let me add an example Flow as an attachment.

Make sure that the only/last email in your inbox contains a table and it should work / explain the concept.

Hi @Django 

thank you very much, i will try your solution.

 

thanks for you details instruction!

 

thanks!

br

iko

Hi @Django 

thank you for your solution, i had extracted the HTML table to sharepoint list, thank you very much.

 
 

Capture.JPG

 

 

 

 

Coul you explain me, how did you do it step by step, please?

Helpful resources

Announcements

Power Platform Connections - Episode 7 | March 30, 2023

Episode Seven of Power Platform Connections sees David Warner and Hugo Bernier talk to Dian Taylor, alongside the latest news, product reviews, and community blogs.     Use the hashtag #PowerPlatformConnects on social media for a chance to have your work featured on the show.  

Announcing | Super Users - 2023 Season 1

Super Users – 2023 Season 1    We are excited to kick off the Power Users Super User Program for 2023 - Season 1.  The Power Platform Super Users have done an amazing job in keeping the Power Platform communities helpful, accurate and responsive. We would like to send these amazing folks a big THANK YOU for their efforts.      Super User Season 1 | Contributions July 1, 2022 – December 31, 2022  Super User Season 2 | Contributions January 1, 2023 – June 30, 2023    Curious what a Super User is? Super Users are especially active community members who are eager to help others with their community questions. There are 2 Super User seasons in a year, and we monitor the community for new potential Super Users at the end of each season. Super Users are recognized in the community with both a rank name and icon next to their username, and a seasonal badge on their profile.  Power Apps  Power Automate  Power Virtual Agents  Power Pages  Pstork1*  Pstork1*  Pstork1*  OliverRodrigues  BCBuizer  Expiscornovus*  Expiscornovus*  ragavanrajan  AhmedSalih  grantjenkins  renatoromao    Mira_Ghaly*  Mira_Ghaly*      Sundeep_Malik*  Sundeep_Malik*      SudeepGhatakNZ*  SudeepGhatakNZ*      StretchFredrik*  StretchFredrik*      365-Assist*  365-Assist*      cha_cha  ekarim2020      timl  Hardesh15      iAm_ManCat  annajhaveri      SebS  Rhiassuring      LaurensM  abm      TheRobRush  Ankesh_49      WiZey  lbendlin      Nogueira1306  Kaif_Siddique      victorcp  RobElliott      dpoggemann  srduval      SBax  CFernandes      Roverandom  schwibach      Akser  CraigStewart      PowerRanger  MichaelAnnis      subsguts  David_MA      EricRegnier  edgonzales      zmansuri  GeorgiosG      ChrisPiasecki  ryule      AmDev  fchopo      phipps0218  tom_riha      theapurva  takolota     Akash17  momlo     BCLS776  Shuvam-rpa     rampprakash  ScottShearer     Rusk  ChristianAbata     cchannon  Koen5     a33ik  Heartholme     AaronKnox  okeks      Matren   David_MA     Alex_10        Jeff_Thorpe        poweractivate        Ramole        DianaBirkelbach        DavidZoon        AJ_Z        PriyankaGeethik        BrianS        StalinPonnusamy        HamidBee        CNT        Anonymous_Hippo        Anchov        KeithAtherton        alaabitar        Tolu_Victor        KRider        sperry1625        IPC_ahaas      zuurg    rubin_boer   cwebb365   Dorrinda   G1124   Gabibalaban   Manan-Malhotra   jcfDaniel   WarrenBelz   Waegemma   drrickryp   GuidoPreite    If an * is at the end of a user's name this means they are a Multi Super User, in more than one community. Please note this is not the final list, as we are pending a few acceptances.  Once they are received the list will be updated. 

Register now for the Business Applications Launch Event | Tuesday, April 4, 2023

Join us for an in-depth look into the latest updates across Microsoft Dynamics 365 and Microsoft Power Platform that are helping businesses overcome their biggest challenges today.   Find out about new features, capabilities, and best practices for connecting data to deliver exceptional customer experiences, collaborating, and creating using AI-powered capabilities, driving productivity with automation—and building towards future growth with today’s leading technology.   Microsoft leaders and experts will guide you through the full 2023 release wave 1 and how these advancements will help you: Expand visibility, reduce time, and enhance creativity in your departments and teams with unified, AI-powered capabilities.Empower your employees to focus on revenue-generating tasks while automating repetitive tasks.Connect people, data, and processes across your organization with modern collaboration tools.Innovate without limits using the latest in low-code development, including new GPT-powered capabilities.    Click Here to Register Today!    

Check out the new Power Platform Communities Front Door Experience!

We are excited to share the ‘Power Platform Communities Front Door’ experience with you!   Front Door brings together content from all the Power Platform communities into a single place for our community members, customers and low-code, no-code enthusiasts to learn, share and engage with peers, advocates, community program managers and our product team members. There are a host of features and new capabilities now available on Power Platform Communities Front Door to make content more discoverable for all power product community users which includes ForumsUser GroupsEventsCommunity highlightsCommunity by numbersLinks to all communities Users can see top discussions from across all the Power Platform communities and easily navigate to the latest or trending posts for further interaction. Additionally, they can filter to individual products as well.   Users can filter and browse the user group events from all power platform products with feature parity to existing community user group experience and added filtering capabilities.     Users can now explore user groups on the Power Platform Front Door landing page with capability to view all products in Power Platform.      Explore Power Platform Communities Front Door today. Visit Power Platform Community Front door to easily navigate to the different product communities, view a roll up of user groups, events and forums.

Microsoft Power Platform Conference | Registration Open | Oct. 3-5 2023

We are so excited to see you for the Microsoft Power Platform Conference in Las Vegas October 3-5 2023! But first, let's take a look back at some fun moments and the best community in tech from MPPC 2022 in Orlando, Florida.   Featuring guest speakers such as Charles Lamanna, Heather Cook, Julie Strauss, Nirav Shah, Ryan Cunningham, Sangya Singh, Stephen Siciliano, Hugo Bernier and many more.   Register today: https://www.powerplatformconf.com/   

Users online (3,286)