Answered

Copy items based on a specific date

(1) Share

Report

Posted on by lauran86

Hi I am trying to copy items from one list to another but I only want to copy those which have a start date from the 1st of October onwards.

How do I specify this? I can only find solutions about grater than or equal to today but I want to specify "start date grater than October"

Thanks.

All responses (12)

Answers (1)

lauran86 28 on at

Like (1)

Report

Re: Copy items based on a specific date

Thank you so much @Sayan ! Got it!
Verified answer

Sayan 789 Super User 2025 Season 1 on at

Like (1)

Report

Re: Copy items based on a specific date

Hey @lauran86

Step 1 :
Delete Foreach.

Step 2:
Click on Advanced Options

Step 3:
Select Filter Query

Step 4:
Write this expression inside Filter Query

Where End Date is your column name and 'ge' means Greater than or Equal to.

Hope You Understand!

------------------------------------------------------------------------------------------------------------------------------
Thanks,
Sayan Patra
RPA Developer
lauran86 28 on at

Like (1)

Report

Re: Copy items based on a specific date

I don't understand, that is what I have been doing.
Sayan 789 Super User 2025 Season 1 on at

Like (1)

Report
Re: Copy items based on a specific date

Hey @lauran86

Write the Expression inside the "Filter Query" of Get Items no need of For Each.

End Date ge '2024-09-30'

Step 1:

Select Filter Query

Step 2:
Write the Expression inside Filter Query

Please Try this.

------------------------------------------------------------------------------------------------------------------------------
if my suggestion helps you, give it a Thumbs up and Mark as a solution. It motivates to solve more problems.
Thanks,
Sayan Patra
RPA Developer
lauran86 28 on at

Like (1)

Report

Re: Copy items based on a specific date

Hi @Sayan apologies, I ran out of time yesterday.
Here are the images, please not the date keeps defaulting to DD/MM/YYYY.
Sayan 789 Super User 2025 Season 1 on at

Like (1)

Report

Re: Copy items based on a specific date

Hey @lauran86 can you please provide the screenshot of the list and the snapshot of condition that you have written and what the error you are getting?

Thanks,
Sayan Patra
RPA Developer
lauran86 28 on at

Like (1)

Report

Re: Copy items based on a specific date

Thank you but is still not working.....
Sayan 789 Super User 2025 Season 1 on at

Like (1)

Report
Re: Copy items based on a specific date

Hey @lauran86

Please check the previous image you have written the Filter Query incorrectly.
Date ge '2024-09-30'
Date Format is "yyyy-MM-dd"

Date is the column Name.

------------------------------------------------------------------------------------------------------------------------------
If my suggestion helps you, please give it a Thumbs up 👍 and Mark it as a Solution ✔️ .
This motivates to solve more problems.
Thanks,
Sayan Patra
RPA Developer
lauran86 28 on at

Like (2)

Report

Re: Copy items based on a specific date

I just tried but it keeps failing. the dates in my list are displayed dd/mm/yyyy does it have to do with that?
Sayan 789 Super User 2025 Season 1 on at

Like (1)

Report

Re: Copy items based on a specific date

Hey @lauran86
If in your list if there is a column of Date and you want the specific Items which have "start date greater than October"
You can use ODATA filter Query

Date is the column Name.
To know more about ODATA filter query
check this : power-automate-odata-filter-query

This workflow only filters the Data :

------------------------------------------------------------------------------------------------------------------------------
If my suggestion helps you, please give it a Thumbs up 👍 and Mark it as a Solution ✔️. This motivates to solve more problems.
Thanks,
Sayan Patra
RPA Developer