Add delimited text from email body to excel table

(0) Share

Report

Posted on by Jason79

Hi Community,

Every month, we receive an email with below in the body

--- Content of xTable.csv below ---

To: some.one@a.domain.uk

Response Code,0 - 1 seconds,1 - 2 seconds,2 - 3 seconds,3 - 4 seconds,4 - 5 seconds,5 - 6 seconds,6 - 7 seconds,7 - 8 seconds,8 - 9 seconds,9 - 10 seconds,10+ seconds,Response Code Total

200/404,11070603,61,11,5,9,7,1,0,0,0,7,11070704.0

400,0,0,0,0,0,0,0,0,0,0,0,0.0

499,0,0,0,0,0,0,0,0,0,0,0,0.0

500,0,0,0,0,0,0,0,0,0,0,0,0.0

502,0,0,0,0,0,0,0,0,0,0,0,0.0

503,0,0,0,0,0,0,0,0,0,0,0,0.0

504,49,0,0,0,0,0,5,7,7,11,12,91.0

Other,0,0,0,0,0,0,0,0,0,0,0,0.0

Response Time Total,11070652,61,11,5,9,7,6,7,7,11,19,11070795

Is it possible for a flow (not Desktop) to trigger when email received to move data excluding the rows starting with --- Content of xTable.csv below --- & To: some.one@a.domain.uk so a table in excel is created like below

I've tried split(outputs('Compose'),',') but this returns an array so do I have to split by row initially and then split by ',' so the values are entered in the correct location.

Also, for info Automate in excel is also not available to us.

Advice and if possible visuals of possible solution would be appreciated.

Thanks

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

Jason79 41 on at

Like (0)

Report

After a lot of searching community and Google I have solved, mainly down to this video (https://www.youtube.com/watch?v=0RqSco9Til0) which was added by @Paulie78
Thanks

Was this reply helpful? Yes No
J4ck 25 on at

Like (0)

Report

Hi Jason,

I was wondering if you could share how you achieved this, I'm doing the same sort of thing however I'm sturggling I have watched manys of Paulie's videos but unfortunately dont't have the knownledge behind it to get it to work.

I basically have an email that is sent and I want to extract the data after "@@" characters from the email body and input this into a csv file and email back to the same people.

Not sure if you could point me in the right direction as I have tried many things but I keep getting stuck!

Thanks

Was this reply helpful? Yes No
Jason79 41 on at

Like (0)

Report

Hi @J4ck
Can you provide some screen shots of the email body or paste into your response .
So you receive an email and in the body there's text you want to extract after "@@".
Why does it need to go into a .csv file?
Could the text after "@@" just go into the email body that you are sending back?

I'm still a novice so I may not be able to help but I'll give it a go.

Was this reply helpful? Yes No
J4ck 25 on at

Like (0)

Report

Hi @Jason79

Here is the output of the email, It needs to go into a CSV as theres a lot of data thats needs to be manipulated and having this in a table is much easier to look at rather than the body of the email, and i'm sure you're far more knowledgeable than me, but by no means do I expect you to spend time trying to fix my problem I just thought I could use your solution.

Warning: This email is not from a known sender.
Please find attached\n ATTACHMENT=test.csv&SIZE=423789@@Heading 1.,Heading 2,Heading 3,Heading 4,Heading 5,Heading 6,Heading 7
60,Example,13,Example,Example,6.01,Example
64,Example,15,Example,Example,5.46,Example
21,Example,1,Example,Example,Example,Example
20,Example,4,Example Example,Example,Example

Again thanks a bunch for replying

Was this reply helpful? Yes No
Jason79 41 on at

Like (0)

Report

Hi @J4ck
I've replied on your other thread.
Email Body to CSV - Power Platform Community (microsoft.com)

I'm saving as an excel table which is what I know as a novice. Hope it solves your issue or gives you some ideas of how you resolve your problem.

Was this reply helpful? Yes No