Auto delete files in SharePoint subfolders based file name

(0) Share

Report

Posted on by overhead_press2

I have a bunch of subfolders in SharePoint and I am wondering about how would I go about automatically deleting files within them if the folder name doesn't match the beginning part of the file name? For example in my screenshot, the sub folder name is "J0000-1002", so I would remove any file that doesn't start with "J0000-1002". The sub folders will have different names so this would need to be dynamic based on the sub folder name.

I was thinking of using the trigger "When a file is created or modified" but not sure how to apply it to multiple sub folders. Any help would be appreciated, thanks!

Categories:

Building flows

All responses (1)

Answers (0)

tom_riha 10,187 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hello @overhead_press2 ,

you can use the trigger 'When a file is created or modified'. For each document split the full document path to get the folder name (split by /, take the 2nd element from the end (length - 2, the last element is the file name)):

split(triggerOutputs()?['body/{FullPath}'],'/')[add(length(split(triggerOutputs()?['body/{FullPath}'],'/')),-2)]

then split the file name by _ and take the first element, everything before the first underscore:

first(split(triggerOutputs()?['body/{Name}'],'_'))

Once you have these 2 values, you can compare if they're equal. If not, delete the file.