web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Manipulating Items wit...
Power Automate
Unanswered

Manipulating Items with Field Values Between Certain Dates

(0) ShareShare
ReportReport
Posted on by 23

Hi there. I have an existing flow that creates a list item for each form response. It's working just as I would like it to. My list is getting quite full, though, so I would like to "move" some items to a new list (by creating a flow that creates identical items on another list before deleting the items from the original list). One of the questions on the form requires users to select a date on the calendar, so I would like to move my items based on the value in that column in my list. I have decided that I want my existing list to be for the current fiscal year, and the new list will be an archive of items from the past fiscal year. In preparation for the new fiscal year, I am working on creating a manually triggered flow that will copy all of the items in the existing list that have a value greater than 6/30/2022 AND less than 7/1/2023 in the relevant column.

 

This function is apparently not as simple as I expected it to be. Below is a screenshot of the condition I set up.

Screenshot 2023-06-15 at 8.55.17 AM.png

 

Below is a screenshot of the error I am receiving ("Action 'Condition' failed").

Screenshot 2023-06-15 at 9.01.21 AM.png

I imagine this is relevant, so here is how the dates are displayed on my existing list.

Screenshot 2023-06-15 at 9.08.40 AM.png

Thank you in advance for the help.

Categories:
I have the same question (0)
  • SudeepGhatakNZ Profile Picture
    14,394 Most Valuable Professional on at

    Instead of providing date strings '6/30/2022' specify the following expression

    formatDatetime('6/30/2022','MM/dd/YYYY')

     

  • Michael291 Profile Picture
    23 on at

    Thank you for the reply, but this did not work.

     

    Here is what my Condition action looks like:

    Screenshot 2023-06-16 at 7.50.03 AM.png

    Here is the expression for the first row: 

    formatDateTime('6/30/2022','MM/dd/YYYY')
     
    Here is the expression for the second row:
    formatDateTime('7/1/2023','MM/dd/YYYY')
     
    I am still receiving the same error message that I shared in my initial post.
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 237 Super User 2026 Season 1

#2
David_MA Profile Picture

David_MA 173 Super User 2026 Season 1

#3
Kalathiya Profile Picture

Kalathiya 95 Super User 2026 Season 1

Last 30 days Overall leaderboard