You’re offline. This is a read only version of the page.
Announcements
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.
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
Share
Report
All responses (
Answers (
522
