Forum Discussion
Get data based on file name
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
Yes to some extent, although when I add a new file to the folder with the same layout it doesnt import it. It gives me an alert that a column is missing. What i did in the editor is that i removed some rows of each file to only keep the data i need.
That might be the problem?