This is really helpful and the only one I’ve seen where data can be transferred. Question: would you know if associated files/attachments are carried over too?
Awesome! Once I knew I could get the list structure across Site Collections, I paused the video and wrote the flow (I've done a number of flows) and finished it in about the same time as your video. Ran great! Sometimes I don't know little things like list templates can be copied.
Thank you, Michael! This worked smoothly and was exactly what I needed. Other videos suggested much more complicated processes. I had no idea it was so much more involved that moving a document library!
Thank you Mike, Just to share, IMC, cause, SP Online has upgraded now, few steps in this video seem to be redundant. I had to export the list as CSV with Schema, and import it at destination site to achieve the above (Copy A SharePoint List with Data to Another SharePoint List). Still The steps were quite intuitive to understand the process.
Straight and simple explanation, thanks so much for the guidance, quick question; If the Sharepoint list has attachments, this procedure would be the same? Thanks in advance!
Great video! Short and to the point. Is there a good time when the apply to each would not be useful or not something you want? Since it gets automatically applied, how would you remove it, if you wanted to and the effect of that?
Great video, thanks Michael! Is there a way this could work so if you ran it again it would overwrite the same cells and not add additional rows to the list?
Hey Mike thank you so much for this, it was really helpful. I do have a question. Due to the lookup column threshold, I cannot copy over all of my over 35 columns at once. So i did the first 10 and it worked. Then I recreated the workflow so the next 10 columns get pasted on the same rows that were populated. But they all got pasted under the first rows (in the right columns). How do I get the next set of data to line up in the correct rows?
Thank you! Do you happen to know if I delete or remove the list it was copied from, if it would delete everything I moved over to the new space? Ideally, would like to work off this newly transferred list going forward.
Once the Flow has ran and copied the data over, you can remove the old list. It won't affect the new list. Just be sure everything looks correct on the new list.
Thank you Michael. One follow-up question -- can we just copy specified rows to the new site ? for example, under one coloumn, I categorized the items by "Open" & "Closed" status, can i just copy those "open" items to the new list ? Many thanks for your help in advance ! 😍
Hi, is it possible to transfer a list from My Lists with this method? Because I can only find list from a Sharepoint in Get Items and not my own private list. Thanks in advance!
Cheers mate, Solved my issue. Only issue I had was that the flow refused to run until I took out a few of the columns I believe because they had multiple choice entries in. It was trying to do multiple apply to each's within itself which then broke.
Great video, thank you! Is there a solution to deal with these multiple choice columns, to copy across the selection from the original list over to the new list?
Hey Michael, how can we duplicate a list to the same SharePoint as a new list using the source as a "template", empty new list but has all source columns and settings, using Power Automate. Thanks in advance.
Update item require unique ID. But i have deleted some rows in destination list so fetting an error while copying using ID in update item, any solution?
Thx for the Vid. But i´m unable to create a flow thats working . Doin it like in the vid but the get item step shows errors. I hate SP hate MS and all the stupid non existing simple make live easy steps.
Can we migrate / copy comments as well from one list to another using power automate, as normal power automate flow doesn't get the list item comments.
That threshhold limit for 256 rows is ridiculous coming from a so-called leading Tech company like M$oft. If there was a better technology that integrated into Sharepoint like List, I would use it in a heartbeat. Anyways, thanks for your content. It is helpful.
Hello Michael, thanks for another great VID! I've watched a lot of tutorials and yours is easy to follow. Thanks - Newbie here - Question, is it possible to create a Sharepoint List based of a file from a Sharepoint Page?
Hey Michael, Is there a way that a flow like this can copy over Calculated fields from one list and convert them to number or text data in the copy to list?
@@michaelalex2322 Thanks for the quick reply. My issue is that when I am selecting the fields from the Dyanamic content. The Calculated Fields aren't visible. I'm sure I'm missing something.
Try typing in the name of the calculated field in the dynamic content. Sometimes if it is looking for a number, it will just pull related number fields and not all the fields
I've got a question. So I've link two Sharepoint Lists together, but when I run through the flow, I'm getting an error that says "The list item could not be added or updated because duplicate values were found in the following field(s) in the list." Would you happen to know why this is happening? Is it trying to update the current data that's in the spreadsheet with the data that's coming in?
No, I don't believe that's possible. If it's only a few lists, you could export the list information to Excel, then switch tenants, and make a flow to export the excel information to the SharePoint list.
@@michaelalex2322 The problem I've seen with exporting lists to excel and reimporting them is that the fields don't keep specific names. They end up field_1, field_2, field_3, field_4, etc.
@@michaelalex2322 Apparently, I was able to create it using "send http request to sharepoint" with POST as its method. I defined the JSON payload in the "body" field for the multi-line text column. My problem now is that the newly created column is still hidden and have to manually show it in the column settings. Basically, it defeats the purpose of automating it. 🤣
Haha, that is out of my league. I used to use an application called ShareGate that might be able to accomplish this or else you will likely need to use PowerShell.
![fellow fellow - พรุ่งนี้ไม่มีใครรู้ feat. INK WARUNTORN [OFFICIAL MV]](http://i.ytimg.com/vi/QP6JyjYx_W0/mqdefault.jpg)
This is really helpful and the only one I’ve seen where data can be transferred. Question: would you know if associated files/attachments are carried over too?
Awesome! Once I knew I could get the list structure across Site Collections, I paused the video and wrote the flow (I've done a number of flows) and finished it in about the same time as your video. Ran great! Sometimes I don't know little things like list templates can be copied.
This video is exactly what I needed. Thank you, Michael.
You're very welcome
Thank you, Michael! This worked smoothly and was exactly what I needed. Other videos suggested much more complicated processes. I had no idea it was so much more involved that moving a document library!
Thank you Mike, Just to share, IMC, cause, SP Online has upgraded now, few steps in this video seem to be redundant. I had to export the list as CSV with Schema, and import it at destination site to achieve the above (Copy A SharePoint List with Data to Another SharePoint List). Still The steps were quite intuitive to understand the process.
You're my man of the day Michael!🙏
Hello Michael, thank you for sharing this guide. It worked perfectly for me.
Straight and simple explanation, thanks so much for the guidance, quick question; If the Sharepoint list has attachments, this procedure would be the same? Thanks in advance!
Thanks Michael it works perfect!!
Great video! Short and to the point. Is there a good time when the apply to each would not be useful or not something you want? Since it gets automatically applied, how would you remove it, if you wanted to and the effect of that?
Thank you for sharing :)
Thank you for this! Made it so easy!
Thank you very much, Michael. It works perfectly.
This work perfectly. I am also trying to copy over comments, is there a way to do this?
Great video, thanks Michael! Is there a way this could work so if you ran it again it would overwrite the same cells and not add additional rows to the list?
it worked like a charm thanks man
You're welcome!
Hey Mike thank you so much for this, it was really helpful. I do have a question. Due to the lookup column threshold, I cannot copy over all of my over 35 columns at once. So i did the first 10 and it worked. Then I recreated the workflow so the next 10 columns get pasted on the same rows that were populated. But they all got pasted under the first rows (in the right columns). How do I get the next set of data to line up in the correct rows?
Thank you! Do you happen to know if I delete or remove the list it was copied from, if it would delete everything I moved over to the new space? Ideally, would like to work off this newly transferred list going forward.
Once the Flow has ran and copied the data over, you can remove the old list. It won't affect the new list. Just be sure everything looks correct on the new list.
Thank you Michael. One follow-up question -- can we just copy specified rows to the new site ? for example, under one coloumn, I categorized the items by "Open" & "Closed" status, can i just copy those "open" items to the new list ? Many thanks for your help in advance ! 😍
THANK YOU! 🙌🏻
Hi, is it possible to transfer a list from My Lists with this method? Because I can only find list from a Sharepoint in Get Items and not my own private list. Thanks in advance!
Hi Michael, Would this also make it so that you could delete the data from your other list and it would still have it populated?
Thanks. Helpful
You're welcome
Thanks , works perfectly ...But what bout the attachments ?
Agreed! What about attachments?
Cheers mate, Solved my issue. Only issue I had was that the flow refused to run until I took out a few of the columns I believe because they had multiple choice entries in. It was trying to do multiple apply to each's within itself which then broke.
Yeah those multiple choice columns are always a pain. Glad it helped out
Great video, thank you! Is there a solution to deal with these multiple choice columns, to copy across the selection from the original list over to the new list?
Hey Michael, how can we duplicate a list to the same SharePoint as a new list using the source as a "template", empty new list but has all source columns and settings, using Power Automate. Thanks in advance.
Will this work with list item attachments?
Update item require unique ID. But i have deleted some rows in destination list so fetting an error while copying using ID in update item, any solution?
Thx for the Vid. But i´m unable to create a flow thats working . Doin it like in the vid but the get item step shows errors. I hate SP hate MS and all the stupid non existing simple make live easy steps.
Thanks! Does it transfer comment history, too?
I don't think it will transfer, only the most current version
Can we migrate / copy comments as well from one list to another using power automate, as normal power automate flow doesn't get the list item comments.
Or with a small number of rows, simy open both lists Edit in Grid move, then select all, the copy , paste into the new one.
I’m getting errors with that unfortunately though. I think it’s the person/claims field.
Great video, thank for it
But it is not working with picture columns
Hi Michael, is it possible to create a flow just to copy specific columns in a new list ? rather than just copying all the columns?
Yeah, when you create the Flow in the 'Create Item' action for the SharePoint List only enter in the Columns that you need copying over
That threshhold limit for 256 rows is ridiculous coming from a so-called leading Tech company like M$oft. If there was a better technology that integrated into Sharepoint like List, I would use it in a heartbeat. Anyways, thanks for your content. It is helpful.
Hello Michael, thanks for another great VID! I've watched a lot of tutorials and yours is easy to follow. Thanks - Newbie here - Question, is it possible to create a Sharepoint List based of a file from a Sharepoint Page?
Not sure, what you mean by SharePoint page. If it's stored in a document library you might be able to work with it depending on the file type.
How to do it when the data is in my personal SharePoint and it is not part of the drop down list when choosing the site to get items from?
You need to be in the same environment. If you are, you can copy and paste the SharePoint URL
Hi, is it possible to copy date from one sharepoint to another sharepoint when item is created (I think it uses automated cloud flow), Many thanks !
i have tried and works. thanks
Hello michael. How to copy an image from sharepoint list to another list
This will work on Microsoft lists as well? Many thanks
The connectors are SharePoint so I don't believe it will work
Hey Michael, Is there a way that a flow like this can copy over Calculated fields from one list and convert them to number or text data in the copy to list?
Yes, in the new list you would just create a 'Single Line of Text' or 'Number' column. Then copy the calculated field data to the column
@@michaelalex2322 Thanks for the quick reply. My issue is that when I am selecting the fields from the Dyanamic content. The Calculated Fields aren't visible. I'm sure I'm missing something.
Try typing in the name of the calculated field in the dynamic content. Sometimes if it is looking for a number, it will just pull related number fields and not all the fields
I got one issue where my personal share point site is not accessible by buy organisations sharepoint
what happens when one of the columns is Images, does it show on the other sharepoint too? the field
No, Images are a complex column. There might be a way but I haven't attempted it yet
Crazy how they’ve way over complicated this process. How many avg Joe’s will be able to do this?
I've got a question. So I've link two Sharepoint Lists together, but when I run through the flow, I'm getting an error that says "The list item could not be added or updated because duplicate values were found in the following field(s) in the list." Would you happen to know why this is happening? Is it trying to update the current data that's in the spreadsheet with the data that's coming in?
Where you able to find a solution for this error . I am facing the same issue
Hello, we have 100 limit to run the flow. I have 5000 entries. how `i can copy all row?
In the Settings of the action, change turn on Pagination and set it greater than 5000
@@michaelalex2322 thank you
hey bro, is it possible to make a flow who can copy lists between sharepoint online site in different tenants
No, I don't believe that's possible. If it's only a few lists, you could export the list information to Excel, then switch tenants, and make a flow to export the excel information to the SharePoint list.
@@michaelalex2322 The problem I've seen with exporting lists to excel and reimporting them is that the fields don't keep specific names. They end up field_1, field_2, field_3, field_4, etc.
Hi, do you have any idea how to automatically add a new column after copying the data to another list?
Don't believe there is an action to create new column in a SharePoint List. I would create it beforehand.
@@michaelalex2322 Apparently, I was able to create it using "send http request to sharepoint" with POST as its method. I defined the JSON payload in the "body" field for the multi-line text column.
My problem now is that the newly created column is still hidden and have to manually show it in the column settings. Basically, it defeats the purpose of automating it. 🤣
Gotcha, yeah I haven't used that action too much. Hopefully, you can figure it out lol
Can you do this from powerautomate desktop
I haven't use Power Automate Desktop so I'm not sure
This shows how much SP sucks - why not simply include a checkbox "with data"?
Yes!! Some of the dumb SP functionality limitations rile me up
How to copy site and DB to another SharePoint tenant id
Haha, that is out of my league. I used to use an application called ShareGate that might be able to accomplish this or else you will likely need to use PowerShell.