The length of substring can't be longer than '3' which is the length of the source string

(0) Share

Report

Posted on by SachinG31

422

Hello All,

I am using below formula to cut my number string till 2 decimal places.

float(substring(string(),0,add(indexof(string(),'.'),3)))
after inserting dynamic value 


substring(string('outputs('Create_item')?['body/Available_Hours']'),0,add(indexof(string('outputs('Create_item')?['body/Available_Hours']'),'.'),3))

but for some records flow is failing with below error

Error: Unable to process template language expressions in action 'Send_an_email_(V2)_2' inputs at line '0' and column '0': 'The template language function 'substring' parameters are out of range: 'start index' and 'length' must be non-negative integers and their sum must be no larger than the length of the string. Please see

my data value is generally like

121.188590785908

103.997703585366

17.190887200542

All responses (3)

Answers (1)

kiranmai 2 on at

Like (0)

Report

Re: The length of substring can't be longer than '3' which is the length of the source string

Is there any function in Logic apps to check whether the file name has date or not ?
Like in javascript, there is a function : "IsDate"
My requirement is : If the file name has date included (F.e: example_validation_2021-09-02.csv) I should perform some operation
If it doesnt have date in the file name (F.e: example_validation.csv ) no operation needs to be performed.

These kind of files which doesnt have date included is blocking my work 😞

Please help me in this.
Many Thanks
🙂
SachinG31 422 on at

Like (0)

Report

Re: The length of substring can't be longer than '3' which is the length of the source string

Hello @v-JessicaG-msft , Yes you are right that was the reason why this error occurred. Thank you so much for all your efforts to analyze and solve this issue for me.
Now its working good. 😊
Verified answer

v-JessicaG-msft on at

Like (1)

Report
Re: The length of substring can't be longer than '3' which is the length of the source string

Hi @SachinG31 ,

The reason for this error should be that some values of the data value have less than two decimal places. You can use the "concat" function to add more decimals to the dynamic data value to avoid it.

substring(string(concat('outputs('Create_item')?['body/Available_Hours']','000')),0,add(indexof(string(concat('outputs('Create_item')?['body/Available_Hours']','000')),'.'),3))

I have a test for your reference, please refer to the screenshot：

Best Regards,

Jessica Gu

Community site session details

The length of substring can't be longer than '3' which is the length of the source string

Helpful resources

News and Announcements

Quick Links

Paul Stork – Community Spotlight

Congratulations to the June Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Leaderboard > Power Automate

Featured topics

Product updates

Community site session details

The length of substring can't be longer than '3' which is the length of the source string

Helpful resources

News and Announcements

Quick Links

Paul Stork – Community Spotlight

Congratulations to the June Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Subscribe to this forum!

Select categories

Leaderboard > Power Automate

Featured topics

Product updates