Filter Query by File Name (Get files properties only)

[A-IT]

I am trying to create a flow that will copy all files from one folder to other folders based on the file name. I was able to create the flow to copy all files in one folder to another single folder. Now I am trying to expand the usability by automatically sorting based on a portion of the file name.

I have my test files above. I want anything with '1A' in the name to be moved to Folder 1, '2B' moved to Folder 2, etc. I tried using an initializing variable and conditions, but it doesn't seem to be working since it's "Apply All". I am attempting to use the Query Filter for the file names highlighted in red.

I'm attempted the following ODOTA queries with no luck:
Name contains('1A')
Title contains('1A')
FileLeafRed contains ('1A')

I've also tried all the above with endswith. Any help of how to correctly write the query would be much appreciated. I would prefer a function like 'contains' so it will look anywhere in the file name for the characters I want. I believe if I can get this function working, I can alter it to other uses. Thank you!

[Paulie78 · Accepted solution]

Try:

substringof('1A',FileLeafRef)

That should do what you need.

Please...

If I answered your question Accept it as a solution ✔️ 

If I helped you out, please give me some Kudos 👍

Thanks 😙

[A-IT]

@Paulie78 thank you! For my learning, when writing ODOTA, is it function first, then what you're querying, followed by which Cell you want to compare it to?