Limit the number of files in a sharepoint folder

(1) Share

Report

Posted on by AS-09100553-0

HI everyone
I want to create a flow to export a snapshot data from power bi to sharepoint. I have created the flow to export data and create a new file everytime the flow runs. But I want to limit the number of files to 15. so whenever the count crosses 15, I want to delete the oldest file automatically. How to set up the flow?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

David_MA 12,982 Super User 2025 Season 2 on at

Like (0)

Report

I think a flow such as this can do what you want:

The expression in the condition is length(outputs('List_folder')?['body']), which is the number of files returned from the list folder action. Point the list folder action to your site and the exact folder where you want to limit the number of files. I only had nine files in this folder, so for demo purposes I used 8 in the condition, but you would use 15.

For the Get files (properties only) action you need to set some parameters:

Be sure to sort by Created asc (ascending) so the oldest files are listed first. Then limit the count to how many files exceed your limit by using this expression: sub(int(length(outputs('List_folder')?['body'])), 8). You would change 8 to 15.

I think the rest is self-explanatory. The Compose File Returned action I just put both expressions in there to make sure my expressions were correct:

Was this reply helpful? Yes No
AS-09100553-0 4 on at

Like (0)

Report

What will be the expression for delete action?

Was this reply helpful? Yes No