Trying to find existing folders

[alopez222]

To begin, I have two different excel spreadsheets, one used to make folders and the other used to upload into the newly created folders. The spreadsheet used to create the folders is named CFGSchedule and I am creating folders based upon the values in a column within the spreadsheet. The name for these folders are also those values. Once these folders are created I upload the second spreadsheet, Lineup Template, inside the new folders. 

The issue is that I want to create folders only when there isn't an already existing folder. I am trying to implement the idea from the link below but it seems like I can't do it with an 'Apply to Each' action. What should I do? Also, I am completely new to this.

https://mydevexperience.wordpress.com/2020/02/08/power-automate-how-to-find-a-folder-exists-dynamic-...

Thanks for any help given.

[jinivthakkar]

@alopez222 you cannot initialize a variable in the loop but you can use it in the loop, just move that action out of the loop and try again it should work.

Even the link you are referring has not initialized a variable in the loop so not sure why and how you did that 

--------------------------------------------------------------------------------

If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

[alopez222]

From what I understand, the variable that produces the error is checking the folder name. In my case the folder name is equal to the varying values of the Project column in the excel spreadsheet. The name of the folders will be the values seen in the picture below. But one of the issues I have is that there are some repeating values which is why I am trying to create something that will prevent creating duplicate folders. Having said that, from what I understand, in the link they are setting the variable to a folder name already. How can I do this when I want to check different folder names?

[jinivthakkar · Accepted solution]

@alopez222 you just have to initialize a variable outside the loop and then set variable in the loop

[alopez222]

I'm completely new to this but I think I did what you suggested. I tested it and got this. It says the flow ran successfully.

Your suggestion:

Result: