cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
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
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Solution Authors
Users online (2,447)