Gallery search with filter with two conditions

(0) Share

Report

Posted on by Sormick

566

Hello,

i have on a sharepoint document library files named like that:

TGLANP TOGO LOME AFRICA PAGE-(1).jpg

TGLANP TOGO LOME AFRICA PAGE-(2).jpg

TGLANP TOGO LOME AFRICA PAGE-(3).jpg

THBCNP THAILAND BANGKOK ASIA PAGE-(1).jpg

THBCNP THAILAND BANGKOK ASIA PAGE-(2).jpg

On my gallery i have this formula below which filters all TGLANP items:

Search(Filter(Documents;Chemin="Shared Documents/General/backup/); "TGLANP"; "Fullpath")

I need to filter "TGLANP" items which contains only "PAGE-(1)" text.

Example of result expected for TGLANP:

TGLANP TOGO LOME AFRICA PAGE-(1).jpg

I tried the formula below but did not worked.

Search(Filter(Documents;Chemin="Shared Documents/General/backup/); "TGLANP" & "PAGE-(1)"; "Fullpath")

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

WarrenBelz 156,378 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Sormick ,

You have two Delegation issues there - neither Search() nor Chemin (Path) are Delegable. If you have more than 500 documents in 'Shared Documents', you will not see the files you need. The file name is also not Delegable, so you will need to add a Text column with the filter/search information.

Was this reply helpful? Yes No
Sormick 566 on at

Like
a
(0)

Report
Copy link

Link copied!

hi @WarrenBelz ,
I am still not comfortable with delegation
Chemin is a column Text on my sharepoint library which contains the folder path for each file or folder.
fullpath is a column Text on my sharepoint library which contains the full path for each file or folder.
Do i need to add two text columns for TGLANP and ofr PAGE-(1) ?
What would be my final delegable formula?

Was this reply helpful? Yes No
Verified answer

WarrenBelz 156,378 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Sormick ,

Are these Text columns that you have created and populated with the relevant information (I was assuming that they were the built-in columns), we can probably manage that one - assuming you have no more than 500 files in that folder

With( { _Data: Filter( Documents; Chemin = "Shared Documents/General/backup/" ) }; Filter( _Data; "TGLANP" in Fullpath && "PAGE-(1)" in Fullpath ) (

If you are not comfortable with Delegation, you are going to have a lot of challenges ahead - I have a blog that should be useful in starting your learning on this.

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Sormick 566 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @WarrenBelz ,
Thank you so much for the furmula!
I will never have more than 400 files in my sub-folders. so do not need more at this time.

Was this reply helpful? Yes No