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 : dH/ozlT8piS2cmCzPGibmC
Power Automate - Building Flows
Unanswered

Get file properties from multiple Sharepoint libraries into Excel

Like (0) ShareShare
ReportReport
Posted on 8 Mar 2023 13:34:50 by 40

I'm creating a flow that gets all the checked out files in several different Sharepoint libraries and adds the data into a spreadsheet. After the data has been added to the spreadsheet, the file will be emailed to the users who have files checked out to remind them to check in their files.

 

There are almost 100 different libraries, so I created an array with all of the site URLs, then used an Apply to Each to iterate through the array and get file properties for each site, but when I try to iterate through the list I get back from Sharepoint to add to the Excel file, the dynamic content does not appear.

 

I found a thread from a couple years ago from another user with a similar issue, but no answer. Could someone help me here?

 

checkoutflowissue.png

I have the same question (0)
  • russellkoons Profile Picture
    40 on 08 Mar 2023 at 16:41:17
    Re: Get file properties from multiple Sharepoint libraries into Excel

    @annetoal Sorry I forgot to expand the Get files step to show my filter

    russellkoons_0-1678292595229.png

     

    What you suggested works fine if running a Get files step with a set URL and not a URL pulled from an array variable, as seen here:

     

    russellkoons_1-1678293545492.png

     

    However if at all possible I would like to avoid having to create a single step for every single library, which is why I'm trying to use the array with all of the URLs. There's about 90 in total and that would be a real pain.

     

  • annetoal Profile Picture
    1,934 Moderator on 08 Mar 2023 at 15:45:06
    Re: Get file properties from multiple Sharepoint libraries into Excel

    I'm confused about what data you're adding to the row in Table1.

    Filter the output of the Get files (properties only) on outputs('Get_files_(properties_only)')?['body/{IsCheckedOut}']. Select the fields from the filtered output.

    Make an array for using Apply to each to insert the rows into your Table1. 

     

    Thanks,

    Anne

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…

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 986 Moderator

#2
stampcoin Profile Picture

stampcoin 699 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 577 Super User 2025 Season 2

Loading started
Loading complete