Power automate split string

[Sean_Perry]

I am trying to build a Flow to update a SharePoint List when recieving automated emails with a subject line such as the below, where the AEL code is different each time:

Subject "Sky Italia VoD Delivery Notification - AEL0111078 - "

The Sharepoint list contains a list of deliveries that I want to mark as delivered upon receipt of an email. 

I understand that I need to have an Initialize vairable split function, but cannot workout what the next Compose functions needs to contain in order to split the subject line correctly?

[DamoBird365]

Hi @Sean_Perry 

If you are looking for AEL0111078, you can use the following expression (replacing outputs('Compose') with the expression for the subject line):

trim(split(outputs('Compose'),'-')?[1])

I split the string on -, creating an array of 3 objects and return the 2nd (objects start from 0, so 2nd is 1) and then trim the spaces at start/end.

Please consider accepting my answer as a solution if it helps to solve your problem.

Cheers
Damien

Please take a look and subscribe to my YouTube Channel for more Power Platform ideas and concepts, or take a look at my website. Thanks

trim(split(outputs('Compose'),'-')?[1])

[Sean_Perry]

This worked, but I'm obviously making a mistake, as the Get Items in SharePOint is failing:

with the error:
{"odata.error":{"code":"-1, Microsoft.SharePoint.Client.InvalidClientQueryException","message":{"lang":"en-US","value":"The expression \"field_41 eq 'trim(split(outputs('Subject'),'-')?[1])trim(split(outputs('Subject'),'-')?[1])'\" is not valid."}}}

[DamoBird365]

HI @Sean_Perry,

You've doubled up the expression?

Damien

[Sean_Perry]

This is the first time I've ever used the Compose function. I have Flow as below. What I thought I was supposed to do was identify what I wanted to split - the Subject line, run the Compose function, then search in SharePoint for the outcome of that split. As you correctly point out the error message seems to show that the expression is doubled up, but if I remove the filter on the Get Items in SharePoint it finds all the ietms in my List, not just that referenced in the inconing email Subject line? 

[DamoBird365]

Hi @Sean_Perry 

Your expression in the compose has been inserted as a string. Make sure you are on the expression tab when you type this in.

Damien

[Sean_Perry]

I have now followed your very helful advice, built my flow, but despite running tests no action is taking place? The Flow doesn't have any errors, but the field I was hoping to update to Yes remains blank: