GROOVY VIDEO! I run archives for a lot of sites, and one way I gatekeep for accuracy is by adding an approval process. My flow will run at about 5AM, when I log on, I have a pending approval that prompts me to give a quick visual once over at what was archived and make sure all looks 100%. After I Approve the status to that point, it then completes the process by deleting the original item from production. This video was very comprehensive and easy to follow. Always enjoy your content.
Great video Shane! Interestingly, I do run a weekly archiving Flow with almost similar actions as you demoed without the attachment bits so very good to add that to my arsenal. Thanks for sharing. Always appreciated.😎
Great video Shane, this one is next on my todo list, currently working on the document library video to get rid of our attachments, loved that one also btw 👍
Loved the way you slow-walked us through what would have seemed a complex flow, bud. Thanks v much. Only question i have is why delete the attachments on the old record if the last step deletes the entire record anyway? Cheers
Awsome, as usual! Why are people so scared of using complex columns in Power Apps? I really feel that a part of me is taken when we get rid of a lookup column 😭😭
Complex columns depend on the situation. If you are only using SharePoint as a "Database" then they add extra complexity. If you are using Power Apps to enhance the SharePoint experience, then they have a place. That is how I think about it. 😎
Shane - really enjoyed the video. I am wondering why you included the delete attachments action when you are ultimately deleting the list item. Thanks.
You are the second person to ask. 🤩 Basically I included it so be complete and show all of the mechanics. I find people rarely do exactly what I did and instead are there to learn a piece. So I wanted that piece to be complete. But yeah, if you are deleting the whole thing then you could skip deleting the attachment. Nice catch. 😎
I ran into this recently where I needed to archive/move a list but preserve the created/created by and modified/modified by columns. Would you use a Send an HTTP request to SharePoint like I ended up doing or is there a better way to accomplish that?
Yes, you would have to use the API at that point. The other option is to create new Columns called "Original Created By" and "Original Created" etc. Then populate those using the flow method.
Hi Shane. I'm struggling to understand why you added an action to delete each attachment when the entire list item is going to be deleted anyway. For what it's worth, my own approach to flows that archive list items is NOT to delete each row as it's copied across. I worry that something's going to go awry and items will be deleted when they haven't properly been copied to the archive list. I know that shouldn't happen, but the possibility of losing data keeps me awake at night 😁 So, my approach is to add a column to the source list to act as a flag to indicate the record has been copied. The flow updates the source list item as each item is copied. Then I have a separate flow that (bulk) deletes items from the source list that have the flag set. This approach means I can satisfy myself the copy operation has worked (e.g. it's copied the same number of records to the archive list as have have had flags set in the source list) before running the bulk delete flow. A longer process, but it helps me sleep better at night (and it helps me keep my job!)
You are the third person to ask. 🤩 Basically, I included it so be complete and show all of the mechanics. I find people rarely do exactly what I did and instead are there to learn a piece. So, I wanted that piece to be complete. But yeah, if you are deleting the whole thing then you could skip deleting the attachment. Nice catch. 😎 I have accidently deleted the wrong data before; I know that awkward pain, so I don't blame you for nothing.
Thanks for the great material! I have a question: is there a daily API call limit with a standard SharePoint license? For large lists, wouldn't a more effective method be to delete and save rows to the list in batches using HTTP requests?
Yes, if you know how to use HTTP with batches that is going to save you a lot of actions. 🤩 Baby steps here though. That stuff can be pretty scary for a new builder. 😎
This certainly aids in something that I've been thinking about for a sharepoint list I maintain. One question I have, though: what happens if we want to preserve the version history of a list item? For example, I have a list that shows when someone approves an item as well as who approved it. We want to preserve the version history for audits, etc. I don't think moving list items to a new list would do that. Is there another method of archiving that can preserve the version history information?
Not that I know of. I think you would have to use the API to get the old versions and create them somewhere else. :( Not 100% sure though, I have never tried.
@@ShanesCows Many thanks! I got my archiving working. I had a problem with new interface because it was not reflecting the correct parameter whenever I reference to a SharePoint List ID. I was able to make it work with the old interface. I wish they would fix the bugs before implementing the new interface. Thanks again! You are a life saver!
Amazing..... Bookmarked and will watch again and again. Thanks Shane. 💥💥💥💥💥💥💥💥
Happy to help! Have a great week.
GROOVY VIDEO! I run archives for a lot of sites, and one way I gatekeep for accuracy is by adding an approval process. My flow will run at about 5AM, when I log on, I have a pending approval that prompts me to give a quick visual once over at what was archived and make sure all looks 100%. After I Approve the status to that point, it then completes the process by deleting the original item from production. This video was very comprehensive and easy to follow. Always enjoy your content.
I like the approval step 🥰
Timing on the release of this is a bit scary. How did you know this is exactly what my team is setting up this week? As always, great content!
They called me. They were hoping you wouldn't see the video so they looked like geniuses. 🤣 Have a great week!
This video release is the 2nd scary one for me. 1st was the document library in stead of attachments and now this one 😱
Great video Shane! Interestingly, I do run a weekly archiving Flow with almost similar actions as you demoed without the attachment bits so very good to add that to my arsenal. Thanks for sharing. Always appreciated.😎
Happy to help
Great video Shane, this one is next on my todo list, currently working on the document library video to get rid of our attachments, loved that one also btw 👍
Awesome. I am team no attachments so glad that is helping😍
Loved the way you slow-walked us through what would have seemed a complex flow, bud. Thanks v much. Only question i have is why delete the attachments on the old record if the last step deletes the entire record anyway? Cheers
Great point 😎 I was just trying to be thorough on the pieces so people could take what they want. But you are correct, you wouldn't really have to.
Awsome, as usual!
Why are people so scared of using complex columns in Power Apps? I really feel that a part of me is taken when we get rid of a lookup column 😭😭
Complex columns depend on the situation. If you are only using SharePoint as a "Database" then they add extra complexity. If you are using Power Apps to enhance the SharePoint experience, then they have a place. That is how I think about it. 😎
Incredible video. Thanks Shane.
My pleasure!
Another great video. Thanks Shane
My pleasure!!
Shane - really enjoyed the video. I am wondering why you included the delete attachments action when you are ultimately deleting the list item. Thanks.
You are the second person to ask. 🤩 Basically I included it so be complete and show all of the mechanics. I find people rarely do exactly what I did and instead are there to learn a piece. So I wanted that piece to be complete.
But yeah, if you are deleting the whole thing then you could skip deleting the attachment. Nice catch. 😎
@ShanesCows thanks for explaining that. I also was wondering why you were deleting the attachments before deleting the row.
I ran into this recently where I needed to archive/move a list but preserve the created/created by and modified/modified by columns. Would you use a Send an HTTP request to SharePoint like I ended up doing or is there a better way to accomplish that?
Exactly the same question… I don’t want all records in the archive having my username attached to it
Yes, you would have to use the API at that point. The other option is to create new Columns called "Original Created By" and "Original Created" etc. Then populate those using the flow method.
Hi Shane. I'm struggling to understand why you added an action to delete each attachment when the entire list item is going to be deleted anyway.
For what it's worth, my own approach to flows that archive list items is NOT to delete each row as it's copied across. I worry that something's going to go awry and items will be deleted when they haven't properly been copied to the archive list. I know that shouldn't happen, but the possibility of losing data keeps me awake at night 😁
So, my approach is to add a column to the source list to act as a flag to indicate the record has been copied. The flow updates the source list item as each item is copied. Then I have a separate flow that (bulk) deletes items from the source list that have the flag set. This approach means I can satisfy myself the copy operation has worked (e.g. it's copied the same number of records to the archive list as have have had flags set in the source list) before running the bulk delete flow.
A longer process, but it helps me sleep better at night (and it helps me keep my job!)
You are the third person to ask. 🤩
Basically, I included it so be complete and show all of the mechanics. I find people rarely do exactly what I did and instead are there to learn a piece. So, I wanted that piece to be complete.
But yeah, if you are deleting the whole thing then you could skip deleting the attachment. Nice catch. 😎
I have accidently deleted the wrong data before; I know that awkward pain, so I don't blame you for nothing.
Thanks for the great material! I have a question: is there a daily API call limit with a standard SharePoint license? For large lists, wouldn't a more effective method be to delete and save rows to the list in batches using HTTP requests?
Yes, if you know how to use HTTP with batches that is going to save you a lot of actions. 🤩 Baby steps here though. That stuff can be pretty scary for a new builder. 😎
This certainly aids in something that I've been thinking about for a sharepoint list I maintain. One question I have, though: what happens if we want to preserve the version history of a list item? For example, I have a list that shows when someone approves an item as well as who approved it. We want to preserve the version history for audits, etc. I don't think moving list items to a new list would do that. Is there another method of archiving that can preserve the version history information?
Not that I know of. I think you would have to use the API to get the old versions and create them somewhere else. :( Not 100% sure though, I have never tried.
How do you archive a SharePoint List that already exceeded the "List View Threshold" which max out at 5,000 items?
I have never tried. Hmmm... Get Items works on lists over the threshold. I did an oData query where Title eq 'Item 25001' and it got it
@@ShanesCows Many thanks! I got my archiving working. I had a problem with new interface because it was not reflecting the correct parameter whenever I reference to a SharePoint List ID. I was able to make it work with the old interface. I wish they would fix the bugs before implementing the new interface. Thanks again! You are a life saver!
What's the different between Value and Item?
Sorry, not sure what you are asking. Time stamp maybe so I can get context?
❤❤
😎
Microsoft need a simple solution to handle multi choice, people and choice..
That would be nice 😎