Answered

Flow to automatically delete SharePoint List items not deleting

(0) Share

Report

Posted on by TPayne_81

I'm a relative newcomer to using flows, though I've been using them more and more often over the last 12 months.

I have a SharePoint List that is populated from PowerApps, and I would like to set up a flow to delete items older than 7 days.

I've created a simple flow using one of the guides on here, which runs without issue, but it doesn't seem to actually retrieve any items to delete (even though there are several items older than 7 days in the list) - unless I change the filter to 'ge' but then it deletes everything.

(Note: Date format is day/month/year since I'm in Australia and the SharePoint site/list uses the same format.)

I've searched high and low for a solution, but I keep coming up empty so any help would be greatly appreciated.

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (1)

v-liwei-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @TPayne_81

The SharePoint date column time zone is the time zone in the site settings, while flow automatically adjusts the date column to the Utc time zone.

Best Regards,

Levi

Was this reply helpful? Yes No
Verified answer

TPayne_81 9 on at

Like (0)

Report
Copy link

Link copied!

So, after several hours of scratching my head, I finally managed to resolve the issue. Turns out it was operator error, and I had selected an old (and empty) test list which had a similar name to the one I was actually using.

Was this reply helpful? Yes No
v-liwei-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @TPayne_81

Glad to see you solved the problem.

You could mark your answer/solution as a 'Solution' to allow more people with the same problem to solve their own problem as quickly as possible.

Thank you so much!

Best Regards,

Levi

Was this reply helpful? Yes No