How do I extract data from a table in an email (where the data is underneath the header row) and update a row in an excel file?

[megmi]

Hi! 

I am building a flow where I have sent an automatic email and want to extract the following data from the replies: 

This is an example of a reply and the data I would like to extract: 

I do have the update row portion down pat but am unsure how to extract the email data from the table. 

The HTML to plain text looks like this for the table: 

Application Name

Log in Time (HH:MM)

Did you receive an MFA challenge?

Any issues?

Access Location (e.g. WFH, Name of Office location)

Blah

10:18

Yes

No

Australia

Thanks a lot!!

[v-bofeng-msft]

Hi @megmi ,

I've made a test for your reference:
I assume there is a compose

you could use this formula to get blah

split(split(outputs('Compose'),'Name of Office location)')[1],decodeUriComponent('%0A'))[1]

you could use this formula to get 10:18

split(split(outputs('Compose'),'Name of Office location)')[1],decodeUriComponent('%0A'))[2]

you could use this formula to get yes

split(split(outputs('Compose'),'Name of Office location)')[1],decodeUriComponent('%0A'))[3]

you could use this formula to get no

split(split(outputs('Compose'),'Name of Office location)')[1],decodeUriComponent('%0A'))[4]

you could use this formula to get Australia

split(split(outputs('Compose'),'Name of Office location)')[1],decodeUriComponent('%0A'))[5]

Best Regards,

Bof

[megmi]

Hi @v-bofeng-msft! 

Thanks a lot for your help! 

I tried using the statements you suggested but I got the following error: 

Unable to process template language expressions in action 'Update_a_row' inputs at line '0' and column '0': 'The template language expression 'split(split(outputs('Compose'),'Name of Office location)')[1],decodeUriComponent('%0A'))[3]' cannot be evaluated because array index '3' is outside bounds (0, 0) of array. Please see https://aka.ms/logicexpressions for usage details.'.

Here's what my flow looks like: 

[v-bofeng-msft]

Hi @megmi ,

Please use the plain text returned by the 'HTML to plain text' action :

Best Regards,

Bof

[megmi]

@v-bofeng-msft thanks a lot!! that worked 🙂 Just wanted to ask - if this table has multiple rows would i be able to edit the integer at the end of each expression accordingly? 

[v-bofeng-msft · Accepted solution]

Hi @megmi ,

Yes. But you need to set the correct delimiter.

Best Regards,

Bof

[megmi]

Thankyou!! @v-bofeng-msft