How to extract information from E-mail in the items “text content”

Hello, I have a problem. I can’t find a right function to extract a word in the email for the “sharepoint list” app.
I just want the formula to use.

I want the word between two words.

Text example:

Closed Project Description: Test project

I would like to extract the word “Project test” before Closed Project Description:

Hi there.

This should be achievable by combining the functions “split” and “get” in one formula. Check the attached blueprint that should help.


blueprint.json (4.1 KB)