Power Automate - How to read email attachment contents and extract values? Part 1/2
Vložit
- čas přidán 14. 10. 2022
- 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...
This was incredibly helpful, thanks very much for posting!
You're so welcome!
This video actually solved 2 mysteries for me. 😊 🙏 😊
Hi Amy
Thanks for the support.
thANKS MR. ABMABM, THIS REALLY HELPED
Thanks a lot for the support
You are awesome! Thank you!
You're welcome!
Thanks for sharing ,sir. Bless you.
You are very welcome
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.
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
Awesome content 🤗🤗
Thanks 🤗
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?
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?
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?
czcams.com/video/k6O3ZH71Jc0/video.html
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!!!
Hi
Thanks so much for the support.
I was away for few weeks. Do you still need help in this please?
Thanks
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.
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
in a word, magnificent. Can you share a video to get the contents of the Excel file in the mail attachment? thank you.
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
If I m doing the same it's coming as click to download rather showing attachments contents..plz help
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!!
Hi
Thanks for the support. Believe you can read the text files.
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 .
Hi
Using the AI capability this is possible. I am planning one soon. Keep checking my notifications. Thanks for the suggestion.
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.
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
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?
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
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
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, Test@test.com,
2, 50.00, Test1@test1.com
Can we get the same flow running for Scanned Image PDF ?
Not out of the box. You may need to look third party tools or Power AI builder.
Hii, great content, is it possible to read the content if it was in table format?
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
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?
Most likely your email body is not consistent.
How do you do it if the attachment is an excel file with multiple rows?
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
can we Read Excel Attachment without saving it into Onedrive? is it possible in PowerAutomate Cloud?
Hi Yogesh
Thanks for your question. Unfortunately you need to save the file first. There are no other options.
Thanks
if we receive xlsx as an attachment in the mail. how we will parse the content of that file
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
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?
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
Hi great video thanks!!How to save extracted values into SharePoint list please
Hi
What's your content sample data looks like?
@@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
how about attachment in PDF is there a way to read it?
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
Can you do this if the attachment is an excel file?
Hi
Yes its possible. First save the file to OneDrive using PowerAutomate. Then follow this video.
czcams.com/video/urSnaB6G_U4/video.html
Hello there. can we do that with attached PDF doc?
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
I want to get contents of word document in SharePoint using power automate
Is there a solution?
Unfortunately its not possible.
Thanks
How to extract data of an outlook excel attachment into csv
Hi
Hi
I was away for few weeks. Do you still need help in this please?
Thanks
Is it possible extract values from excel attachment
Hi
Yes you can extract values once it is saved to a location (OneDrive/SharePoint).
Thanks
Does this work for excel attachment?
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
how do i get a form attachment without using sharepoint list?
Is this Microsoft Form?
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
Hi
You need to store the order of approver somewhere. Why not store in an Excel sheet under OneDrive?
Thanks
I want to get the contents of the excel file without saving it
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
hello, no I want to get the content of the file without saving it.
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
@@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
Can you please explain it ?
How hardly will an email come in in this format =.= Not practical.
Different business scenarios. There are automated integration jobs send emails in different ways.
Thanks
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!
Hi
I need to look your flow. Happy to look via a screenshare. Check my Channel about section and connect me via teams.
Thanks
Can read attachment from excel ?
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