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
Further to the question posted by arduaj, my query is after i select a particular folder wherein there are 50 plus files containing data of each day's stock prices. I want to retrieve the contents of a particular day's file based on the date that i have entered in my excel sheet. I do not want to go to query editor everytime and change the date in the filter criteria.
Could you guide me with a solution please.
Thanks in advance.