Unanswered

Extract data from email attachment to excel sheet

(0) Share

Report

Posted on by Mahipundir

Dear all,

Hoping if someone can share their experiences, I'm trying extract data from email attachment (.html) contain table to Excel file.

Scenario.

Email arrives with an attachment (.html file format) and the attachment will have table and content, I would like to extract data from .html to excel using power automate.

Email arrives > outlook rule to a FOLDER> power automate > when an email arrives>

Thank you in advance for reading.

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

Ram Prakash Duraisamy 5,593 Super User 2025 Season 2 on at

Like (1)

Report

Hi @Mahipundir

You need to Use AI Builder to Extract Data from Outlook Attachment.

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA

Blog : https://microsoftcrmtechie.blogspot.com

Was this reply helpful? Yes No
Mahipundir 68 on at

Like (0)

Report

Hey @rampprakash, thank you so much for your reply.

I was thinking about it after reading here & there, by any chance you would be able to send me an example ..?

Once again thanks mate

Was this reply helpful? Yes No

rajasubr

75 on at

Like (1)

Report

Hey @Mahipundir,

I have another idea. But yet to check from my side.

Idea:

The flow can start with a trigger - when an email is received.
Save the attachment (.html) to One Drive or SharePoint.
Use Get Row action (if you know Key) or List rows present in a table (with top count 1)
Get the values of the first column with the title, and the second column value. Create a File name.
Save the file to the local drive with the file name or One Drive or SharePoint

BR, Raja Subramanian

If this reply helped you to solve the issue, please mark the post as Accepted Solution. Marking this post as Accepted Solution will help many other users to use this post to solve the same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone.