Textfunctions or substring- what am I doing wrong?

(0) Share

Report

Posted on by Amrutledge

I have tried to use both textfunctions and substrings in my flow and I keep getting close but no actual solution. I receive a ton of emails that I need to keep track of what is included in the body of the message. The emails come mainly like this:

Line 1: column1

Line 2: column2

Line 3: column3

Line 4: column4

I tried substring- and got half the information. I tried textfunctions and still can't narrow it down to the right data. The "line 1:" will always be the same (they are using a template) but the column1 data changes based on what is written.

Am I missing something? I have looked at multiple sites and I can't seem to get it narrowed down right.

All responses (1)

Answers (1)

Verified answer

v-LilyW-msft on at

Like (0)

Report

Re: Textfunctions or substring- what am I doing wrong?

Hi @Amrutledge
Thank you for your posting.
Do you want to get the data behind 'Line1-4"? If misunderstanding, please kindly let me know.
I create a Flow to get the data behind ‘Line1-4” and then add the data to an excel.
You can refer to as below screenshots:
Expression:last(split(outputs('Compose'),'Line 1: '))
Expression:first(split(outputs('Compose_2'),' Line 2:'))
Expression:last(split(outputs('Compose'),'Line 2: '))
Expression:first(split(outputs('Compose_3'),' Line 3:'))
Expression:last(split(outputs('Compose'),'Line 3: '))
Expression:first(split(outputs('Compose_4'),' Line 4:'))
Expression:last(split(outputs('Compose'),'Line 4: '))
When receive an email as below:
The new row will be added to the Excel:
For more info about these functions you can refer to:
https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference
Hope the content above may help you.
Best Regards
Lily