Extracting multiple text from email body and add into a new row in an excel spreadsheet table

[hakister]

Hello everyone,

I am currently working on a flow where:

1. the trigger is receiving an email in our shared outlook mailbox with a specific subject title
2. the contents from the body of the email will be converted into text.
3. I want to extract all instances of the following information:
   1. Date of Availability: 09/05/2023
      Time Start: 1:00
      Time End: 13:00
4. The email body may contain several instances of Date of Availability, Time Start, and Time End. 
5. Ideally I would want to format the date to be stored as dd/mm/yyyy and the times to follow a 24hr format. 
6. I then want to group each instance into a row that is to be added in an existing excel spreadsheet table. The Date Submitted and Email columns will be prefilled with the data from the email itself:

I have done steps 1 and 2 but I am stuck on how I can execute the next steps.

The email may look something like this

I have tried the ParseJSON approach, but apparently that's not an option since the email is not in JSON format. Any advice and help will be greatly appreciated!

Tagging @abm because I saw his approach on his YouTube video and wanted more input.

[hakister]

Can anyone help me with the above question please?

[AlexEncodian]

@hakister 

For the extraction step 3, you can use native split function to split the various instances (e.g. using split character "Date of") and then use substring extraction to extract individual values by finding the start position, the finding the end position and then extracting the value. Then repeat this for each value. It does become cumbersome.

For a simpler and easier to build solution, may I suggest looking at Encodian's Utility - Extract Text between Values action e.g. extract text between “Availability: “ and “ Time Start:”. It does not currently handle multiple instances. It will only return the first instance. Therefore you need to split the instances e.g. split control character “Date of” and then use the Encodian action on each of the split instances.

FYI – Encodian actions with the “Utility“ prefix only consume 1/20th of Encodian action count (apart from on free plan). For example, a Standard plan has 500 actions (so utility actions can be used 500x20 = 10,000 times).

Hope that helps