Power Platform Community Forum Thread Details

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.

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

Any help would be so greatly appreciated! Cheers : )

Categories:

Building flows

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.

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.