Hello,
New to Power Automate here. Thanks for your help with my issue.
I have a flow that is trigged by receiving an email to Outlook. The body of the email contains a table with data fields with delimiters.
I use HTML to Text to extract the data and then split outputs in SharePoint Create item action to upload to a list.
Example: split(outputs('Html_to_text')?['body'],'|')[1]
The problem is the text has HTML entities that are still in the text. For example, a date/time value may be received in the email as 12/15/23 17:12. But after HTML to Text, it is actually 12/15/23<br>17:12.
I have determined the data source is correct and it seems Outlook is inserting the HTML. Unfortunately, the source cannot send the mail as plain text. How can convert the HTML message to text and avoid the HTML entities from cluttering my data. Even if I find a way to strip the entities, I am concerned it would leave 12/15/2317:12 which is still improper formatting and would not be recognized as a valid date without the space between date and time.
