Answered

Start index error - substring

(0) Share

Report

Posted on by gabie

Hi, I have some problem with my flows. Everything was working since a few months and yesterday I have received error message: The 'start index' for function 'substring' must be equal to or greater than zero and must be less than '0' which is the length of the string..

However I didn't change anything. I can also see that sometime I have a success but its 1 success and 10 errors (or more). When I performed the test, there was also error. Anyone of you had such issue? Do you know the reason?

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

Ellis Karim 11,983 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @gabie ,

Please share the flow, expressions used, along with some sample data.

Please also provide a screenshot of the error and where in the flow the error occurs.

Thanks,

Elllis

Was this reply helpful? Yes No
gabie 6 on at

Like (0)

Report
Copy link

Link copied!

In general this flow is for hiding the emial under appropriate folders in outlook. The step which has error is "filter array":
substring(item()?['main_folder'], 0, 4), short_dCode is set as variable in previous step:

The flow is using a information from macro as an input. It's been worked for a few months without any issue.

Was this reply helpful? Yes No
Verified answer

Ellis Karim 11,983 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @gabie

Please check that the data for the column 'main_folder' to ensure that it contains data and is not empty.

As your source data is Excel please check the Excel file for missing data or empty rows. Is there a row at the end of Excel the table, which if read returns an empty value for 'main_folder' causing the expression to fail

substring(item()?['main_folder'], 0, 4)

Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
gabie 6 on at

Like (0)

Report
Copy link

Link copied!

You're right, I missed empty row, thank you for your help 🙂

Was this reply helpful? Yes No