Auto Removal of files in Sharepoint Online
I have a SharePoint Online Site. In its Document I've multiple folders , sub folders and files of different types.
The thing is that I need to somehow delete all the files(only) under each and every folders or subfolders which are Created on or before year 2022.
It should not affect the present folder structures. So is there any possible way to do it ? I found something like, using Power Automate in Sharepoint will solve this problem, but I'm not an expert in that field.
Can anyone please help me out ?
Solution
This flow should work:
Get files (properties only).
- Set Include Nested Items to "Yes"
- Set Filter Query field to Created le '2022-12-31'
Condition in Apply to each.
- Check if IsFolder is equals to false
If yes, Delete file
- File Identifier: Identifier (from the Get files (properties only) action)
If no, do nothing
Example flow below:
- why 'PrimitiveValue' or 'StartObject' node was expected error
- Upload file to SharePoint using REST API
- Best way to resolve file path too long exception
- Optimal/preferred way to call 'SP.ClientContext.executeQueryAsync' in SharePoint
- Trouble/How to get the Document Library of my SharePoint Site using GRAPH API
- Sign in as different user in SharePoint 2013
- obtain item-id for microsoft graph api
- Power apps - Multiple Sharepoint lists combine as collection and display in one gallery
- SharePoint REST API getFolderByServerRelativeUrl Returns Nothing
- System.IdentityModel.Tokens.Jwt not found
- Microsoft Graph API and SharePoint files permissions
- How to programmatically download a file from a synced SharePoint directory in Windows?
- Using R to connect to a sharepoint list
- Sharepoint permissions to folders using powershell pnp
- Add additional site page library to SharePoint
- Attaching files from SharePoint uses %20 for spaces in filenames
- Accessing SharePoint Files via API Results in 'AudienceUriValidationFailedException'
- Granting permissions to upload a file to sharepoint using PnP Powershell - 401 Unauthorized
- I can't get the folders from my sharepoint site, how can i resolve this?
- How can I detect if a document is successfully rendered in Office Online Server using PowerShell?
- How to upload files from Jenkins to SharePoint: REST API or OneDrive sync?
- Unable to authenticate SharePoint REST or CSOM calls from .NET Core
- How to setup a connection to Sharepoint with enterprise app and client secret
- Power Automate Send an HTTP request to SharePoint returns BadGateway error when creating a Lookup field
- Word file from SharePoint corrupted when sent via Outlook
- Copy “latest files” from source to Sharepoint using KNIME
- Why does SharePoint JavaScript define a function named “ULSTYE” and a label for an empty statement with the same name?
- File upload to SharePoint is not working and is not throwing any errors
- Loading ETag property when retrieve items as a stream in SharePoint
- How to subscribe to updates to the root drive of a SharePoint Site using Microsoft Graph