web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

List Folder Action with Dynamic content

(0) ShareShare
ReportReport
Posted on by

Hi everyone,

 

I'm new to Microsoft Flow but have some coding background.

 

So the way I have my sharepoint structured is that within a folder (Project A) i have multiple folders of sub-projects (Project 1). So withing folder Project A I would have 3 folders: Project 1; Project 2; Project 3. In the future more will be added, so the process has to be dynamic in a way that it needs to identify how many sub-foulders there are and what names they are.

 

Each of these three must have a number of files, which I name in the same structure: Filename_Project #

 

The flow I'm building must open folder Project A, then check the within this, how many folders there are and get the names, then open these sub folders and check if there is a file named Filename_Project #

 

The problem I'm having is with the List Folder Action. It does not allow me to load the paths of the folders previously found, nor create variables with folder names, etc. Is there any way possible to overcome this issue?

 

DiogoSCamacho_0-1593008795311.png

From the picture, I'm having problem on "List Folder 2". I have tried using path as shown, I have tried using the variable I created "Folder Path". Nothing seems to work. The error I get is that its not on a Json format, and that the folder is not available, but I know for a fact it is.

 

On the flow testing it shows that it correctly reads the path, it just doesn't load it.

 

I have the same question (0)
  • fchopo Profile Picture
    8,001 Moderator on at
    Re: List Folder Action with Dynamic content

    Hello @Anonymous 

    If you only want to check if a file exists in a folder, you can search for it using an OData expression and look at its properties. Have a look at this example:

    2020-06-24 18_40_28-Window.png

     

    1) Get File properties of all the files in the Documents document library where FileName (FileLeafRef) is "Filenmae_Project#".

    2) If there is any element in the query results

    3) Select FileName and Path fields.

     

    Hope it helps!

    Ferran

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 666 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 382 Moderator

#3
developerAJ Profile Picture

developerAJ 254

Last 30 days Overall leaderboard