Answered

Query Help For Get Items (Title contains string)

(0) Share

Report

Posted on by 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

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

schwibach 2 Moderator on at

Like (1)

Report
Copy link

Link copied!

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. 🙂

Was this reply helpful? Yes No
PowerAppsWizard 388 on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
dsflex 11 on at

Like (0)

Report
Copy link

Link copied!

This is the error I receive when I try this solution:
The expression "substringof(ECON 4589-123, Title) " is not valid. Creating query failed.

Was this reply helpful? Yes No
PowerAppsWizard 388 on at

Like (0)

Report
Copy link

Link copied!

Did you miss the ' and ' in the statement?
substringof('ECON 4589-123', Title)

Was this reply helpful? Yes No
dsflex 11 on at

Like (1)

Report
Copy link

Link copied!

This worked for me, thank you!

Was this reply helpful? Yes No
PowerAppsWizard 388 on at

Like (0)

Report
Copy link

Link copied!

Could you mark the answer as solution?
Thank you

Was this reply helpful? Yes No