You’re offline. This is a read only version of the page.
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 Flow
Files to be found in Sharepoint
Could you mark the answer as solution?
Thank you
Did you miss the ' and ' in the statement?
substringof('ECON 4589-123', Title)
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.
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. 🙂
#1
Michael E. Gernaey
497
Super User 2025 Season 2
#2
David_MA
436
Super User 2025 Season 2
#3
Riyaz_riz11
244
Super User 2025 Season 2
Share
Report
All responses (
Answers (
