web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Filter based on either...

Power Apps

Answered

Filter based on either label

(0) Share

Report

Report

Posted on by MWads44

62

I want to filter my gallery on either label and display them in a gallery.

Current code is - FirstN(SortByColumns(Filter(tblAssetsTracking,Title = MainSite.Text Or AdSite1.Text),"ID",SortOrder.Descending),50)

However if i have it look up at 2 label conditions it will not load, if i remove the or label it works.

Any ideas.

I hope it makes sense, i want to load all records based on those label values and only those values.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

SpongYe 5,909 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @MWads44

Try this:
FirstN( SortByColumns( Filter( tblAssetsTracking, Title = MainSite.Text || Title = AdSite1.Text ), "ID", SortOrder.Descending ), 50 )

If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

Was this reply helpful? Yes No
Verified answer

AARON_C 2,235 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @MWads44,

Can you try:
FirstN( SortByColumns( Filter(tblAssetsTracking, Title = MainSite.Text || Title = AdSite1.Text ), "ID", SortOrder.Descending), 50)

Please tick Accept as solution if the answer is useful.
Thanks,
@AARON_C

Was this reply helpful? Yes No

Join the conversation