Power Platform Community Forum Thread Details

I have been working on a way to automate a task but I need some help since I am having issues with the flow.

I have a folder with over 200K attachments and I am trying to move the files into different folders based on an Excel file. Due to the quantity of files my thoughts are to do each movement of files as a separate flow.

The steps I am doing are:

Launch Excel

Variable Produced = ExcelInstance

Read from Excel worksheet.

Retrieve = Values from a range of cells
Start Column = A
Start row = 2
End Column = A
End row = 46552
Variable Produced = ExcelData
In Flow Variables the File Names of all files are listed

Get files in Folder

File Filter = *.pdf
Variable Produced = FilesList
In Flow Variables the full File Path of all files are listed

For each CurrentItem in FilesList

Value to iterate = %FilesList%
Variable Produced = CurrentItem
In Flow Variables only the 1 item is listed. The flow did go iterate through the For each loop.

5. If CurrentItem in FilesList then

First operand = %CurrentItem%
Operator = Equal to
Second operand = %ExcelData%

6. Move Files

File(s) to move: %FilesList%
If file exists = Do nothing
Variable Produced = Moved Files
In Flow Variables it is blank.

Categories:

Power Automate Desktop

Can you specify what exactly are the issues with the flow? Where do you need help?

The step 5 might be set up incorrectly:

5. If CurrentItem in FilesList then

First operand = %CurrentItem%
Operator = Equal to
Second operand = %ExcelData%

You are checking if currently iterated loop item so one row is the same as the full ExcelData -table. That will never be true.
You should instead check if %ExcelData% contains the %CurrentItem% filename. So if you excel has the filenames listed without extension then fix it like this:
First operand = %ExcelData%
Operator = Contains
Second operand = %CurrentItem.NameWithoutExtension%

Or if it has the filenames contain the extenstion (.pdf) then use %CurrentItem.Name%