Unanswered

MS Flow Variable Remove Last Character In a String

(0) Share

Report

Posted on by bclarkuncc

I am trying to remove the last character from a string variable in MSFlow. I've tried several things but so far no luck. Any feedback on the best way to do this?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Brad_Groux 4,556 on at

Like (0)

Report

There are a few ways to do this, but nearly all of them revolve around utilizing the Compose action. See the Functions documentation for Flow, and the Using Functions within Flow using the Compose Action blog post for some further ideas on how it can be used.
If you could provide an expanded screenshot of your Flow and steps, and of any detailed error messages you're receiving we could likely better assist you.
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
Verified answer

ScottShearer 25,270 Most Valuable Professional on at

Like (10)

Report

@bclarkuncc

This should help....

In my example, I have a string called varString.

The expression that I used to get all but the last character is:

substring(variables('varString'),0,add(length (variables('varString')),-1))

The substring function allows me to extract part of a string - I specify where to start (position 0) and how many characters I want.

To find how many characters to take, I use the length expression to give me the string length and subtract one for the result.

Was this reply helpful? Yes No
v-bacao-msft on at

Like (4)

Report
Hi @bclarkuncc ,

The methods provided by Scott are valid, and you could also consider using take() function.

take(variables('String'),sub(length(variables('String')),1))

Image reference:

There are a lot of functions in WDL function that can be used to process strings. For more details, please refer to Online doc:

https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference

Best Regards,

1 people found this reply helpful.

Was this reply helpful? Yes No
ques0buffet 105 on at

Like (0)

Report

This is helpful but make sure you check if your variable has data before using the function.

Example of the error you will receive:
InvalidTemplate. Unable to process template language expressions in action 'Compose' inputs at line '1' and column '2727': 'The template language function 'take' parameters are out of range: 'count' must be a positive integer. The provided valus is '-1'. Please see https://aka.ms/logicexpressions#take for usage details.'.

Was this reply helpful? Yes No