How to match the email subject to my sharepoint list

[Yue_Jiang]

I'm currently building a flow that when an email arrives, i will use condition to determine whether the subject of the email contains "SDS need to update" as my previous emails sent out to suppliers is similar to below. 

If the replied email does contain "SDS need to update", i will match the information from the subject to my SharePoint list and then change the specific cell in status column with all matched information to be "responded". 

Currently, I'm thinking how to match information from email's subject to SharePoint list. 

First, i initialize the variable, then i try to set variable by adding the value as split(body of email, "-"), which is to use dash as the delimiter. Is this right? Then, i find that the output is 

SDS need to update ,

SAP code/Supplier/Manufacturer

As only SAP code is my Material name, i eventually got three names for Material name. I don't know how can I do next. 

Ideally, if i got three variables - material name, supplier, manufacturer, how can i subsequently match with my sharepoint? I can first get items, but i don't know how to match between dynamic items in sharepoint and these three variables i've created. 

Hope someone can help me out!!!

[v-yetonggu-msft · Accepted solution]

Hi @Yue_Jiang ,

I did a test for your reference.

In my scenario:

My Outlook Inbox:

My SharePoint List:

I'm using SAP code to match items in SharePoint lists.
I noticed that there are spaces in your SAP code Column Name. This will cause the display name of the column to be different from the internal name. We need to use the internal column name in the OData Filter of Get items. 

Here is the link to view the internal column names of the columns:

How to Find the Internal Name of a SharePoint Column – Ellis Karim's Blog

My Flow:

split(split(triggerOutputs()?['body/subject'],' - ')[1],'/')[0]
SAP_x0020_code eq '@{outputs('Compose')}'

Note that when quoting the expression I provided, you should replace 'SAP_x0020_code' with the internal name of your own 'SAP code' column. Our internal column names may be different.

Best Regards,

Sunshine Gu