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: me@address.com
Sent: Saturday, 17 June 2023 8:39 pm
To: me@address.com
Subject: Test Subject
Question1: Question1 Answer
Question2: Question2 Answer
Lorem Ipsum
So, if anyone can assist....
- How do I parse the email?
- Do I convert to a text file as a first step or using something other than HTML to Text?
- Should I use some trigger other than "When a new email arrives v3"
- 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
