Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Building Power Apps
Under review by Community Managers

Under review

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

Combining searches, with multiple searches referencing the same column to be searched

Posted on by 2
I'm trying to filter 'Product/content' by both ProductAbbreviations and ProductNames. When I pick one or the other, the code works. When I've tried to combine the code, it still only filters by the one.
 
Working:
Search(Filter(Disclaimers, (Len(EntityCombo.Selected.EntityAbbreviation)=0 || EntityCombo.Selected.EntityAbbreviation in Entity) && (Len(LOBCombo.Selected.LOBAbbreviation)=0 || LOBCombo.Selected.LOBAbbreviation in 'Product/content') && (Len(ProductCombo.Selected.ProductAbbreviations)=0 || ProductCombo.Selected.ProductAbbreviations in 'Product/content')),SearchInput1.Text,Entity,'Product/content',Disclaimer)
 
Not working:
Search(Filter(Disclaimers, (Len(EntityCombo.Selected.EntityAbbreviation)=0 || EntityCombo.Selected.EntityAbbreviation in Entity) && (Len(LOBCombo.Selected.LOBAbbreviation)=0 || LOBCombo.Selected.LOBAbbreviation in 'Product/content') && (Len(ProductCombo.Selected.ProductAbbreviations)=0 || ProductCombo.Selected.ProductAbbreviations in 'Product/content') && (Len(ProductCombo.Selected.ProductNames)=0 || ProductCombo.Selected.ProductNames in 'Product/content')),SearchInput1.Text,Entity,'Product/content',Disclaimer)

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,601 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,946 Most Valuable Professional

Leaderboard