SharePoint Date filter query

(0) Share

Report

Posted on by jaina

517

Dear Experts,

Kinldy help how am I able to copy items from sharepoint list to another with specific year created (using the column Created).
The objective is to archive old items into another SP list, let say, the items that were from 2022.

Currently the trigger i used is the Manually trigger a flow.

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (0)

v-yetonggu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @jaina ,

Please add this expression to the 'Filter Query' of 'Get items'.

Created lt '2023-01-01T00:00:00Z' and Created gt '2022-01-01T00:00:00Z'

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
jaina 517 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-yetonggu-msft , thanks for your response.I tried your suggestion however, the workflow did not capture any items.

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

Like (0)

Report
Copy link

Link copied!

Hi @jaina ，

Please check the 'Created' column in your SharePoint list to see if there are any items created in 2022.

I use this method to get the data:

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No