Unanswered

List Files in Folder in Excel

(0) Share

Report

Posted on by Community Power Pla...

Hello,

I'm trying to make a flow that will look at a folder and list all on those files into an Excel sheet. My flow does this but I would like it to show the file name not the file path. I am trying a 'For Each' but am receiving an error. How can I make this work?

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (0)

VJR 7,635 on at

Like (0)

Report

Hi @Anonymous

Hope you are using the CurrentItem in the Get file path part.

If still not working please share a screenshot of this action.

From the list of toggle buttons shown above enable/disable based on your requirements.

Was this reply helpful? Yes No
MichaelAnnis 5,727 Moderator on at

Like (1)

Report

If you really want to use for each, then open excel and just write %CurrentItem.Name% or %CurrentItem.NameWithoutExtension% directly to the cells. For instance, if you are putting them in column A…

set variable index=2 (assuming starting row 2)

launch excel

for each

Write to excel in column A and row %index%
set variable %index% to %index+1%
end for each

however, there is a much faster way to do this.

Run CMD for the folder you used in Get Files

write to cmd: dir /b | clip ‘this copies all filenames in the current directory to the clipboard.
Launch excel

activate the proper cell

paste from clipboard

’should be done

Was this reply helpful? Yes No