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 / Filter and distinct in...
Power Apps
Unanswered

Filter and distinct in a gallery

(0) ShareShare
ReportReport
Posted on by 34

Bonjour

 

J'ai un problème et je ne trouve pas de solution. 

 

Je ne peux pas me débarrasser des doublons qui apparaissent lorsque je retourne une galerie à partir d'un fichier Excel. J'ai remarqué que vous ne pouviez pas faire cela avec Distinct car il ne renvoyait qu'une seule valeur. Je suis donc un peu confus car je ne sais pas comment faire.

 

Categories:
  • jbrit2020 Profile Picture
    638 on at

    Can you share an example of the gallery without the distinct filter and the gallery with the Distinct filter?

  • Powell4 Profile Picture
    34 on at

    Ah, I finally noticed that the distinct worked well, but there is a problem with the distinct. The items I was calling through a filter when I entered one of them suddenly disappeared.

    This is due to the distinct I just put in.

  • jbrit2020 Profile Picture
    638 on at

    Can you share the line of code where you inserted the distinct?

  • Powell4 Profile Picture
    34 on at

    It is on my gallery.

    Powell4_1-1610018550389.png

    Gallery of my operation

    Powell4_2-1610018572787.png

     

     

     

     

  • jbrit2020 Profile Picture
    638 on at

    Your filter seems to be correct, I assume you're filtering your current gallery based on something selected on another gallery?

     

    I wonder if the column where you are applying the Disctinct (Operation) has an empty or blank value for the selection you've made? The one that disappeared maybe doesn't have any value under Operation column.

     

  • Powell4 Profile Picture
    34 on at

    T

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
11manish Profile Picture

11manish 395 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 328

#3
WarrenBelz Profile Picture

WarrenBelz 260 Most Valuable Professional

Last 30 days Overall leaderboard