The expression is invalid error on length() formula.

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I'm trying to use all but the last character in a string variable, but Power Automate keeps giving me an "invalid expression" error, and I can't figure out why. Both these expressions give me the "Invalid expression" error...

length(variables('strHolding'))-1 //trying to put this into an integer variable
substring(variables('strHolding'),0,length(variables('strHolding'))-1) //trying to use this in a compose action

The strHolding variable contains a string that could be thousands of characters long, and it's always longer than 100 characters.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Mira Ghaly 11,415 Moderator on at

Like (1)

Report
Copy link

Link copied!
@Anonymous

Please use below Expression

substring(variables('strHolding'),0,sub(length(variables('strHolding')),1))

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

Like (0)

Report
Copy link

Link copied!

Thank you, @Mira_Ghaly, this worked. I was not aware cardinal operators could not be used in Power Automate expressions.

Was this reply helpful? Yes No