Unanswered

Sharepoint URl Get HTTP request seach and filter

(0) Share

Report

Posted on by Kratos1

Hi,

I am trying to search and filter for certain files in SharePoint from PowerApps. I have currently got a search setup and it retrieves the main folder and all the subfolder files. I want to only retrieve files from certain subfolders within the Mainfolder and was wondering is there a way to do this.
I have tried adding certain filters ie filtering the path to see if it contains folder names and also substringof but none of them seem to work. I am adding these filters to the end of the URI below "$filter=Path eq *Subfolder4* or Path eq *Subfolder 2* or Path eq *OtherSubfolder*" is there a way to do this as i dont want to retrieve any folders just the files in those folders

Any help would be much appreciated.
Thanks

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

Srini007 3,463 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @Kratos1

Try as below

$filter=startswith(FileDirRef,'/MainFolder/Subfolder4') or startswith(FileDirRef,'/MainFolder/Subfolder2') or startswith(FileDirRef,'/MainFolder/OtherSubfolder')

If you find this reply helpful, please consider giving it a LIKE AND

If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION

Thanks,

Srini

Was this reply helpful? Yes No
Kratos1 12 on at

Like (0)

Report
Copy link

Link copied!

Hi @Srini007 ,

The Uri search helps locate the "MainFolder" and brings this up as one of the search results based on the searched text so I cant use "MainFolder" in the filter for the structure if we don't know what the main folder is.

Was this reply helpful? Yes No