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 / how to use a distinct ...
Power Apps
Answered

how to use a distinct function in this statement :c

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hello all!

 

I have a searchbox and a dropdown to filter a gallery list.

My problem now is, it displays every row 2 times, cause i have 2 filter functions to use my searchbox with the dropdown value "All" and with a selected dropdown value.


If(Dropdown1.Selected.Value = "All";Filter(coll_artikel;SearchBoxText.Text in MAKTX);Filter(coll_artikel;Dropdown1.Selected.Value = WGBEZ && SearchBoxText.Text in MAKTX))

 

How can i solve that problem, i tried to use distincts in more ways, but it wont work for me ._.

 

Please help me :c

Categories:
I have the same question (0)
  • Verified answer
    Community Power Platform Member Profile Picture
    Microsoft Employee on at

    I solved it! ^-^

    It works with the data source and not the collection i made 🙂

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 Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Valantis Profile Picture

Valantis 421

#2
WarrenBelz Profile Picture

WarrenBelz 345 Most Valuable Professional

#3
Kalathiya Profile Picture

Kalathiya 278 Super User 2026 Season 1

Last 30 days Overall leaderboard