Unanswered

Get file properties from multiple Sharepoint libraries into Excel

(0) Share

Report

Posted on by russellkoons

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?

All responses (2)

Answers (0)

russellkoons 40 on at

Like (0)

Report

Re: Get file properties from multiple Sharepoint libraries into Excel

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

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:

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 1,934 Super User 2025 Season 1 on at

Like (0)

Report

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