Power Platform Community Forum Thread Details

Filing documents in similar name folders (efficiency)

I hope you can suggest an alternative approach for this problem, as what I have created is ridiculously inefficient.

I have a folder (in SharePoint) of files (Word documents) with employee names in the filename. I want to automate the placement of these files in their staff folder (also in SharePoint). Unfortunately, the folders may or may not match exactly the names in the document - for example, "Surname Firstname" or "Firstname Surname", and this list is managed by others.

The workflow I made gets the contents of the Staff Folder and filters the array for IsFolder?.
For each of these folders, an Apply to Each separates the Folder name into two strings (the first and last words)
Within this Apply to Each, each document filename is searched for both strings
If there is an AND match, some additional elements check if the correct SubFolder has been made and moves/copies the file to the correct SubFolder.
If there is no match, the flow ends.

There are probably too many loops within the Apply to Each's which are taking the time, but this takes hours and hours for 125 files.

Thanks for any alternative approaches.

Mike

Quick Links

Leaderboard