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:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

madlad 2,637 Moderator on at

Like
a
(1)

Report
Copy link

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

Hope this helps!

Was this reply helpful? Yes No
ProtoSup on at

Like
a
(0)

Report
Copy link

Link copied!

@madlad

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

🙏

Was this reply helpful? Yes No
Verified answer

madlad 2,637 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No