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.
2
Share
Report
All responses (
Answers (
