Remove item from SharePoint if the item with date column is less than today

(0) Share

Report

Posted on by murtaza5

Below is my SharePoint list.

Screenshot 2024-03-19 151658.png

Below is my flow.

1. But when I run today (19th March 2024), the flow deleted both item with title A and B. Supposedly item with title A only. What did I do wrong?

2. Which one is better expression? My SharePoint local time is GMT+8.

Date lt '@{utcNow()}'

Date lt '@{addMinutes(utcNow(), 480)}'

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

v-yetonggu-msft on at

Like (1)

Report
Hi @murtaza5 ,

Please try this expression:

Date lt '@{utcNow('yyyy-MM-dd')}'

Because if you don't format the utcNow time format, he'll output like this:

A date string with a time.

However, if the SharePoint date column does not have a time format, it defaults to 0:00:00 on the current day.

3/19/2024 defaults to 2024-03-19T00:00:00.0000000Z, so item B will be deleted.

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
murtaza5 47 on at

Like (0)

Report

Hi @v-yetonggu-msft,

Do I need to change the Date column type to single text?

Regards,
Taza

Was this reply helpful? Yes No
v-yetonggu-msft on at

Like (0)

Report

Hi @murtaza5 ，

You don't need to, it's still in 'Date and Time' format.

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
murtaza5 47 on at

Like (0)

Report
Hi @v-yetonggu-msft, I need to use the expression below and it works. Thanks!

utcNow('MM-dd-yyyy')

Was this reply helpful? Yes No