Answered

Delete Items Older than X Days from Sharepoint List Created From Microsoft Forms?

(0) Share

Report

Posted on by Whisky1

I am trying to create a Power Automate flow to remove data older than 21 days from a Sharepoint List created from Microsoft Forms.

I have created a COVID-19 contact tracing List using Power Automate and to comply with Data Protection I would like to delete data over 21 days.

I have a column named Date but don't know how to creat a simple work flow.

Can anyone help as this solution would help many users who have to collect details of visitors?

Many thanks.

Categories:

General topics

I have the same question (0)

All responses (8)

Answers (2)

Sort by

CU-18081211-6 9,272 Moderator on at

Like (4)

Report
Copy link

Link copied!

Hi @Whisky1 ,
Here is my proosal ...
Hope it helps !

Was this reply helpful? Yes No
Whisky1 13 on at

Like (0)

Report
Copy link

Link copied!

Hi @gabibalaban .

Thanks for your help which is getting me ever closer to my solution.

I'm getting a failure on:
I have checked the Date colums in my List which gets its information from a Microsoft Form from the Submission time.

Can you or anyone else see what the issue is? I read somewhere that dates and times should be converted to UTC which might be the issue.

Once again @gabibalaban many thanks.

Was this reply helpful? Yes No
Verified answer

CU-18081211-6 9,272 Moderator on at

Like (1)

Report
Copy link

Link copied!

@Whisky1
You missed lt (lowerThen) in the GetItems formula ... some please try: Date lt ...rest of formula.
Also, please take in consideration to use Created column (rather then Date column) of your sharepoint list (it's a Default column that store the datetime value when the item was created) .

Was this reply helpful? Yes No
Verified answer

Whisky1 13 on at

Like (0)

Report
Copy link

Link copied!

Hi @gabibalaban ,

Brilliant thanks. You sorted it no problem.

I now have it running daily to delete the information older than 21 days to comply with our GDPR.

Thanks a million.

Was this reply helpful? Yes No
Chris989 2 on at

Like (0)

Report
Copy link

Link copied!

Hey.

Hoping someone here may be able to help. I've got exactly this scenario and I've set up the flow as above - except I'm using delete file instead of delete item as it's not a SharePoint list but a document site.

If I trigger the flow as a test, it works as long as nothing is older than the date specified. The minute it actually has something to delete I get this error:

It's right, there isn't a file called 8, but this the ID of one of the files when you look at the output of get items.

I'm at a bit of a loss..

Was this reply helpful? Yes No
ncotela23 101 on at

Like (0)

Report
Copy link

Link copied!

Hi there - When I try this it keeps failing. Please see how I have it set up in image 1 below and the error in image 2 below. Any ideas?

Was this reply helpful? Yes No
renatopc84 44 on at

Like (0)

Report
Copy link

Link copied!

Hi ncotela23

I assume the problem has been already solved, but for documentation, in your "Filter Query" is missing an operator like lt, ge, gt, le. Example Created lt ...

Was this reply helpful? Yes No
Jste84 4 on at

Like (0)

Report
Copy link

Link copied!

Hi all, im looking to do something very similar but rather than delete a whole record from sharepoint. I only need to delete one field, does anyone know if this is possible?

Was this reply helpful? Yes No