Answered

Question: How to delete subfolders in a folder based on their contains files extension.

(0) Share

Report

Posted on by mevo

For Example:
I have folder z.
it contains 3 subfolders a,b, and c
each subfolder contains many files.
I want to delete any subfolder, not containing text files.
(let's say "a" contains text files. so "a" will stay but "b" and "c" don't so they will be deleted.)

Categories:

Power Automate Desktop

I have the same question (0)

All responses (5)

Answers (2)

Verified answer

ThomasFonn 273 on at

Like (1)

Report

First, use the action "Get subfolders in folder" where you specify your base folder.
Then use any loop, for example a "for each"-loop and iterate through all the subfolders
Inside that loop, you can use "Get files in folder" and use the file filter by *.txt.

The you can use an IF-condition and check if the files from the "Get files in folder" action count is = 0,
and then finally delete that folder

Was this reply helpful? Yes No
mevo 34 on at

Like (0)

Report

Hi, Thanks for the reply.
I did as you said. but still, it's not working. can please point me out what doing wrong? I'm totally new at PAD.
here is the Flow and screenshot too:
Folder.GetSubfolders Folder: FolderPath FolderFilter: $'''*''' IncludeSubfolders: False FailOnAccessDenied: True SortBy1: Folder.SortBy.NoSort SortDescending1: False SortBy2: Folder.SortBy.NoSort SortDescending2: False SortBy3: Folder.SortBy.NoSort SortDescending3: False Subfolders=> Subfolders
LOOP FOREACH Subfolder IN Subfolders
Folder.GetFiles Folder: Subfolder FileFilter: $'''*.txt''' IncludeSubfolders: True FailOnAccessDenied: True SortBy1: Folder.SortBy.NoSort SortDescending1: False SortBy2: Folder.SortBy.NoSort SortDescending2: False SortBy3: Folder.SortBy.NoSort SortDescending3: False Files=> Files
IF Files = 0 THEN
Folder.Delete Folder: Subfolder
END
END

Was this reply helpful? Yes No
Verified answer

Community Power Pla... on at

Like (1)

Report

Hi.
Try this in your IF condition:

IF Files.Count = 0 THEN
Folder.Delete Folder: Subfolder
END

Was this reply helpful? Yes No
mevo 34 on at

Like (0)

Report

It finally works!! thank you much.

Was this reply helpful? Yes No
mevo 34 on at

Like (0)

Report

Thank you so much. much appreciated.

Was this reply helpful? Yes No