Hi @cswanson22 ,
I just shared this on another post and it works here too. Essentially you will use the html to text action and turn the body of the email into text.
Next you will need to use an expression like substring() in a compose action to extract the company name; the position of the company name in the email doesn't matter as long as you can identify a pattern.
Again, different example, but I was looking for the work "Closed" in an email, and then based on the condition being true or false, do a subset of actions.
Without seeing the actual email, one way I may approach this is to look for the character position of the text "has been down" in the email and then use substring to get "NNB". So continuing here, I would use one compose action to find the character position of my phrase in my email body, and another compose to get the company name:
substring(outputs('Html_to_text'),sub(outputs('where_my_phrase_starts'),13),3)
So if the body of the email was 777 and the phrase starts in position 100, I would get the substring of 777 characters starting in position (100-13) = 87, and get the next 3 character "NNB".
Again, there will be variations to consider without seeing the actual email but I find it easier to find a constant phrase within an email template and then dynamically clip the value you need.
