Answered

How to make a STRICT search on a gallery ?

(0) Share

Report

Posted on by ProtoSup

Hi everyone, I woud to display uniquely the items who have Reference = "oui" = 'DataCardValue4'

This is my formula :

This is my gallery, here we can see my results and I won't want to see 'Ouistifouette' and 'Ouistiti' , I just want to see the items where there reference = 'DataCardValue4'

Thanks in advance 🙏

Categories:

Connectors

General Questions

Connecting to Data

All responses (3)

Answers (1)

Verified answer

madlad 2,637 Super User 2025 Season 1 on at

Like (0)

Report
Re: How to make a STRICT search on a gallery ?

Do you want the gallery to be full when nothing's typed in the search?

Maybe try something like:
If( IsBlank(DataCardValue4.Text), Logs, Filter( Logs; Upper(Trim(DataCardValue4.Text)) = Upper(Trim(Reference)); )
This checks if the user is searching, and if they are, then it filters. I also added Upper() and Trim() to make the values being compared consistent. You can remove these if you don't want them.
ProtoSup on at

Like (0)

Report

Re: How to make a STRICT search on a gallery ?

@madlad

Thank you for your answer but my gallery is empty when I put your formula, have another idea ?

🙏
madlad 2,637 Super User 2025 Season 1 on at

Like (1)

Report
Re: How to make a STRICT search on a gallery ?

Hi! For this you'll likely want to just use a filter statement, something similar to:
Filter( Logs; DataCardValue4.Text = Reference; )

Hope this helps!