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!
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.
Michael E. Gernaey
497
Super User 2025 Season 2
David_MA
436
Super User 2025 Season 2
Riyaz_riz11
244
Super User 2025 Season 2