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
Solved! Go to Solution.
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
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogPower Automate Video TutorialsHi @bryanc78
Get items will return only 100 items if you left the Top count field blank. See this post
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
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogPower Automate Video TutorialsHi @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
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogPower Automate Video TutorialsSo, 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?
Hi @bryanc78
Get items will return only 100 items if you left the Top count field blank. See this post
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
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogPower Automate Video TutorialsUser | Count |
---|---|
78 | |
55 | |
52 | |
42 | |
42 |
User | Count |
---|---|
81 | |
79 | |
75 | |
67 | |
43 |