Unanswered

Convert list to folder variable?

(0) Share

Report

Posted on by oqopo

hi, I need to copy a bunch of folders that contains specific name from a network folder to my desktop.

I first tried to use Get subfolders in folder but it is taking really long since the network folder is huge. So I created a power query to get a list of the folder path that I need and saved in excel, then I read that excel file in power automate to get ExcelData that has a list of the folder path that I need to copy to my desktop.

Then when I use Copy folder and use %ExcelData[0]% as my folder path, I get an error that says "Argument 'Path" must be 'Folder"... I checked and ExcelData contains the exact path that I need to copy and if I just type that into Folder Path it ran fine.

Any idea why I am getting this error or how do I convert %ExcelData[i]% to a Folder type variable?

Categories:

Power Automate Desktop

All responses (4)

Answers (0)

Sort by

ryule 929 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Not sure, but have you tried setting a new variable that contains %ExcelData[i]%, and then verify the value in there is what you are expecting, and then using that variable in the Copy Folder action?
Rahul7 63 on at

Like
a
(0)

Report
Copy link

Link copied!

Could you please share your PAD workflow?
VJR 7,635 on at

Like
a
(0)

Report
Copy link

Link copied!

Use a Display Message Box to verify what the %ExcelData[0]% shows.

It may have something additional/or something missing to it which does not qualify as a folder path.

Also check with the CurrentItem
oqopo 2 on at

Like
a
(0)

Report
Copy link

Link copied!

I checked the excellist variable and wrote the list back to excel to confirm they are correct. In fact I copied the text I wrote back to excel and used that as the folder path and PAD didn't complain