web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Building Flows / How to extract text fr...
Power Automate - Building Flows
Unanswered

How to extract text from an email in a table I think?

(0) ShareShare
ReportReport
Posted on by blocohms74

Hello,

 

This is my first post and I am not exactly sure how I should phrase my question. Fingers crossed this makes sense. I would like to extract text from an email then have that text saved in a Excel file on OneDrive. I would only need 3 pieces of data collected (boxed in red). The issue is, as these are questions, 2 are never the same so I don't know how I could use a variable.

2021-07-21_15-50-13.jpg

 

 

 

 

The other issue is I may receive an email with one question (like above) or 15 different question (see second attachment) all on one email. No I idea how to tackle that...

2021-07-21_15-58-25.jpg

 

 

Any help would be so greatly appreciated! Cheers : )

I have the same question (0)
  • Mitanshu Profile Picture
    Mitanshu 1,637 Moderator on at
    Re: How to extract text from an email in a table I think?

    You can use AI Builder to extract and save the information.

     

    Step1 

    • Create an automated Cloud Flow which triggers when such an email is received.
    • Add a compose action which is:

    <pre>@{triggerOutputs()?['body/body']}</pre>

    • Convert this to a PDF and store on your OneDrive (see screenshot below).
    • Do this for atleast 20 emails, so that you get 20 PDF files.

    happyume_0-1626898463282.png


    Step2

    Now use AI Builder to create a model which will extract the 3 fields from your PDFs. Use the PDFs created in previous step to build, train and test your model.

     

    Step3

    Use the cloud Flow created in Step1 and add action to process the newly created PDF through the AI model created in Step 2. Now use the output from Step2 and save into columns of an Excel file on OneDrive.

     

    Note, your Excel file should not be open when the Flow is writing another row to it - I would suggest use another data-source instead of Excel (for example: a SharePoint List).

     

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 647 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 350 Moderator

#3
developerAJ Profile Picture

developerAJ 256

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!
Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans