How do I Parse Microsoft Outlook Form to Excel via Power Automate?

Question

Hi

I am trying to use Power Automate to parse emails received from clients that are based on a form that was created using Developer capability within Outlook and to put all fields into an Excel file.

I cannot use MS Forms for clients external to our organisation, and while other options might be available, they too are a little challenged so I am trying Outlook (for better or worse...)

I have created an email template which has the standard Body component and I have also added several Text Boxes to capture the results to a series of questions to our clients. I have set the write and read views to be slightly different but all fields are in both views.

When I run the form, and send it to myself, I get the expected To/From/Subject/Date-Time/Message components as per a standard email and also all my expected questions and answers.

I have passed the To/From/Subject/Date-Time/Message components to Excel.

And here is the problem.... Using HTML to Text "When a new email arrives v3" returns the body of the email Message component only ("Lorem Ipsum" as indicated below) so I can pass the bits noted above but repeatedly fail with the questions and answers..

Clearly the questions and answer Text boxes are not rendering as HTML. If I save the email as a text file to my desktop (this is what I see);

From: ******@address.com

Sent: Saturday, 17 June 2023 8:39 pm

To: ******@address.com

Subject: Test Subject

Question1: Question1 Answer

Question2: Question2 Answer

Lorem Ipsum

So, if anyone can assist....

1. How do I parse the email?
2. Do I convert to a text file as a first step or using something other than HTML to Text?
3. Should I use some trigger other than "When a new email arrives v3"
4. Something else (other than don't use Outlook forms)... or maybe embed a Microsoft form into Outlook (how do I do that????)

Thanks in advance

Alan

Answer 1

Hi @Alan B ，

Welcome to Microsoft Q&A!

Please understand that the "Outlook" tag is dedicated to supporting general issues about the Outlook desktop clients. Since your question is related to Power Automate which is currently not supported in Q&A, you can repost your question into the dedicated Power Automate Community below:

Microsoft Power Automate Community

Thanks for your understanding!