Copy list data to another in same site

Question

Hello All,

I want to copy list( Threshold limit already passed ) items only for those "Status" ( Column ) is set to "Deactive" to another list.

As "Status" column has not been indexed it's throwing error to retrieve using caml query and I cant indexed it now as there are already 20 columns which has been indexed.

So request you to suggest/guide me the good way/option to perform this task.
Powershell/Flow/Webjobs

Thanking you in advance.

Regards,
Jayashri

Answer 1

To copy list items containing a specific column value to another list, please refer to the following steps:

1.Go to List settings -> Views section -> Create view -> Standard View -> Type in View Name and add a Filter like below -> Click OK to save:

2.Access Site Content and Structure page via URL-https://<tenantname>.sharepoint.com/sites/<sitename>/_layouts/15/sitemanager.aspx(only Site Collection Administrator can access this page) -> Select the source list in the left quick launch panel-> Click View and select the view created above:

3.You can set Show to 1000 for convenience in the upper right corner:

4.Click the box icon to select all in the upper left corner and then select Copy under Actions drop down list -> Select your target list in the next pop-up window and click OK:

5.Click the button in the figure below to change the page, repeat the steps in 4. until the last page.

I hope this information has been useful, please let me know if you still need assistance.

---

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.