Filter partial item names on gallery

(0) Share

Report

Posted on by Sormick

516

Hello,

On my gallery i have item names like these:

Portugal lisbon 1
Portugal lisbon 2
Portugal lisbon 3
Spain Madrid 2
Spain Madrid 3

I need to filter all items which contains the text "lisbon"

Please find my current formula:

Filter(Documents;Path="Shared Documents/General/backup/2024/A/1/")

I also tried with Filter(Documents; "lisbon" in Path="Shared Documents/General/backup/2024/A/1/")

but did now worked.

Categories:

Using Apps Using Formulas

I have the same question (0)

All responses (7)

Answers (1)

Ami K 15,670 Super User 2024 Season 1 on at

Like (0)

Report
Re: Filter partial item names on gallery

@Sormick - could you try:

Filter(Documents, "lisbon" in 'Full Path')

Was this reply helpful? Yes No
Sormick 516 on at

Like (0)

Report
Re: Filter partial item names on gallery

Sorry, still does not work for me.
The folder path and full path are stored into two columns of my sharepoint document library.
So used this formula:
Filter(Documents, "lisbon" in FULLPATH)
The FULLPATH refers to the sharepoint column where is stored the full path of my files
i have a another column where is stored the folder path of my files.
What do i need to change in my formula to filter only the filenames "Lisbon" ?

Was this reply helpful? Yes No
Sormick 516 on at

Like (0)

Report

Re: Filter partial item names on gallery

Maybe should i use an automate to get the filenames based on partial value?
at this time i did not managed to do that

Was this reply helpful? Yes No
SalashMan 45 on at

Like (0)

Report
Re: Filter partial item names on gallery

Hi @Sormick ,

Assuming the Path and FullPath are SharePoint text fields, the solution for you could be the Search formula:
Search(Documents, "lisbon", "Path")
or if you want to search within both columns:
Search(Documents, "lisbon", "Path","FullPath")

Was this reply helpful? Yes No
Sormick 516 on at

Like (0)

Report
Re: Filter partial item names on gallery

Sorry, still does not work with
Search(Documents, "lisbon", "Path")
or
Search(Documents, "lisbon", "Path","FullPath")
I manage only to access my files on the specific path using
Filter(Documents;Path="Shared Documents/General/backup/2024/A/1/")
but this filter shows all my files on this folder without filtering filenames "lisbon"

Was this reply helpful? Yes No
Verified answer

SalashMan 45 on at

Like (0)

Report
Re: Filter partial item names on gallery

Hi @Sormick ,

Is the FULLPATH a SharePoint column (text type)? And does this column contains the filenames, which should be filtered by the string "lisbon"?

If your Filter formula returns items/documents which you want to filter by column 'FULLPATH' with value 'lisbon', you can try

Search(Filter(Documents;Path="Shared Documents/General/backup/2024/A/1/"); "lisbon"; "FULLPATH")

Was this reply helpful? Yes No
Sormick 516 on at

Like (0)

Report
Re: Filter partial item names on gallery

Hi @SalashMan ,
my FULLPATH is a SharePoint column (text type).
I confirm this formula works!
Search(Filter(Documents;Path="Shared Documents/General/backup/2024/A/1/"); "lisbon"; "FULLPATH"
Thank you very much!

Was this reply helpful? Yes No