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

Notifications

Announcements

Community site session details

Community site session details

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

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 538 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 405 Moderator

#3
abm abm Profile Picture

abm abm 252 Most Valuable Professional

Last 30 days Overall leaderboard