Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Get data based on file name

I've searched the forum for a while now but can't seem to find a solution to my problem.    What I'm trying to achieve is collecting data in to a master based on the file name. I have a huge folder...
Data Protection
  • mahoneypat's avatar
    mahoneypat
    6 years ago

    Using the Folder or SharePoint Folder connectors, you can get a list of all the files.  You can then Filter the file name column for text that contains "project".  In the query editor, click on the pull-down arrow on the right of the column header and select Text Filters/Contains ...  You could also filter first to a specific subfolder (if needed) by filtering that column.

     

    If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

    Regards,

    Pat

mahoneypat's avatar
mahoneypat
Microsoft Employee
6 years ago

Using the Folder or SharePoint Folder connectors, you can get a list of all the files.  You can then Filter the file name column for text that contains "project".  In the query editor, click on the pull-down arrow on the right of the column header and select Text Filters/Contains ...  You could also filter first to a specific subfolder (if needed) by filtering that column.

 

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat