expression to format a value

(0) Share

Report

Posted on by drossi90

188

Hi there,

I have a flow that captures a user input, the expected input is "LH" and then some digits. For example, LH12345 or LH123456.

I have a flow that consumes this user input, but sometimes the user inputs just the digits, an example: "12345" or "123456".
Or, sometimes users include a space, LH 12345 etc. This causes my flow to fail, as it is expecting it to start with "LH" and for there to be no spaces.

How would I write an expression that checks if: 1. If it does not start with LH, then add that in and or, remove any spaces?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Chriddle 8,430 Super User 2025 Season 2 on at

Like (0)

Report
Here outputs('Compose') is the number to check. If your number is already a string you can remove the string function.
Note that "LH" is case-sensitive here:
replace( if( equals( substring(string(outputs('Compose')), 0, 2), 'LH'), outputs('Compose'), concat('LH', string(outputs('Compose')) ) ), ' ', '' )

Was this reply helpful? Yes No
drossi90 188 on at

Like (0)

Report

Thanks @Chriddle , that looks good.

And if it's "lh", how would we overcome that to not be case-sensitive?

Was this reply helpful? Yes No
Chriddle 8,430 Super User 2025 Season 2 on at

Like (0)

Report
Use toUpper() before comparison:
replace( if( equals( substring(toUpper(string(outputs('Compose'))),0,2), 'LH' ), toUpper(outputs('Compose')), concat('LH', string(outputs('Compose'))) ), ' ', '' )

Was this reply helpful? Yes No