Copy List (Items/Views) from one site to another

(0) Share

Report

Posted on by Gokulnath_March

218

Hi,

We are using the MS form, where the user can select the destination site and List to be copied. We need to copy List/Views/Items.

I searched, using REST API we can get/copy list items from one site to another , but is there a way to copy list columns and list views.

Screenshot:

Thank-you,

Gokulnath.

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (0)

David- 1,254 on at

Like (0)

Report
Copy link

Link copied!

For things like you want to do, we use ShareGate: https://sharegate.com. Here is how it would solve your problem: https://youtu.be/-5AaUkcWuv0. We've been using for over six years now and it works great.

Was this reply helpful? Yes No
Gokulnath_March 218 on at

Like (0)

Report
Copy link

Link copied!

Hi @David- ,

Thanks for your response. We are not allowed to use ShareGate Tool here. We need to automate this using Power Automate.

Was this reply helpful? Yes No
Gokulnath_March 218 on at

Like (0)

Report
Copy link

Link copied!

Hi @Pstork1 , Any suggestion on this ?

Was this reply helpful? Yes No
Pstork1 68,900 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

The only way to create lists and list columns in SharePoint using Power Automate is by using HTTP REST calls. Take a look at this article.

Working with lists and list items with REST | Microsoft Docs

Was this reply helpful? Yes No
Gokulnath_March 218 on at

Like (0)

Report
Copy link

Link copied!

Hi @Pstork1 ,

Thank-you. I am trying using the above API calls. I have created the view using API. I need to add fields to that particular view. To do that i am following the below approach.
https://powerusers.microsoft.com/t5/Building-Flows/Using-REST-API-to-create-a-field-in-a-Sharepoint-list-all/td-p/1047712

I need to get the list of fields from <ViewFields> tag in String variable. which function I need to use ?

Was this reply helpful? Yes No
Pstork1 68,900 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

There are XML specific actions and functions that let you extract information from XML. Here's the documentation.

XML | Microsoft Docs - Power Automate | Microsoft Docs

Was this reply helpful? Yes No