Answered

Add multiple rows into an excel table based on an email text

(2) Share

Report

Posted on by CU14081154-0

Hello everyone,

I am trying to build a flow in Power Automate, based on the email that I send I want add rows into an excel table containing the text information after the 'Description:' , ';HS code:' , 'Justification' and 'Company'.

So far so good, the flow is working but.... not as expected. In the excel table it brings only the data marked in green. I would like to have also separate rows the data marked in red. I don`t know how to configure 'apply to each' function and I would need your support in that.

Below you can see how the flow is built

Thank you in advance for you help and guidance!

regards, Alin

Categories:

General topics

I have the same question (0)

All responses (8)

Answers (1)

Michael E. Gernaey 53,429 Super User 2025 Season 2 on at

Like (2)

Report

Hi,

Just to verify, you actually have 3 Sets of data, of which you want to turn 4 Lines (each box has 4 lines) into a new row

However, does the Email always have 1,2 or 3 or more "records", aka 4 lines?

Was this reply helpful? Yes No
Chriddle 8,443 Super User 2025 Season 2 on at

Like (2)

Report
If the email always contains complete data sets in the same order, you can do something like this:

Split lines and filter by relevant rows

Chunk these rows by number of properties

Capture the property value

Filter array

From

split(outputs('Compose'), decodeUriComponent('%0A'))

Filter

@or( startsWith(item(), 'Description:'), startsWith(item(), 'HS code:'), startsWith(item(), 'Justification:'), startsWith(item(), 'Company:') )

Select

From

chunk(body('Filter_array'), 4)

Map Description

trim( substring( item()[0], add(indexOf(item()[0], ':'), 1) ) )

Map HS Code

trim( substring( item()[1], add(indexOf(item()[1], ':'), 1) ) )

etc.

Result

An array of objects that you can add to Excel

Was this reply helpful? Yes No
CU14081154-0 26 on at

Like (1)

Report

Hello all,

sorry I was off for few days...

Thanks Chriddle for you suggestion , I`ll try it up today.

Hello FLMike, yes, the email can have from one up to dozens of records", aka 4 lines.

Thanks & keep in touch!

Regards,

Alin

Was this reply helpful? Yes No
CU14081154-0 26 on at

Like (1)

Report

Hello Chriddle,

how did you end up with this compose result?

Thanks for answer!

Alin

Was this reply helpful? Yes No
Chriddle 8,443 Super User 2025 Season 2 on at

Like (2)

Report

If your email is plain text, just put its body into the Compose.

If it's an HTML email, use the "HTML to text" action.

Was this reply helpful? Yes No
Suggested answer

CU14081154-0 26 on at

Like (1)

Report

Thanks for guidance Chriddle!

I have made few modifications into my table and also to the configuration. Now I have 5 data within a ”set” and I have amended also the mapping.

chunk(body('Filter_array'), 5)

Then I shall go for each ‘Body item’?

Apply to each ‘current item’

And then ‘add a row into a table’ but how do I identify which data shall be added in the table? For instance in the ‘Description’ filed shall I go for with:
trim(first(split(last(split(outputs(‘Html_to_text’)?[‘body’], ‘Description:’)), ‘Customs Code:)))

Thanks a lot!!!

Was this reply helpful? Yes No
Verified answer

Chriddle 8,443 Super User 2025 Season 2 on at

Like (2)

Report
Why are you using two (nested) loops? You should only have one.

Assuming you are looping over body('Select'),
you can access the current element within the "Apply to each" with items('Apply_to_each').
To get the description, just use:

items('Apply_to_each')?['Description']

Was this reply helpful? Yes No
CU14081154-0 26 on at

Like (1)

Report

Thank you so much Chriddle !!!

Thanks to your valuable help now I`m having all the data into the excel table.

Was this reply helpful? Yes No