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.

Categories:

Building flows

I have the same question (0)

All responses (12)

Answers (1)

Sort by

Sayan 818 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hey @lauran86
can you please share the workflow ?

Was this reply helpful? Yes No
lauran86 28 on at

Like (1)

Report
Copy link

Link copied!

Here you go, thanks!

Was this reply helpful? Yes No
Sayan 818 Moderator on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
lauran86 28 on at

Like (2)

Report
Copy link

Link copied!

I just tried but it keeps failing. the dates in my list are displayed dd/mm/yyyy does it have to do with that?

Was this reply helpful? Yes No
Sayan 818 Moderator on at

Like (1)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
lauran86 28 on at

Like (1)

Report
Copy link

Link copied!

Thank you but is still not working.....

Was this reply helpful? Yes No
Sayan 818 Moderator on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
lauran86 28 on at

Like (1)

Report
Copy link

Link copied!

Hi @Sayan apologies, I ran out of time yesterday.
Here are the images, please not the date keeps defaulting to DD/MM/YYYY.

Was this reply helpful? Yes No
Sayan 818 Moderator on at

Like (1)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
lauran86 28 on at

Like (1)

Report
Copy link

Link copied!

I don't understand, that is what I have been doing.

Was this reply helpful? Yes No