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

[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.

[gabibalaban]

Hi @Whisky1 ,

Here is my proosal ...

Hope it helps !

[Whisky1]

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.

[gabibalaban · Accepted solution]

@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)  .

[Whisky1 · Accepted solution]

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.