Email content into separate rows in Excel

(0) Share

Report

Posted on by SupaMC

Hi everyone,

I need to extract the content out of an email (rough example below) and save it in excel table.

There is always one Order but the number of ‘Part Numbers’ is variable (at least 1) per email.

I created a flow that splits/trims the body and ultimately puts the content of single e-mail into one row but I need to have all part numbers in separate rows, as per attached examples.

Do you have any tips, or know any tutorial on how to fix it?

Many thanks!

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (1)

Kaif_Siddique 2,108 Super User 2024 Season 1 on at

Like (0)

Report

Here is a logic to split new line text. Could you try to apply same in your flow.

Compose 2:

trim(Split(Split(outputs('Compose'),'Order Number:')?[1],'Part numbers:')?[0])

Compose 3:

split(trim(Split(outputs('Compose'),'Part numbers:')?[1]),decodeUriComponent('%0A'))

Apply to each

{outputs('Compose_3')}

Compose 4:

{items('Apply_to_each')}

Regards

Kaif

Was this reply helpful? Yes No
SupaMC 19 on at

Like (0)

Report

thanks,

I adapted your flow accordingly but got following error on "apply to each"
One additional remark to 'body'.
Right after list of Part Numbers there is additional text (starting with 'You will (..)' that I do not need, so it should be excluded.
Same with 'null' next to Part Number

Was this reply helpful? Yes No
Kaif_Siddique 2,108 Super User 2024 Season 1 on at

Like (0)

Report
Update Compose 3:

split(trim(Split(Split(outputs('Compose'),'Part numbers:')?[1],'You will')?[0]),decodeUriComponent('%0A'))

Was this reply helpful? Yes No
SupaMC 19 on at

Like (0)

Report

Thanks!
We are almost there, hopefully last issue...

Output of compose 3 ('part numbers') seems to be fine but still some blank cells are added to the table which are not needed.
I noticed it happens when there are more than 1 mail sent at the same time (which is more than probable).

Additionally, is there any quick solution go get rid of text after '='?

EDIT:
I created additional column (that indicated 'empties') and two more actions in order to delete the empties, but they have not been found, despite they were there..

Any ideas?

Was this reply helpful? Yes No
Kaif_Siddique 2,108 Super User 2024 Season 1 on at

Like (0)

Report
To remove '=' use replace function

replace(items('Apply_to_each'),'=','')

To delete records add the below step:

If I have answered your question, please mark my post as Solved.

If you like my response, please give it a Thumbs Up.

Regards

Kaif

Was this reply helpful? Yes No
SupaMC 19 on at

Like (0)

Report

Hi,
I need to delete not only '=' but everything after (and including) '=', see below - only green text should stay.

This one above doesn't work anyway as it creates two lines for each number, one with '=', second without

Was this reply helpful? Yes No
Verified answer

Kaif_Siddique 2,108 Super User 2024 Season 1 on at

Like (1)

Report
update replace with below expression.

trim(first(split(items('Apply_to_each'),'=')))

If I have answered your question, please mark my post as Solved.

If you like my response, please give it a Thumbs Up.

Regards

Kaif

Was this reply helpful? Yes No
SupaMC 19 on at

Like (1)

Report

exactly what I needed, thanks!

Was this reply helpful? Yes No