Unanswered

Power automate split string

(0) Share

Report

Posted on by 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?

I have the same question (0)

All responses (6)

Answers (0)

DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report

Re: Power automate split string

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])

Was this reply helpful? Yes No
Sean_Perry 11 on at

Like (0)

Report

Re: Power automate split string

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."}}}

Was this reply helpful? Yes No
DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report

Re: Power automate split string

HI @Sean_Perry,

You've doubled up the expression?

Damien

Was this reply helpful? Yes No
Sean_Perry 11 on at

Like (0)

Report

Re: Power automate split string

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?

Was this reply helpful? Yes No
DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report

Re: Power automate split string

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

Was this reply helpful? Yes No
Sean_Perry 11 on at

Like (0)

Report

Re: Power automate split string

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:

Was this reply helpful? Yes No