Power Automate - How to read email attachment contents and extract values? Part 1/2

This video explains how to read email attachment contents and extract values using Power Automate.
Expression used in this video are:
base64ToString(outputs('Attachment_Content'))
split(output('Content_Text'),outputs('Carriage_Return'))
Name:
last(split(outputs('Extract_Each_Content_Text')[0],':'))
Date
last(split(outputs('Extract_Each_Content_Text')[1],':'))
Company
last(split(outputs('Extract_Each_Content_Text')[2],':'))
Power Automate - How to read email contents and extract values (unstructured data)? - Part 2/2
• Power Automate - How t...

[@bohony]

This was incredibly helpful, thanks very much for posting!

[@abm4975]

You're so welcome!

[@brandonkrous3386]

You are awesome! Thank you!

[@abm4975]

You're welcome!

[@uau779]

thANKS MR. ABMABM, THIS REALLY HELPED

[@abm4975]

Thanks a lot for the support

[@datadragyn]

This video actually solved 2 mysteries for me. 😊 🙏 😊

[@abm4975]

Hi Amy Thanks for the support.

[@liakat26]

Thanks for sharing ,sir. Bless you.

[@abm4975]

You are very welcome

[@Saibal994]

Thanks for sharing this video. It's really helpful. If I have an Excel attachment then what is the expression formula that I will be using?

[@lubeshbehera1993]

Awesome content 🤗🤗

[@abm4975]

Thanks 🤗

[@reedpathfinder4]

Hi. Would this flow require modification if there are multiple entries that would need to be created from a single email attachment? For example, a .docx attachment with multiple rows in a table.

[@abm4975]

Hi Thanks for your comment. You won't be able to read the .docx contents. It's a word document it will be stored in an encrypted format. Thanks

[@CallmeIrisZ]

Hi! Thanks for sharing this video. It's super helpful. I am trying to build a workflow starting with an attached csv file arrives at mailbox, extract the .csv contents and the from/to/cc email address as another column to be consolidated in one .csv file and save in SharePoint. Could you provide any suggestions on how to achieve the goal? Thanks!!!

[@abm4975]

Hi Thanks so much for the support. I was away for few weeks. Do you still need help in this please? Thanks

[@BobbyHiIl]

Hi! Thanks for the tutorial. Very helpful. Index search isn't the best solution in my case where the attachment text file values are on different rows. (e.g. Name: is on row 9, but row 11 in another attachment) Please provide guidance on what to do in this case?

[@abm4975]

Hi Bobby Great question. I have made a video based on this. Please have a look and comment. Power Automate - How to read email contents and extract values (unstructured data) - Part 2/2? kzbin.info/www/bejne/oWeyZI1-bJZ9mZI

[@reginasantestebanazanza8724]

Hello this video was so thankfull! Just wanted to ask if the attach file is coded in UFT-8 is there a way to read it? thank you vey much!!

[@abm4975]

Hi Thanks for the support. Believe you can read the text files.

[@raushankumarpandey897]

If I m doing the same it's coming as click to download rather showing attachments contents..plz help

[@ittooutabiht4425]

Hello, thank you for this video. I have a case where i use power automate to read emails from vendors, find the PO and the carrier tracking number. Then add this tracking number to the appropriated PO in D365 fo. Any suggestions for that please.

[@abm4975]

Hi Where is your PO held in your email? Is that under the body or subject. Once you extract the values the use the Dataverse connector List rows and apply the filter condition to find the record in D365. One you found the record you can update the tracking number. If you need further help in this please post your requirement details in PowerAutomate community and tag me as @abm. I will have a look. powerusers.microsoft.com/t5/Building-Flows/bd-p/BuildingFlows Thanks

[@ylmazozturk06]

in a word, magnificent. Can you share a video to get the contents of the Excel file in the mail attachment? thank you.

[@abm4975]

Hi Yilmaz Thanks for your support. You need to save the excel file first in SharePoint or OneDrive? Have a look on my channel and there are couple out there describing how to save and read the excel contents. Thanks

[@inc3ption733]

Hello! Great video! I’m trying to do the same thing, but my inputs and outputs only show “click to download.” Do you know how I could remedy this?

[@abm4975]

Hi Most likely your mapping might be wrong. Could you please post in Power Automate Community and tag me as @abm. powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity Thanks

[@ankithguptha5184]

Hello can you make a video on how to extract data from invoices received in the form of documents within Outlook.Dataverse serves as the application’s backend here .

[@abm4975]

Hi Using the AI capability this is possible. I am planning one soon. Keep checking my notifications. Thanks for the suggestion.

[@qaisnaderi6336]

thanks for this video but i have a question , that is . how to send an email from the file contents . eg i have a file wich it includes email address too and i want to extract this email address and need to send emal for the same email address ? so is it possible to do so??? thanks

[@abm4975]

Yes it is possible. Say for example you have Id, Price, email and you have data in below order it is possible. 1, 10.00, [e-mail], 2, 50.00, [e-mail]

[@zorozz1607]

Hii, great content, is it possible to read the content if it was in table format?

[@abm4975]

Hi Sri Yes its possible. Use the HTML to text action step first and see the results. Then you may need to use the split() expression to break each lines. Thanks

[@NawazShareefMohammed]

hello, I have a case where i am receiving email downloadable links, hgow to use logics apps and save the reports data from the links extracted and save it in azure blob.

[@abm4975]

Hi Use the HTTP action step. Set GET as the operation, set the downloadable link and use the body output where you can pass to azure blob. Thanks

[@levplit212]

Helped me a lot to extract from the body of the Email, but then noticed that sometimes the index lines can be different on each Email, how can i solve this?

