cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Parse html table data

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Parse html table data

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.

View solution in original post

5 REPLIES 5
Highlighted
Microsoft
Microsoft

Re: Parse html table data

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

If this post helps you give a :thumbs_up: and if it solved your issue consider Accept it as the solution
Highlighted
Community Support
Community Support

Re: Parse html table data

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.

1.png

 

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.

Highlighted
Regular Visitor

Re: Parse html table data

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

 

Highlighted
Community Support
Community Support

Re: Parse html table data

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.

View solution in original post

Highlighted
Frequent Visitor

Re: Parse html table data

Hi @ravindranath , you manage to get that work?

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (6,523)