Apply to Each Issue - Parsing Email

[MDE94]

I have followed many tutorials all without success, some have got me close to what I require but not all. To give an understanding I am trying to parse an email such as:

Name: Firstname1

Age: 23

Location: North

Name: Firstname2

Age: 24

Location: South

Name: Firstname3

Age: 25

Location: East

Name: Firstname4

Age: 26

Location: West

Then add each value into its corresponding column in excel, using 'add to excel table row' function. I'm using an 'Apply to All' function which lists each line in the email as an item, complete with a condition which states *Outputs* (email lines)-Contains-'First Name' 

IF YES - 

COMPOSE --- last(split(outputs('Compose_3'), 'First Name:'))

This works perfect for First Name, but if I follow the same set up for age and location whichever is last in the action takes over each entry for all 3 requirements. I was going to run a separate 'apply to each' however the values cannot be seen in dynamic content when trying to add content to new row within Excel. 

Please see attached, 

[SudeepGhatakNZ]

@MDE94 What is the condition you are using with Age and Location. Startswith will only work for Name in your case.

[MDE94]

Thank you @SudeepGhatakNZ 

I have set another Apply to Each, this shows true reading correct - but I am unable to add the result into excel, as 'Compose 4' and 'Compose 5' do not show in dynamic content. see screenshots

[MDE94]

the issue lies with me not being able to map the compose value within the 'apply to each' into the excel row, as the dynamic content does not exist 

[SudeepGhatakNZ · Accepted solution]

You can refer them simply as outputs('Compose 4') and outputs('Compose 5')