Loop through Excel files in a folder

Hi,

I think this is rather easy but I can’t manage to create this steps. I want to repeat the same activities for more Excel files in a Folder (or rather in different subfolders).
I tried it with “For each file in folder” but if I add a Use Excel File activity in there I do not have the possibility to chose them.

@lena1 … if you want to pick the files from sub folders then you have to choose “include sub folder” in the for each.

2 Likes

add For each file in folder activity, choose include sub-folders then from inside it on the + you will have a common scenario named try open file as excel and then add the flow inside the added activities

1 Like

Thanks, I couldn’t find the try open file as excel activity first.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.