Forum Discussion

Kaycee's avatar
Kaycee
Advocate I
4 years ago
Solved

Import Excel/CSV from SharePoint with Metadata Filter

Hi all,    I have documents stored in SharePoint but rather than using folders, I use metadata (columns) to tag files.  The SharePoint Folders Import doesn't include metadata columns but do include...
Need Help
  • Kaycee's avatar
    Kaycee
    4 years ago

    I was fortunate enough to be given this advice in another forum which is effective & efficient:

    Step 1
    Create a helper query MetaFileNameList that generates a list of file names based on the metadata

    Step 2
    Use that list to filter your query with SharePoint.Files or SharePoint.Contents, something like:

    Table.SelectRows( PrevStepName, each ( List.Contains( MetaFileNameList, [FileNameCol] ) =true ))

Kaycee's avatar
Kaycee
Advocate I
4 years ago

I was fortunate enough to be given this advice in another forum which is effective & efficient:

Step 1
Create a helper query MetaFileNameList that generates a list of file names based on the metadata

Step 2
Use that list to filter your query with SharePoint.Files or SharePoint.Contents, something like:

Table.SelectRows( PrevStepName, each ( List.Contains( MetaFileNameList, [FileNameCol] ) =true ))