I am having difficulty building a new cloud flow. Would appreciate any assistance from the community.
We would like to build a flow to do the following:
I have built a flow that can do all the above, except for 2d (limit files to those with a specific four character ID). Not sure if I cam using the proper terminology when searching for solution. Again, any help is greatly appreciated.
Thanks!
Solved! Go to Solution.
Hi @cmhenry23 ,
Here is a test for your reference:
Here is libraryA:
Here is libraryB:
Please Use Filter Query by File Name (Get files properties only)
Filter query substringof ('Te', FileLeafRef) means: files contain files with 'Te'
substringof('Te',FileLeafRef)
Here is result:
Here are some links for your reference:
Power Automate OData filter query with examples - SPGuides
Best Regards
Cheng Feng
You could use a filter array for this to get what you need; I have a flow like this set up for deleting items that contain specific text in the filename.
Thanks Craig. Having issues with final step. What value would I use in the 'File to Copy'? Have tried many different items
Hi @cmhenry23 ,
Here is a test for your reference:
Here is libraryA:
Here is libraryB:
Please Use Filter Query by File Name (Get files properties only)
Filter query substringof ('Te', FileLeafRef) means: files contain files with 'Te'
substringof('Te',FileLeafRef)
Here is result:
Here are some links for your reference:
Power Automate OData filter query with examples - SPGuides
Best Regards
Cheng Feng
Thank-you Cheng!
User | Count |
---|---|
88 | |
40 | |
23 | |
20 | |
16 |
User | Count |
---|---|
128 | |
49 | |
47 | |
35 | |
25 |