Power Platform Community Forum Thread Details

Hello all,

I am trying to build a flow that parses specific text from an email to SharePoint.
The email's format is always like the one below but there could be multiple lines:

This is so far my flow but I am stuck as I don't know how to select the specific text and, eventually, how to repeat the same step multiple times (in case there are various expenses)

Any suggestions are welcome.

Thank you!

Categories:

Building flows

after the Converting the HTML to text you need to write in the "search" criteria so the items get added to the proper cell in the row of your LIST

first(skip(split(body('Html_to_text'), 'Delivery Method: '), 1))

So, in simpler terms, this code extracts the information following the "Delivery Method: " string from the email body. It uses a combination of functions to split the text into segments, skip the initial part, and then take the first remaining segment.

1.`body('Html_to_text')`: This part retrieves the text body from the email. `Html_to_text` is a function or action that takes
the HTML content of an email and converts it into plain text.

`split(body('Html_to_text'), 'Delivery Method: ')`: The `split` function divides the text into parts based on the specified delimiter,
which is `'Delivery Method: '` in this case. This means that the text will be split wherever it finds the string
"Delivery Method: ". The result is an array of text segments.

`skip(..., 1)`: The `skip` function is used to skip a specified number of items from the beginning of a collection.
                            In this case, it skips the first item in the array produced by the `split` function.
                            This is done because the information of interest follows the "Delivery Method: " string, and the first item in
                             the array may contain content before this string.

`first(...)`: The `first` function retrieves the first item from a collection.
In this case, it gets the first (and only, after skipping the initial segment) piece of text after the "Delivery Method: " string.