Unanswered

Using power automate to look for specific files in Sharepoint folder and move the files to another folder in Sharepoint

(1) Share

Report

Posted on by Ac2022

I created a manual trigger of text to help the user to input the "specific name of the file" however I'm stuck as to how to connect the input to the existing data to search and move.

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

David- 1,254 on at

Like (1)

Report
You can do this with the following steps:
Get files (properties only) action with a filter query
Use the query FileLeafRef eq 'filename.ext'
Use a compose action to check that it found files with the expression length(outputs('Get_files_(properties_only)')?['body/value'])
Follow with a condition where the output of the above Compose action is greater than or equal to 1
If yes, use an Apply to each action with the Value of the Get files action. If no, you can end your flow.
Add a Move file action in the Apply to each and set the File to Move field with the Identifier value from Get files and specify where you want it to move the files it finds.
Since you says you want to find "all" files with a specific name, be sure to choose Move with a new name in the If another file is already there field.
Your flow will look like this:

Was this reply helpful? Yes No
Ac2022 6 on at

Like (1)

Report

Hi,

Thank you for your contribution @David- it is greatly appreciated.

I followed the steps and I am got an error in the condition when I put the greater than, just re-read the document and realised my error was putting greater than instead of greater than or 1. Trail and error it's a beautiful thing.

It ran successfully however there was no result in the folder, would this work if input for the search is idfoldername e.g.(AA005 ABC)?

Was this reply helpful? Yes No
David- 1,254 on at

Like (1)

Report

The filter just searches for files with the extensions. I am sure you can probably search for folders, but I don't know what value you would use as it is not something I have needed yet.

Are you sure the file you are searching for exists? As long as you don't have anything in the "Limit Entries to Folder" it should search your entire document library. If you can take a screen shot of how you set up the condition and show the expression you used, I may be able to see something there.

Was this reply helpful? Yes No
jaanihsm 300 on at

Like (0)

Report

Hi @David-!

I tried your solution for a specific file that I need to search in my SP site. I entered a path to 'Limit Entries to Folder' and I changed the Condition, instead of 'is greater than or equal to', I used 'equal to'. The flow works if the file is not there but if it's there, the flow does not see it. What could be the issue? I must be missing something. Still new to Power Automate. Here is a screenshot of my flow. Thanks!

Was this reply helpful? Yes No