Delete SharePoint Excel Files after 7 days

[ma_91]

Hey guys, quick question.

I'm trying to set up a flow which deletes only Excel files from a folder, but shouldn't delete specific file.

All files are ".xlsx" files and the one who shouldn't be touched is named "Template.xlsx" all the other ".xlsx" files can be deleted.

This is what I came up with so far, but I don't have any clue how I should continue:

It is important that the Flow doesn't delete the "Template.xlsx" file, but any other ".xlsx" file.

Thanks in advance for your help guys!

[abm]

Hi @ma_91 

Please follow the below steps:

[ma_91]

hey @abm

thank you so much for your help.

your flow is indeed working, but it deletes any other file aswell. It should only delete ".xlsx" files.

[abm]

Hi @ma_91 

I was only following your orders. This is what you mentioned earlier 🙂

All files are ".xlsx" files and the one who shouldn't be touched is named "Template.xlsx" all the other ".xlsx" files can be deleted.

[ma_91]

Hey @abm 

sorry, that was my fault.

How do I configure it to only delete ".xlsx" files not everything else?

[abm · Accepted solution]

Hi @ma_91 

Here it is

Under the apply to each loop add a compose action to find the extension of the file. The expression I used is as follows:

last(split(items('Apply_to_each')?['Name'],'.'))

[ma_91]

hey @abm,

thank you so much! I really appreciate it!

It worked 🙂 

Thanks for your help!