cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ravindranath
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

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
chsanche
Community Support
Community Support

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
v-alzhan-msft
Community Support
Community Support

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.

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

 

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
Frequent Visitor

Hi @ravindranath , you manage to get that work?

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Top Solution Authors
Top Kudoed Authors
Users online (3,451)