Power Platform Community Forum Thread Details

Flow to extract substring fails to match Switch/Case

Looked around on here and on the web but can't seem to find similar -- I'm sure there must have been but guess I'm not using sufficiently similar search syntax...

Created a flow to extract the last 4 characters from a filename when dropped into a library. Variables hold the filename, total length, number of characters to extract, etc. Filenames follow this convention: 601999999 - 0102.pdf. Once extracted, there's a 6-case Switch action, with the 7th as default. Depending on the value, it sends an email to different people.

Flow works just fine at extracting the last four. Result in above example is 0102. It pulls correctly into the Switch.

However, it doesn't match the matching Case:

I believe it has something to do with text vs number (string v integer), but can't seem to work it out.

Here's the Set Variable expression:

substring(variables('FullFileName'),variables('startPosition'),variables('subStringLength'))

And the Switch just holds that variable.

Should note that, when I go to enter the value in each Case, I get a mismatch error if I just type 0102. It will only be happy with "0102". Seems to make sense, since I'm pulling a sub"string" above.

What have I missed? I'm sure it's something stupidly simple.

Quick Links

Leaderboard > Power Automate