[@abm4975]

Most likely your email body is not consistent.

[@om0729]

Hi I follow your video step by step and try to read attached excel file from email. but got error because attachment content action is returning null value. is there any solution to read the excel file content?

[@abm4975]

Hi Make sure you have the attachment in your email. Also check the apply each loop where I mapped the Dynamic content. You might have a different mapping? Thanks

[@adithyabontha4396]

Can we get the same flow running for Scanned Image PDF ?

[@abm4975]

Not out of the box. You may need to look third party tools or Power AI builder.

[@yogeshwarsingh6768]

can we Read Excel Attachment without saving it into Onedrive? is it possible in PowerAutomate Cloud?

[@abm4975]

Hi Yogesh Thanks for your question. Unfortunately you need to save the file first. There are no other options. Thanks

[@llllljakelllll]

How do you do it if the attachment is an excel file with multiple rows?

[@abm4975]

Yes first you need to download the excel file to a OneDrive or SharePoint folder. If the excel file have no tables then create it dynamically so that you can read the excel file contents afterwards. I have few videos around this subject. Check it out. Thanks

[@jwalasingh2309]

if we receive xlsx as an attachment in the mail. how we will parse the content of that file

[@abm4975]

Hi Apologies for the late reply as I was away for few weeks. So when you receive via email first download and create to Onedrive using Power Automate. Next create a dynamic table for reading the contents. Have a look on my channel. I have got few videos around this. Thanks

[@NatalyaWilmaRias-bk1ik]

how about attachment in PDF is there a way to read it?

[@abm4975]

Hi, Unfortunately not. You need to look into Open AI API to read the PDF contents. Also have a look on other third party connector in Power Automate. Microsoft don't have anything out of the box to read the PDF contents. Thanks

[@yossilouk8479]

Hello there. can we do that with attached PDF doc?

[@abm4975]

Hi Apologies for the late reply. I was away for a family emergency. Unfortunately it's not possible with PDF docs. There are no out of the box connectors available. Thanks

[@TCEI23]

Can you do this if the attachment is an excel file?

[@abm4975]

Hi Yes its possible. First save the file to OneDrive using PowerAutomate. Then follow this video. kzbin.info/www/bejne/q6O2n5R4a6ySi5Y

[@sajasajad096]

Is it possible extract values from excel attachment

[@abm4975]

Hi Yes you can extract values once it is saved to a location (OneDrive/SharePoint). Thanks

[@bernadettepaterson6867]

Hi great video thanks!!How to save extracted values into SharePoint list please

[@abm4975]

Hi What's your content sample data looks like?

[@athinadodbiba1991]

@@abm4975 my question is partly related to this. So my data is coming from excel attachments and I need to extract them in Sharepoint List. Suggestions? Thanks in advance

[@ArthurHenrique-zn8xv]

Does this work for excel attachment?

[@abm4975]

Yes first you need to download the excel file to a OneDrive or SharePoint folder. If the excel file have no tables then create it dynamically so that you can read the excel file contents afterwards. I have few videos around this subject. Check it out. Thanks

[@manojkumar-zy8vo]

I want to get contents of word document in SharePoint using power automate Is there a solution?

[@abm4975]

Unfortunately its not possible. Thanks

[@darkhorse7449]

How to extract data of an outlook excel attachment into csv

[@abm4975]

Hi Hi I was away for few weeks. Do you still need help in this please? Thanks

[@luckiestgirl3138]

how do i get a form attachment without using sharepoint list?

[@abm4975]

Is this Microsoft Form?

[@luckiestgirl3138]

Yes! Hi I have to make a multi level expenditure approval workflow where a response is submitted via MS Forms but the approver at each level might change i.e they may leave and someone new might come so how do i maintain a database where we can edit the approvers at each level in the hierarchy but without using SharePoint lists. Also, everytime I edit my flow after saving it shows " Client request aborted" and I have to start from scratch everytime. Is there a solution? It would be great if you could suggest something for my queries :) Thanks! @@abm4975

[@abm4975]

Hi You need to store the order of approver somewhere. Why not store in an Excel sheet under OneDrive? Thanks

[@aude1115]

Hi, I tried the flow for PDF attachment : the result of step "base64tostring" show Chinese characters like "�PNG ????" , what do you suggest to resolve ?Thanks!

[@abm4975]

Hi I need to look your flow. Happy to look via a screenshare. Check my Channel about section and connect me via teams. Thanks

[@wolfcompany2]

How hardly will an email come in in this format =.= Not practical.

[@abm4975]

Different business scenarios. There are automated integration jobs send emails in different ways. Thanks

[@ylmazozturk06]

I want to get the contents of the excel file without saving it

[@abm4975]

Hi Yilmaz You need to save the excel file first in SharePoint or OneDrive? Have a look on my channel and there are couple out there describing how to save and read the excel contents. Thanks

[@ylmazozturk06]

hello, no I want to get the content of the file without saving it.

[@abm4975]

For Excel format you won't be able to get that. Only text files we can read from the content. The encryption of excel content won't allow to read dynamically from the attachment itself. Thanks

[@walid3687]

@@ylmazozturk06 You can do that using parse json, you will be able to get every column from the attachment file without storing the file in sharepoint or one drive, but you will need to do many data cleaning before parse json

[@darkhorse7449]

Can you please explain it ?

[@piyachatritmaha9923]

Can read attachment from excel ?

[@abm4975]

Yes you can. First you need to save the excel under SharePoint or Onedrive. Then create a dynamic table for the excel file. Once you create the dynamic table you can read the contents. I have few videos around this. Have a look. Thanks