cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dsflex
Frequent Visitor

Query Help For Get Items (Title contains string)

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 FlowGet Items in FlowFiles to be found in SharepointFiles to be found in Sharepoint

1 ACCEPTED SOLUTION

Accepted Solutions
schwibach
Impactful Individual
Impactful Individual

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

__________________________________
Please mark topics as solved if they are and give kudos to make people happy 🙂
Always interested to hear about solutions/problems in the education sector.

View solution in original post

5 REPLIES 5
schwibach
Impactful Individual
Impactful Individual

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

__________________________________
Please mark topics as solved if they are and give kudos to make people happy 🙂
Always interested to hear about solutions/problems in the education sector.
PowerAppsWizard
Resolver III
Resolver III

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.

 

 

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
Resolver III
Resolver III

Did you miss the ' and ' in the statement?

substringof('ECON 4589-123', Title) 

This worked for me, thank you!

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,170)