Query Help For Get Items (Title contains string)

[dsflex]

I am wanting to search through a folder in Sharepoint to find a PDF that contains a given string, which in this case is a course (e.g. ECON 2000-100). I don't understand how to format the ODATA filter query in order to accomplish this. Here is a screenshot of my flow as well as some example documents of what I am searching for. The first part of the PDF names are blurred out to hide private information.

Get Items in FlowFiles to be found in Sharepoint

[schwibach · Accepted solution]

First thing to do is list the files in that folder.

Here's a short clip how to do that https://ibb.co/fqV9r6Z

Then you use the filter array action to only get the record of the file name that you want. Then you can get the file content in the next action.

It's only a few steps. You can do it.
If you need more assistance, we're here. 🙂

[PowerAppsWizard]

Hi,

odata could also work. In the filter statement e.g. Title eq 'ECON 2000-100' this would return the document(s) which have a Title equals to the statement. Or you try in the filter statement a substringof('ECON 2000-100', Title) which list all documents containing the string.

[dsflex]

This is the error I receive when I try this solution:

The expression "substringof(ECON 4589-123, Title) " is not valid. Creating query failed.

[PowerAppsWizard]

Did you miss the ' and ' in the statement?

substringof('ECON 4589-123', Title) 

[dsflex]

This worked for me, thank you!