Unanswered

Automated Report on changed files in SharePoint

(0) Share

Report

Posted on by auxua

For a major project, we use a SharePoint folder, currently containing more than 70k files. I want to generate a report on a regular (e.g. daily) basis, listing the changed or created files in the last 24 hours.

First try was the "Get Files (properties)" action, but it only serves the top-level entries of the sharepoint folder, no files or subfolders (option nested is set to on). Second try was the use of SharePoint Rest-Call with Uri "_api/web/Lists/GetByTitle('General')/items", but I cannot find the correct title of the list of files (general or documents/general are not working). In both cases I need OData filter, but so far did not manage to create a syntactically correct filter.

So, how can I query the changed/created files of the last 24h in SharePoint?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Unknown geen idee 1,757 on at

Like (0)

Report

Dear A,

Not sure, but with the 'Get Files' action as you describe I seem to be able to pull all items, included nested items (folders in folders) in the Sharepoint. Maybe you should try again.

If that still fails, you should be able to retrieve the root items with the label 'IsFolder', which tells you what is a folder or not. When you add a 'Filter Array' and then 'Apply to each' you can loop through the folders with a 'Get Files' .... and so and so on ... All the results you save in a table called something like 'LastVersionMapping' which you can use to compare the most current version with and detail all the changes.

Either way, you should be able to complete your flow.
Happy flowing,
Koen

Was this reply helpful? Yes No
auxua 4 on at

Like (0)

Report

thank you for the reply!

This my configuration for the Get Files Action - still I get only the top level elements - is there missing something?

Was this reply helpful? Yes No
Unknown geen idee 1,757 on at

Like (0)

Report

Mmm, maybe try to remove the 'Limit Entries to Folder' and see what you get then (I seem to get all nested items then). You can then use a Filter Array on the output to only include items which path starts with the folders you need.

Was this reply helpful? Yes No
auxua 4 on at

Like (0)

Report

interesting - now I get all subfolders - but still no files 😅

Was this reply helpful? Yes No