Power Automate - How to filter SharePoint Folders and SubFolders & Delete Files?

This video explains how to filter SharePoint folders and subfolders & delete specified file only.

Expression I used in this video:

Compose 2 (Inside the Apply to each loop)

This video is based on a community question. Please see below.

A special thanks to below video @MarkusSchiller

[fundivine]

You just earned a new follower today, this Particular problem has haunted me for hrs, using this i can also get a files link and display it on web through my power appps, i can trigger a delete action for tiles through power apps . thank you so much

[shathike]

Thanks for good informatic video, When a file is deleted approval workflow is required whether approve / reject

[chipile]

This is awesome! Many thanks! Do you have something to copy files to another SharePoint library whose names match certain expression (not equal, but contains)? Thanks again for your wonderful content!

[Ron_]

Thanks for the informative video, I want to create a flow which can be triggered using files placed inside a specific subfolder called "Translation Docs" inside our sharepoint library and it should pick that file [Take user input for "Target language"] and open another utility i.e. Document translation (this utility is created inside our organization sharepoint) and navigate to that to put that selected file as input and generate the output. also place the output file in a specific output folder inside the same library. If you could help me with the first part i.e. getting the files from sharepoint and navigating to some other url in sharepoint that would also be very helpful. Thanks!

[bc]

Thank you for sharing. Throughout the hierarchy, I have 2 sub-folders with the same name. How would I modify this Flow to delete all the files in only one of the sub-folders?

[chandramohan]

Thanks for the video, my question is similar. I would like to know the main folder name when the file is submitted in a nested subfolder. If i ask in this video, is there a way to get ITA001/002/003 when file submitted in Price List folder?

[IAmSreejith]

Hi, a totally unrealted question. I have a requirement wherein I need to track the refresh of dataflows in a Power BI workspace(s) . I know I can do this using the APIs, but due to the organizational limitations, I can't use it. So the next solution I could think of is to use the Power Automate to do this. I have already created a few flows that do this perfectly, individually. But it is not an intuitive process. Lets say I have 20 dataflows ( and ever growing), then I need to create 20 different flows to track the status of these dataflows.Rather I would like to have this done dynamically in a single flow itself. Is there a method by which I can parameterize the Dataflow name in "When a dataflow refresh completes" trigger ?
Another method I am pursuing, but failing :(, is - Schedule the flow to run at a pre-set time > Keep the list of dataflows in an Excel ( dynamically) > List rows present in this excel table > Apply to each .
Inside Apply to each --> "When a dataflow refresh completes" > use the current row as the dataflowName
And finally, update a row in Power BI dataset ( streaming ) .
But this method is failing with "The backend request failed with error code '404'" .
So, is this even possible ?
Appreciate if you could reply . Thank you

[markyaney]

I am looking for a flow similar to this. What I have happening currently is a flow that populates a MS Word doc from an MS Forms entry. My flow then copies the word doc and converts it to a pdf file. Once the flow is complete I have both the .docx file and the .pdf file in the SharePoint folder. I have been unsuccessful adding a step to delete the .docx file within the flow. What I am trying to create now is a flow that will go into the sub folder once per month and delete all the .docx files except for my template. All the created .docx files end with "-VIF.docx". Is there a way to create a flow that will filter the array in the folder and delete all files that contain "-VIF.docx"?

[jamillelopes]

How does it work for a folder that contains a large amount of subfolders, like 1500 (and is constantly adding more of them)?

[raymchin]

Hi, how to delete multiple files with monthly extensions, let's say xxx_Jan, xxx_Feb etc in mutiple folders in sharepoint. The second folder may contain files names yyy_Jan, yyy_Feb etc., and the third folder will contain files names zzz_Jan, zzz_Feb etc., so on and so forth.

Is it possible to loop and delete all files using one power automate?

Thank you kindly.

[rankas]

Hi, Please explain to me how to auto-delete only ZIP files in SharePoint documents.

[LockeStreetEats]

Hello, this is beautiful! Would you be able to show us how to copy a document to the subfolders?

[sahil.rajput]

Hey abm, can you make a video on how to change the delimiter of a csv file in power automate web. For ex : ", " to "|". I tried to search alot on google and youtube can't find any suitable answers. Can you please help us.

[manjunathak]

Can you please do video how to get size of file attached in powerapps app in power automate or in powerapps

[senthamilankrishnan]

Hai abm,

I have a excel file in SharePoint documents library i want to delete a excel sheet. I had tried your steps but I got some error please tell me whether it will work for SharePoint or one drive

[eduardoalmeida]

I cant do this. My flow says it was run ok, but the files on path folder still there. It is already makes me mad.