Power Automate

wildcard entries in sharepoint getfiles

(0) Share

Report

Posted on by GeekAlf_Pro

404

Hello,

i want create a PA that delete files older than 6 months.

i created the flow so far so good.

My question is wildcards are they allowed in the limit entries to folder?

Because, i have a tree structure like this

1- documents/name1/file.doc

2- documents/name1/Archives/file.doc

3- documents/file.doc

4- documents/name2/file.doc

5- documents/name2/Archives/file.doc

6- documents/nameN/file.doc

7- documents/nameN/Archives/file.doc

8- documents/nameN/Archives/file2.doc

and i only want to delete files in points {2,5,7,8}

Thanks

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

Kalathiya 2,456 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hello @GeekAlf_Pro,

I reviewed your requirement and I see that the archived files are spread across different document folders. So we can’t directly apply a filter in the “Get files” action.

Instead, you can handle this inside an Apply to each loop. Just add a condition to check if the file path contains “Archive”. If that condition is true, then you can proceed to delete the file.

Also, I would suggest adding one more filter for the file type: FSObjType eq 0. This will ensure that only files are returned. (This you need apply in get files action beside the created date filter).

FSObjType eq 0

Right now, with your current filter, it may also bring folder entries along with files. So by applying this condition, you’ll properly restrict the output to files only.

---------------------------------------------------------------------------

Glad it helped 🙂
If this fixed your issue, please click “Does this answer your question?” to mark it as verified so others can find the solution easily.
A Like 👍 is always appreciated, and I’m around if you need more help @Kalathiya

Was this reply helpful? Yes No
Suggested answer

Tomac 4,153 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @GeekAlf_Pro

While @Kalathiya's point is an important one (it will prevent the action from returning folders as well as files), to answer your question directly the option "Include Nested Items" will go through all contained folders when set to yes. If you don't want it to recursively go through all lower folders, set that option to No.

Was this reply helpful? Yes No
Suggested answer

David_MA 14,956 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
To me, the simplest thing to do would be to configure the get files action to limit it to one of the folders that applies:

2- documents/name1/Archives/file.doc

5- documents/name2/Archives/file.doc

7- documents/nameN/Archives/file.doc

8- documents/nameN/Archives/file2.doc

Then just duplicate the steps for the other three folders. Or you could set the workflow up to process one folder and get it working. Once it is working, do a save as on the workflow and adjust it for the next applicable folder so that you have four workflows; one for each folder.

Note, if you don't want the flow to process any subfolders under the Archives folder level, be sure to set include nested items to no.

Was this reply helpful? Yes No
GeekAlf_Pro 404 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello,

Thanks for your responses, i will test

Have a good day

Was this reply helpful? Yes No