cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bryanc78
Level: Powered On

Scheduled flow to move an item from one SP list to another SP list - not following my condition

So I have a SP list that is getting too large to manage so I'm wanting to move older items off of it and onto an "archive" list.  My flow is set up as follows:

 

Recurrence - 11PM every night

Get Items -  items from the main SP list

Apply to each - value

Condition - when my date column is less than or equal to utcNow().  This date column is set to show a date that is 6 months after the SP item was created.  So, if the item was created on 1/1/2019, then this column will show 7/1/2019 and thus, the condition is true to be moved (If Yes) If this date is say 12/1/2019, then it should not be moved as it does not meet the condition.  Now, I do not have a If No condition.

Create Item - create item in the archive SP list

Delete Item - delete item from main list

 

My problem I'm having is all items are being impacted, even items that do not meet the condition

2019-10-04_10-01-16.png

 

 

 

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Super User
Super User

Re: Scheduled flow to move an item from one SP list to another SP list - not following my condition

Hi @bryanc78 

 

Try using the formatDateTime expression for both conditions to same format and compare

 

formatDateTime(utcnow(), 'yyyy-MM-dd')

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

 

Thanks

 

 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!



View solution in original post

Super User
Super User

Re: Scheduled flow to move an item from one SP list to another SP list - not following my condition

Hi @bryanc78 

 

Get items will return only 100 items if you left the Top count field blank. See this post

 

https://powerusers.microsoft.com/t5/General-Flow-Discussion/SharePoint-Get-Items-Maximum-Row-Limit/t...

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!



View solution in original post

3 REPLIES 3
Highlighted
Super User
Super User

Re: Scheduled flow to move an item from one SP list to another SP list - not following my condition

Hi @bryanc78 

 

Try using the formatDateTime expression for both conditions to same format and compare

 

formatDateTime(utcnow(), 'yyyy-MM-dd')

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

 

Thanks

 

 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!



View solution in original post

bryanc78
Level: Powered On

Re: Scheduled flow to move an item from one SP list to another SP list - not following my condition

So, while that worked and is moving items.  My flow has cycled through multiple times in the last 2 hours and has not picked up any new items even though I have a ton still to get through.  Is the flow just going thorugh 100 at a time and just happened to not find any that matched the condition?

 

1.PNG2.png

Super User
Super User

Re: Scheduled flow to move an item from one SP list to another SP list - not following my condition

Hi @bryanc78 

 

Get items will return only 100 items if you left the Top count field blank. See this post

 

https://powerusers.microsoft.com/t5/General-Flow-Discussion/SharePoint-Get-Items-Maximum-Row-Limit/t...

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!



View solution in original post

Helpful resources

Announcements
firstImage

New Ranks and Rank Icons in April

Read the announcement for more information!

firstImage

Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (8,586)