Unanswered

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)

madlad 2,637 Moderator on at

Like (1)

Report
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 (0)

Report

@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 (0)

Report
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