Here's a quick example that extracts the Name and Amount from the body of my email.
The email content is below.
Full flow below. I'll go into each of the actions.
Html to text takes in the Body from my email.
This gives us data with a new line character at the end of each row.
Filter array Name and Filter array Amount extract the row that starts with 'Name:' and 'Amount:' respectively. Below are the expressions used.
//Used in both Filter arrays (Splits the data by new line)
split(outputs('Html_to_text')?['body'], decodeUriComponent('%0A'))
//Used in both Filter arrays as part of the condition
item()
This would give us the following outputs. A single item in an array.
We then use the following expressions to extract out just the value part after the colon.
//Name
trim(last(split(first(body('Filter_array_Name')), ':')))
//Amount
trim(last(split(first(body('Filter_array_Amount')), ':')))
Effectively it gets the first item in the Filter array, splits it by colon, retrieves the last item from the split, then trims any white space. The results are:
----------------------------------------------------------------------
If I've answered your question, please mark the post as Solved.
If you like my response, please consider giving it a Thumbs Up.
