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!
Solved! Go to 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 😙
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 😙
@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?
User | Count |
---|---|
93 | |
44 | |
21 | |
17 | |
16 |
User | Count |
---|---|
137 | |
50 | |
42 | |
39 | |
29 |