Unanswered

How to Extract Text from Images Pasted in Emails ( with OCR )

(0) Share

Report

Posted on by Davidvarela

Hi everyone, I'm new to the community, I'm just getting started in this beautiful tool. I have a query. Every week I receive emails with images pasted in the body of the email with numbers and I want to extract those numerical data to keep a weekly control, because they are fuel prices. Could someone help and indicate how I could do the flow? Very grateful for your contributions.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (9)

Answers (0)

Deenuji_Loganathan_ 6,250 Moderator on at

Like (0)

Report
Copy link

Link copied!

@Davidvarela

If possible pls share screenshot of you email with image after hiding all sensitive info?

Was this reply helpful? Yes No
Davidvarela 10 on at

Like (0)

Report
Copy link

Link copied!

Thank you for your support, in the attached image, this is how I receive it in the body of the mail, I do not see it as attached, my client, cuts and pastes it in the body of the mail and I need to extract the data that is observed.

Was this reply helpful? Yes No
Deenuji_Loganathan_ 6,250 Moderator on at

Like (0)

Report
Copy link

Link copied!

@Davidvarela

Are you sure those data are in embedded image of your email body? Or looks like text? Just try to copy some text on those email and see whether you able to copy and paste in some notepad?

Was this reply helpful? Yes No
Davidvarela 10 on at

Like (0)

Report
Copy link

Link copied!

Yes, Deenuji it's an image because when I try to copy it as text it doesn't allow me to, it tells me to copy it as an image. But the text of course does recognize it, there in the attached image you can see the selected text but the image does not, it sends me the message to copy image.

Was this reply helpful? Yes No
Davidvarela 10 on at

Like (0)

Report
Copy link

Link copied!

Hi Deenuji, ,I'm attaching the flow I have designed and the filter I applied to the email in the pad action.

Was this reply helpful? Yes No
Deenuji_Loganathan_ 6,250 Moderator on at

Like (0)

Report
Copy link

Link copied!
@Davidvarela

My email looks like this:

Build your flow something like this:

Begin your flow by using the Outlook launch action.
Retrieve email messages from Outlook, specifying filter details such as subject, body, sender, or recipient. Enable save the attachments option (where it will help us to save including embedded images), to your local drive.

After both actions are executed, you'll find the images from the email in the designated folder.

Utilize a for-each loop to iterate through all the images in the specified folder. Apply the "Extract text with OCR" action to extract text from the images by providing the full path name of each image.

If you need to extract specific numbers or text, employ the "Parse text" action and utilize a regex pattern for extraction(of course use chatgpt to build regex pattern).

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No
Davidvarela 10 on at

Like (0)

Report
Copy link

Link copied!

Great solution Deenuji and thank you very much, when I download the images, not only download what I need, it also downloads other images that come inside the mail.

Was this reply helpful? Yes No
Deenuji_Loganathan_ 6,250 Moderator on at

Like (0)

Report
Copy link

Link copied!

@Davidvarela

Understood. Are all your images in the same extension, or do they have different extension formats? Please confirm.

Was this reply helpful? Yes No
Davidvarela 10 on at

Like (0)

Report
Copy link

Link copied!

Good Morning Deenuji, all the images have the same extension png.

Was this reply helpful? Yes No