web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / I need to put 2 querie...
Power Apps
Answered

I need to put 2 queries in a gallery

(0) ShareShare
ReportReport
Posted on by 98

Personal,

I need to put 2 queries in a gallery.

the 1st I do filtering from a drop-down list the item selected by the user.

on the 2nd, I provide the user with a text entry field to find the number of a note.

But I don't know how to do these searches.

When I try to put a filter and a search is giving error.

Someone help me?

Categories:
I have the same question (0)
  • mdevaney Profile Picture
    29,991 Moderator on at

    @beatrizmoura26 
    Please share the code you tried.

     

    ---
    Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up." 

  • beatrizmoura26 Profile Picture
    98 on at

    Filter(Lista_devolucao, Status = Dropdown2.Selected.Value);
    Filter(Lista_devolucao, NotaProtheus= TextSearchBox1.Text)

  • Verified answer
    RandyHayes Profile Picture
    76,299 Super User 2024 Season 1 on at

    @beatrizmoura26 

    If your filter needs to have both of those criteria as true to display a record, then your formula should be:

    Filter(Lista_devolucao, 
     Status = Dropdown2.Selected.Value &&
     NotaProtheus= TextSearchBox1.Text
    )

     

    If your filter needs to have either of those criteria as true to display a record, then your formula should be:

     

    Filter(Lista_devolucao, 
     Status = Dropdown2.Selected.Value ||
     NotaProtheus= TextSearchBox1.Text
    )

     

     

    I hope this is helpful for you.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 392 Most Valuable Professional

#2
11manish Profile Picture

11manish 136 Super User 2026 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 109 Super User 2026 Season 2

Last 30 days Overall leaderboard