I put together a Flow that identifies a folder named "COPAS 2020".
Inside of COPAS 2020, I have dept folders: Accounting, Compliance & Risk Management, etc. In total, there are 7 sub-folders inside of COPAS 2020 and each folder has separate employee folders. Each employee folder has a Power BI 2020.xlsx file I'm trying to get to.
The file structure looks like this:
COPAS 2020 ---
|
--- Accounting ---
|
--- Mike Johnson
--- Power BI 2020.xlsx
--- Terry Crews
--- Power BI 2020.xlsx
--- Jimbo Scrimp
--- Power BI 2020.xlsx
--- Compliance & Risk Management ---
|
--- Mike Johnson
--- Power BI 2020.xlsx
--- Terry Crews
--- Power BI 2020.xlsx
--- Jimbo Scrimp
--- Power BI 2020.xlsx
I'm able to iterate through through COPAS 2020 with an Apply to each on the path to that the COPAS 2020 folder. From there, I collect the names of the dept folders. My problem is iterating through the dept. folders, and then creating another Apply to each loop to iterate through each employee name in the dept folders to get to the Power BI 2020.xlsx file.
Here's the Flow I built so far:


Report
All responses (
Answers (