How to create a flow to delete files in SharePoint

(0) Share

Report

Posted on by Baptiste_k97

Hello,

I'm looking to create a flow which would automatically delete files from a folder in a SharePoint library.

I would like to delete all files older than 7 days that are in a specific folder in my library with this rule.

Could you guide me through creating this flow?

Thanks. Baptiste.

Categories:

Using connectors

All responses (15)

Answers (0)

Sort by

Mira Ghaly 11,415 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@Baptiste_k97

Please follow below steps :

1. you need a scheduled recurring flow to run daily

2. Use Get Past time to get the time in the past by 7 days

3. Use the Get Files Action to get the files you want to delete from the folder

4. Expression on Filter Query Right hand side

formatDateTime(body('Get_past_time'),'yyy-MM-dd')

Note: Do not forget single quotes between the format expression

5. Apply to Each and Delete files
Baptiste_k97 21 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello,
Thanks for your help. I'm having a problem in step 3 that makes my flux unusable.
How do I write the expression "Created It" before the filter query ?
 
<img src="https://nsa40.casimages.com/img/2021/05/15/210515060151323418.png" border="0" alt="" />
 
I tried to write it by hand, but I get the error below when I run the stream.
<li-code lang="markup">L'expression « Created It '2021-05-14' » n'est pas valide. Creating query failed.
clientRequestId: 7dd9422a-1f96-48ad-9d39-a73d6e315f4a
serviceRequestId: 7dd9422a-1f96-48ad-9d39-a73d6e315f4a</li-code>
 
<img src="https://nsa40.casimages.com/img/2021/05/15/210515060009285867.png" border="0" alt="" />
 
Thank you in advance for your reply.
Regards. Baptiste
Mira Ghaly 11,415 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@Baptiste_k97

Is your column name in french in sharepoint?

Can you please add screenshot of your flow?
Baptiste_k97 21 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes @Mira_Ghaly my column name is in French in SharePoint.

My flow :
Mira Ghaly 11,415 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@Baptiste_k97

Can you use the French name in place of Created?
Baptiste_k97 21 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello,
I tried with the French name of my column but the result remains the same.

Here is the column in question:

Details of the error :
Mira Ghaly 11,415 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@Baptiste_k97

it is missing the Cree lt 'format...'
Baptiste_k97 21 on at

Like
a
(0)

Report
Copy link

Link copied!
@Mira_GhalyI still have the same error.
In "Filter query" I put the following expression :

Cree it 'format...'
formatDateTime(body('Obtenir_l''heure_passée'),'yyy-MM-dd')
Mira Ghaly 11,415 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@Baptiste_k97

Please use

Fieldnameinfrench lt

lt for less than
Baptiste_k97 21 on at

Like
a
(0)

Report
Copy link

Link copied!
Hello @Mira_Ghaly
I tried all the possibilities with the french name of my SharePoint column :
Créé + it + '...'
Modifié + it + '...'
Créé + '...'
Modifié + '...'

I still have this same error telling me that the "query filter" is invalid.