Announcements
List has column = "Start time" (Type = Date and Time) - format = date only
using the template
"Delete SharePoint list items on a recurring basis based on a condition"
set recurrence to daily
pointed get items at list
What do I put in "Condition" to trigger the delete where Now()-21 > "Start time" ?
I tried:
@greater(utcNow('yyyyMMdd'), formatDateTime(adddays(items('Apply_to_each')?['Start_x0020_time']), 21), 'yyyyMMdd')
Many thanks
David (Nobby) Barnes
I'm having a similar issue.
I have a list for tracking staff absences. There are two separate date fields included, Date out and Date returning. I want the flow to delete any list item that has a date returning in the past.
I have tried the above solution and formulas without success.
First part (from what I can tell) is correct, although the get items step might need a filter query for the column?
Here is the apply to each:
Using the functions as above and the test fails every time. Any help is appreciated!
Hi @DavidBarnes :
Firstly, I guess you may have quoted the wrong field name (['Start_x0020_time']), I suggest you check the return value of ‘Get Items’ first.
Secondly, I’ve made a test for your reference:
1\My SP list
2\My flow
Formula1:
Share
Report
All responses (
Answers (
utcNow()Formula2:
adddays(items('Apply_to_each')?['Starttime'],21)3\The Result
Best Regards,
Bof
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
