Unable to search Folder Path

[nogstai]

I'm using PowerQuery by creating a dataflow in Fabric. When I'm trying to Get Data from a Sharepoint, I need to filter the folder path due to the number of files and folders I have. I use Folder Path, then click "See More", then type in the text to search. But it's not showing any results. The values are clearly there, I had to scroll a lot to find a sample.

Is there any reason for this behavior? I encounter this from time to time, but sometimes for other dataflows I create I have no issues.

[Anonymous]

Hi @nogstai 
Thank you for reaching out microsoft fabric community forum.
I wanted to check if you had the opportunity to review the information provided by @lbendlin and @PwerQueryKees . Please feel free to contact us if you have any further questions. If their response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you

[PwerQueryKees]

Power Query is case sensitive. So if you type the search text, a mistake is easily made! I know from experience....

The data and screenshot you provide dont give enough information to make me sure this is your problem though...

Kees Stolker

A big fan of Power Query and Excel

[lbendlin · Accepted solution]

you have too many items and/or folders.  Use the Text filter option to narrow it down.  or use SharePoint.Contents() for manual navigation.