Parse html table data

[ravindranath]

Hi,

How to parse html table in email body and create items in SharePoint list.

Email Body:

Title   Start Time                   End Time                     Description
xyz     05/06/2020 10:00:00  05/06/2020 11:00:00   testing
abc    06/06/2020 14:00:00  06/06/2020 16:00:00    prod

[chsanche]

Hi @ravindranath 

In order to be clear, do you need to take an email body and create records from a table in that email?

Best Regards

[v-alzhan-msft]

Hi @ravindranath ,

Please refer to screenshot below to create the flow and run the flow, share the output in the Compose action so I could provide the steps to create the two items in the sharepoint list.

Best regards,

Alice   

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ravindranath]

Hi Alice @v-alzhan-msft 

Output in Compose action was:

Title

Start Time

End Time

Description

xyz

05/06/2020 10:00:00

05/06/2020 11:00:00

testing

abc

06/06/2020 14:00:00

06/06/2020 16:00:00

prod

[v-alzhan-msft · Accepted solution]

Hi @ravindranath ,

It is not easy to format the date that you provided to a sharepoint list item, I suggest that you could create the table in a excel as attachment of the email, then we could get the rows in the excel table and insert it to sharepoint list.

Best regards,

Alice   

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[yhlow72]

Hi @ravindranath , you manage to get that work?