Extract values from email subject

[jowenson]

I'm trying to send adaptive cards to a teams channel for when a new email arrives with the information from that email. What i'm trying to do is take the subject of 

Suspect | P3 | Email Summary @ CompanyName

In the adaptive card I have textboxes that have this

"text": "Summary: Email Summary",

"text": "Priority: P3",

"text": "Company: CompanyName",

My question is how do I extract the information from the subject line as that changes but is formatted the same and put it into the adaptive cards dynamically? 

[tom_riha]

Hello @jowenson ,

I prefer to use the split(...) expression with index in the output array as explained in this blog post. e.g.

split('Suspect | P3 | Email Summary @ CompanyName', ' | ')[0]     = Suspect
split('Suspect | P3 | Email Summary @ CompanyName', ' | ')[1]     = P3
split('Suspect | P3 | Email Summary @ CompanyName', ' | ')[2]     = Email Summary @ CompanyName
split(split('Suspect | P3 | Email Summary @ CompanyName', ' | ')[2], ' @ ')[1]     = CompanyName

[trice602 · Accepted solution]

Hi @jowenson ,

Here are the compose expressions to extract the data from the subject.  In my example, I am using a variable named "Subject" but in yours you will use the dynamic content 'subject' from your trigger.

Expression #1:  

trim(split(variables('Subject'), '|')[1])

Expression #2:

first(split(trim(split(variables('Subject'), '|')[2]), '@'))

Expression #3:

trim(split(split(variables('Subject'), '|')[2], '@')[1])

[trice602]

Hi @jowenson ,

So replace variables(Subject) with your dynamic content subject.

[jowenson]

Where I'm getting confused is how is this information dynamic? The email subject will change. The priority, summary, and company all changes retrospectively. So setting the variables static doesn't make sense to me.

[trice602]

Hi @jowenson ,

That's what these expressions do - they exact data in these specific areas within the subject (not static values).  Here's how you can confirm and gain an understanding:

Send yourself a couple of test emails with different values.  I am confident these expressions will work for you.

[jowenson]

Where are these expressions going? 

"text": trim(split(variables('Subject'),'|')[1]) 

??

[trice602]

Hi @jowenson ,

You can use compose actions and then refer to the outputs of each in card.

[jowenson]

My current flow

Compose Priority: 

Summary: 

Company:

Snippet in Adaptive Card:

Priority: "outputs('Priority')",

Company: "outputs('Company')",

Summary: "outputs('Summary')",

It still fails. I've also tried to change the compose from the expressions to what you have in your screenshots and it shows the Input and Output correctly. But when I try to call them on the adaptive card, it fails to run still.

[trice602]

Hi @jowenson ,

It looks like you are typing in the expressions provided as text; they must be entered as an expression.  In your compose action, click on the fx icon or in the input field, type "/" and select expression.

Your output shows they are entered directly as text.  Remember you need to replace "variables(output) with your dynamic content subject from the email trigger.

[jowenson]

I've now added those as expressions instead of plain text. I still do get an error though. Also here is my Initialize Variables 

Error:

The Priority compose with expression corrected