Hi everyone -
I am trying to move items from one sharepoint list to another list after a status change is made within one of the item’s fields.
Is it possible to set this up to:
a) run only when the status change is made, so I can avoid the flow constantly running or only running at 1 day intervals
b) keep any attachments that have been added to the list item with it as it is moved from one list to the other
c) keep conversation content and comments about the specific list item with that list item as it is moved
d) possibly do all of the above in one flow
Any help is greatly appreciated!
Lance
@lcroft you can create flow with When item or file is modified trigger, and use Get Changes action to determine whether the status has changed or not and also apply trigger condition to trigger the flow when status value is equal to the value on which you want the flow to trigger.
There isnt any out of box way to copy list item from one list to another so you will have get item from one list then to create item in another using data you got from the first list. Then copy attachments and then copy comments.
Here is blog on how to copy item with attachments: https://www.c-sharpcorner.com/article/copy-list-items-with-attachment-to-another-list/
Here is post on how to get comments: https://powerusers.microsoft.com/t5/Building-Flows/Get-Microsoft-Lists-Comments-using-Flow/m-p/787416/highlight/true#M109480
Based on comments you get from list, here is post on how to add comments to the list: https://beaucameron.com/2021/01/18/add-comments-to-sharepoint-list-items-using-the-rest-api/
Yes can do all of this in one flow.
WarrenBelz
146,518
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,692
Most Valuable Professional