Power Platform Community Forum Thread Details

Good day,

I have created a flow that takes an incoming email from a shared mailbox (v3) , converts html to test then parses each line and updates a SharePoint list with each of the parsed items. The flow works great. The challenge is we received an email with morning that then failed as there was a blank line in between the text.

I have done some searching but can't find an easy way to remove or ignore blank lines between valid text. I know there is functions such as empty(), etc but I can't seem to incorporate them.

I am sure there are better way to parse out each line of the email but this works for me

Firstline of email is:

split(replace(outputs('Html_to_text')?['body'], decodeUriComponent('%0A'), '|'),'|')[0]
 
Pull just the first line of email after ":" is: 
split(outputs('FirstLineofEmail'),':')[1]
 
The flow will fail when it sees the black space as per this example. 
 
Thank you for any assistance. I really appreciate all the help I get from this forums.