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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Extract sub folder inf...
Power Automate
Answered

Extract sub folder information from a document list

(0) ShareShare
ReportReport
Posted on by 89
Get all the items from a list in a SubFolder

Hello I have a library in a sharepoint where has been added more columns than the ones use for default. As you can imagine have another folders with documents inside of each folders. 

 

crirojsab_0-1642518045234.png

 

The Job that I'm creating needs to identify if in the main folder has bee added something new in the columns ; for example in the column status  that is more at the right; and then trigger the process. Until there all good. What the process do  is go inside the folder with and extract all the information in there. 

crirojsab_1-1642518045314.png

 

 

For one list like the one previous showed, I'll defetively use the function get items. But as you know get items can't be used to extract that informtion from a subfolder. I tried List folder option but I only get the list of the files; no more related information of the rest of the columns there. I also tried used an HTTP Request with the next uri:   /_api/web/Lists/GetByTitle('Internal Policies')/Items?$expand=Folder&$select=Title,FileLeafRef,Folder/ServerRelativeUrl . but again only get information related with the files. Now the question is how can I get the rest of the information listed in the columns in an specific subfolder just how you normally do it using the funtion get items?  I need these information because more at the right each file has listed sharepoint group names that I need to notify the users. 

 

Thanks for any help that you can provide

Categories:
I have the same question (0)
  • Verified answer
    crirojsab Profile Picture
    89 on at

    At the end went able to solved the problem. Now I have another issue but at least went able to reach the data from the subfolder without the used of Get Items method. Below an extract of the steps

     

    crirojsab_0-1642615572631.png

     

     

     

    Is important to mention that with the used of one select option went able to extract the data required from the compose and to the reach the data that I was looking for. 

     

    Hope this helps to anyone else having this issue

     

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 557

#2
Valantis Profile Picture

Valantis 328

#3
David_MA Profile Picture

David_MA 264 Super User 2026 Season 1

Last 30 days Overall leaderboard