Unanswered

Unable to process template language expressions in trim/split action, causing Flow Failure status even if it succeeds

(0) Share

Report

Posted on by Community Power Pla...

Error is:

Unable to process template language expressions in action 'Initialise_SubjectTrimmed' inputs at line '0' and column '0': 'The template language expression 'trim(split(split(variables('EmailSubject'),'Issue ')[1],':')[0])' cannot be evaluated because array index '1' is outside bounds (0, 0) of array. Please see https://aka.ms/logicexpressions for usage details.'.

My code is:

trim(split(split(variables('EmailSubject'),'Issue ')[1],':')[0])

What I'm trying to do:

The code takes the subject from an email and tries to find the text between "Issue " and ":". For example, if the email subject is "Issue 123: something is broken", the output is 123.

The problem:

If the Issue text exists, the script functions normally. I have configured a runafter if the above action fails (eg there was no issue text) and the entire script functions. However, this triggers the above error and the flow is considered a failure. Ultimately I don't care about the error as I'm handling it, but this problem is making it hard to debug other errors as it's giving me false positives.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Sundeep_Malik 6,484 on at

Like (0)

Report

Hey @Anonymous

Can't test this currently, but try this expression for this:

split(split(variables['EmailSubject'],':')[0],' ')[1]

So, in the above expression, first I am splitting the string where colon is. Then taking the 0 index value.

So, if we take the example
Issue 123: Error
Then after first split the expression would look like this:
[Issue 123], [Error]
Then in the second split I am taking Issue 123 and splitting it at a space and as I want 123 I am using [1] to extract it.

I hope this helps. 🙂

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi Sundeep,

That's a cool way to do it - but if the email subject is "Re: Issue 123: error", I assume that this won't work because it'll start parsing at the first colon.

Was this reply helpful? Yes No
Verified answer

v-dezhili-msft Microsoft Employee on at

Like (1)

Report

Hi @Anonymous ,

Are you trying to split the string by the keyword "Issue"?
I suggest you add a Condition action to compare whether "Issue" is included in the string before splitting.
.

Best Regards,
Dezhi

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thanks Dehzi, that's a great solution. That has solved my problem 🙂 I've re-organised my flow to fit this logic.

For anyone else trying this, I also added an IsInteger check afterwards in case someone uses the word "Issue " but doesn't follow it with a number.

Was this reply helpful? Yes No