cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
invintern
Helper II
Helper II

Parse Text from email body, list data in Spreadsheet

Hello,

 

I am aware that there are 1,000,000 posts on this topic. Thank you for helping me anyways.

 

I want to automate the archiving of these lines of text that come in every morning via email under the same title.

 

Here are the relevant formatting fields from the email:

Title: "Sig Flows Report mm/dd/yyyy"

 

body:

F:

[accountcode] WD of ##,###,### (alternatively, WD may be DP on any line)

[accountcode] WD of ##,###,###

[accountcode] WD of ##,###,###

 

B:

[accountcode] DP of ##,###,### (alternatively, DP may be WD on any line)

[accountcode] DP of ##,###,###

[accountcode] DP of ##,###,###

 

Thank you,"

etc.

 

So,

 

I have got the text split to where I can retrieve the text between 'B:' and 'Thank you,' - to show all three lines, like:

 

'[accountcode] DP of ##,###,###,

[accountcode] DP of ##,###,###,

[accountcode] DP of ##,###,###,'

 

...as the output of a Compose action. 

 

NOW, I would like to take each line and add it to a spreadsheet here: 

invintern_0-1654287132650.png

 

I want the B or F to appear in the B or F coilumn it corresponds to.

I want WD or DP to appear it it's column.

I want the [accountcode] to appear in its column.

 

I can show the Flow if anyone asks, but it is really just an email trigger followed by 10+ text operations as Compose, followed by Add Row into a Table (Excel for Business).

 

I am leaving for the day, but also hitting my wall of understanding. It should be easy enough to take that array (is the output of my Split - Compose an array?) and create a line for each 'line' in the email body...or so I thought.

 

Please advise. Thank you,

-Ryan

 

 

0 REPLIES 0

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Users online (2,736)