web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate delete SharePoint list...

Power Automate

Unanswered

delete SharePoint list item based on date in list field

(0) Share

Report

Report

Posted on by DavidBarnes

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

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

v-bofeng-msft on at

Like (0)

Report
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:

utcNow()

Formula2:

adddays(items('Apply_to_each')?['Starttime'],21)

3\The Result

Best Regards,

Bof

Was this reply helpful? Yes No
ganno054 2 on at

Like (0)

Report

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!

Was this reply helpful? Yes No

Join the conversation