I have a sharepoint list that I would like to organize. This sharepoint list has several folders and I would like to move some listitems from one folder to the other.
I have a column that I would like to use as an identifier (Like title), if the value of this column is A, I would want to move the listitem to folder 1. If it's B, it goes to folder 2. Changes might be a common thing, so I need to check it every week.
However, I am not seeing the -folder option for Set-pnplistitem. https://pnp.github.io/powershell/cmdlets/Set-PnPListItem.html
For add-pnplistitem, there is an option to specify a folder: https://pnp.github.io/powershell/cmdlets/Add-PnPListItem.html
Am I looking at the right direction? I would like to have this automated, currently, my requirement is to use powershell to do this, but if there are other easier ways to do this. I am all ears.
Thank you for any insights or assistance you may offer.