cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
glometeeb
Helper I
Helper I

Cut and Paste List Items

I have a list of of Estimates that grows very large very fast.  I would like to create a flow that once I mark them as coplete with a check box it moves them into a entirely new list.  I understand I can just filter them out the problem is that this list is used in multple other places by lookups.  So just filtering will not solve the issue.

I have not found a place in sharepoint where I could select multiple rows and just move them to a diffrent list.  I still want all of the DATA to be exaclty the same.  Basically just a cut and paste.

3 REPLIES 3
ScottShearer
Super User III
Super User III

Here is a way to approach your issue:

1) Use a recurrence trigger that fires periodically (Daily? weekly?)

2) Use a Get Items action with an OData filter that returns only items marked complete.  The OData filter would look something like this: Status eq 'Complete'

3) Loop though each item returned and create a new item in the destination list.

4) Delete the original list item

 

To delete the items in your detail list, go to list settings and click on the lookup column.  Check the "enforce relationship behavior" column and also check "cascade delete".  Doing so will allow for every item in the detail list to be deleted when the related entry is deleted.  Otherwise they will be orphans.

 

Scott

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

Could you show a screenshot of Flow steps?

Could you show the flow via screenshots?

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Top Kudoed Authors
Users online (36,674)