Forum Discussion

Copper Contributor

Jan 23, 2023

Personalized folders tags in sharepoint

Sharepoint is for sharing. Tags (a windows File Explorer feature in file properties) helps search at high-level content past filename. My tags aren't going to be relevant for all parties that have sh...

Bronze Contributor

Jan 24, 2023

Hi orionyeung,

if you did sync the folder "sharepoint_folder_in_onedrive" then no.

Everything below that folder is synced to the sharepoint folder, so everything you change below sharepoint_folder_in_onedrive will be changed on your SharePoint.

But if you have a SharePoint folder structure like this

SharePoint Site
├── Folder1
│   ├── Subfolder1.1
│   ├── Subfolder1.2
│   ├── Subfolder1.3
├── Folder2
│   ├── Subfolder2.1

then you can go into "Subfolder1.1" and "Subfolder2.1" folder and sync both to OneDrive

Your OneDrive
├── Subfolder1.1 (link to Subfolder1.1)
├── Subfolder2.1 (link to Subfolder2.1)

Then rename the folders like this

Your OneDrive
├── Case A (link to Subfolder1.1)
├── Case B (link to Subfolder2.1)

and then move both folders into a subfolder like this

Your OneDrive
├── Cases (real folder on your OneDrive)
│ ├── Case A (link to Subfolder1.1)
│ ├── Case B (link to Subfolder2.1)

In that way you can build your own folder structure on your OneDrive with links to many different SharePoint folders.
Everything below the "Case A" and "Case B" folder will be live SharePoint data from the "Subfolder1.1" and "Subfolder2.1".

You don't have to change properties or labels here, you just re-organize existing SharePoint Folders in your Onedrive into a structure that is more suitable for you.

Best Regards,
Sven

orionyeung

Copper Contributor

Jan 24, 2023

Hmm, this won't scale well enough for the depth of folder nesting I have. Can powershell list locations of all files and copy files? If I have that, then I can handle it.

If can I get output like below of the entire sharepoint (somehow, I assume powershell could work), then I could do the rest on my own (with powershell)

SharepointRootDir/folder1/folder1.1
SharepointRootDir/folder1/folder1.1/filea.txt
SharepointRootDir/folder1/folder1.1/fileB.txt
SharepointRootDir/folder1/folder1.2/fileC.txt
SharepointRootDir/folder2/folder2.1/fileD.txt
SharepointRootDir/folder3/fileE.txt

SvenSieverding

Bronze Contributor

Jan 25, 2023

Hi orionyeung,

ok, getting a list of all files in a sitecollection is easy using PnP Powershell

Connect-PnPOnline https://tenant.sharepoint.com/sites/mysite

$DocumentLibraries = Get-PnPList | Where-Object { $_.BaseTemplate -eq 101 -and $_.Hidden -eq $false } 

$DocumentLibraries | foreach-object {
    $ListItems = Get-PnPListItem -List $_.Title -PageSize 500 | Where { $_.FileSystemObjectType -eq "File" }
    ForEach ($Item in $ListItems) {
        $Item.FieldValues['FileRef']
    }
}

Best Regards,
Sven