Unanswered

FLOW ERROR

(0) Share

Report

Posted on by Community Power Pla...

I am running the flow during the test and it works at perfectly and does all the action steps. When I launch the flow live, the flow fails and gives the following message but I don't understand because in the test it works perfect every time.

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

Categories:

Using flows

I have the same question (0)

All responses (11)

Answers (0)

Sundeep_Malik 6,484 on at

Like (0)

Report

Hey @Anonymous
Same problem in this flow. Keep following to get your solution.

https://powerusers.microsoft.com/t5/General-Power-Automate/Filter-Array-works-amp-split-into-line-function-working/m-p/1781670#M103503

Was this reply helpful? Yes No
Sundeep_Malik 6,484 on at

Like (0)

Report

@Anonymous
In the mean time share something more so I can help. Like what are you doing[Whole Process], some flow screenshots.

Also both run flows side by side to see differences, maybe.

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

Like (0)

Report

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

Like (0)

Report

These are the screen shots of the flow,

When I run it in testing, the flow is perfect and it does as designed to do. But when I run it on live, the triggers comes up with the error message as shown in the pictures. It saying index 3 is outside bonds (0,2) of array.

but I don't understand why because in the test it works just fine and no errors on the flow checker

Was this reply helpful? Yes No
Sundeep_Malik 6,484 on at

Like (0)

Report

Hey @Anonymous
Can you show the data that's coming after html to text in both cases
Not the real data but like,
If name is there, so write ABC,
Email: abc@gmail.com
Maybe there are some changes in the input.

Btw the video you watched it from, the creator of it, will give a solution in a few days. So follow that previous post, if I am not able to answer you.

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

Like (0)

Report

@Sundeep_Malik sorry I don't follow what you are asking me to do?

Was this reply helpful? Yes No
Sundeep_Malik 6,484 on at

Like (0)

Report

@Anonymous
So, like you are getting the following data in the email:
Name ABC
Email. ABC.com

So, I want you to just give me a test data or example data of whatever you are getting in the output of html to text action.
Exactly same syntax in both the cases. Let's see if there are any differences.

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

Like (0)

Report

This is the input data off the HTML to text:
The Product Group has been changed on the following Sales Order and Line.
SO - 416876
Line - 20
Part - 054140
New Product Group - CA_MFG
Cust ID - 1729
Customer - NCC INDUSTRY AB (SWEDEN)

This is the Outputs Data:
The Product Group has been changed on the following Sales Order and Line. SO -
416876 Line - 20 Part - 054140 New Product Group - CA_MFG Cust ID - 1729
Customer - NCC INDUSTRY AB (SWEDEN)

in the Filter array this is the input data:
[
  "The Product Group has been changed on the following Sales Order and Line. SO -",
  "416876 Line - 20 Part - 054140 New Product Group - CA_MFG Cust ID - 1729",
  "Customer - NCC INDUSTRY AB (SWEDEN)"
]

this is the outputs for filter array:
[
  "The Product Group has been changed on the following Sales Order and Line. SO -",
  "416876 Line - 20 Part - 054140 New Product Group - CA_MFG Cust ID - 1729",
  "Customer - NCC INDUSTRY AB (SWEDEN)"
]

Was this reply helpful? Yes No
Sundeep_Malik 6,484 on at

Like (0)

Report

@ExpiscornovusAny help here. I am really bad with expressions.

Was this reply helpful? Yes No
Kaif_Siddique 2,108 Super User 2024 Season 1 on at

Like (0)

Report

Hi @Anonymous ,

You are getting above error because array index is outside bounds of array.
For example, lets take input value 'Power - Automate - Desktop' and apply split expression with separator '-'. Now the input value will split in to 3 sub text. Power , Automate and Desktop. Here the lower bound is 0 and upper bound is 2. So if i want to extract Automate then my expression would be outputs('Compose')[1]. But will get error for index value 3.

Sample Flow for your reference.

Kindly, check your input value and update the expression based on it.

If you like my response, please give it a Thumbs Up.
If this helps, please Accept as solution.

Regards
Kaif

Was this reply helpful? Yes No