Search function for gallery via document Name not working as expected :(

[Highwaywoman1]

Hello, 

I have a gallery for a document library in Sharepoint.

The Name( with link to document) is the column I want to search by in my SearchBox.

I don't know the internal name and can not find it online. fileRef, linkToFile, etc none of those have worked so far. 

I want to be able to search by the uploaded document name or maybe have a calculated column that copies the Name into a different field (last resort! So hoping someone can help me out.)

Thank you so much, 

What I am using in my Gallery Items:

Search(
Filter(Repository, docType.Value=Dropdown_docType.Selected.Value),
SearchBox.Text,
"fileRef",
"description"
)

[RandyHayes]

@Highwaywoman1 

Stay away from the calculated column!!

Keep in mind as well that many of the columns in a document library are already calculated columns.  This will impact searching. 

Also consider, how big is your list?  This is misleading for a document library.  A doc library is a list like any other list.  People often get confused thinking - the folder you are looking in is small.  But it is not relevant.  There is no such things as a folder in a document library.  They are all "simulated".  In reality the entire document library is a list.  And as such, every file and folder in the entire document library goes toward record count, and thus, delegation and record limits in your app play a big part.

I hope this is helpful for you.

[WarrenBelz]

Hi @Highwaywoman1 ,

Firstly do not use calculated columns - they will not help. I suggest you have a Text column and use Power Automate to copy the name in there when the file is created.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

[Highwaywoman1]

Fair enough on staying away from calc columns, thank you both @WarrenBelz @RandyHayes 

However, do you know how i can search by the Name (link to item) column in the document Library?

I can search by title or any other column. I just cant see that column in the library settings. I don't know what it's internal name is to reference it in my formula. 

[WarrenBelz · Accepted solution]

@Highwaywoman1 ,

It seems you cannot (I tested it as well as I have never tried it before). You need to write the name to another text field as I suggested.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps