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

Hi Amy Thanks for the support.

Hi First you need to save this attachment to onedrive or SharePoint then read it. I have got a similar video which might be helpful. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-urSnaB6G_U4.html Thanks

You are very welcome

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

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

Unfortunately its not possible. Thanks

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

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

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

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

Haven't tried that. I need to look into this.

@@abm4975 will watch your channel

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

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

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

You're so welcome!

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

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

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

Most likely your email body is not consistent.

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

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 Thanks for the support. Believe you can read the text files.

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

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

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? ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-k6O3ZH71Jc0.html

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

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

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

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

Hi Yes its possible. First save the file to OneDrive using PowerAutomate. Then follow this video. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-urSnaB6G_U4.html

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

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

Thanks a lot for the support

You're welcome!

Thanks 🤗

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 ?

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