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 / Powerapps - Duplicate ...
Power Apps
Unanswered

Powerapps - Duplicate checking in Collection

(0) ShareShare
ReportReport
Posted on by 34

Hi

How to do the duplicate validation between selected value and the value in collection?

 

Expected result: Display error message as per below image upon clicking "+" icon when Selected Material (dropdown list) = Material in Collection (Data table)

jshuang_1-1694424419390.png

Thank you.

 

 

Categories:
I have the same question (0)
  • Chris-D Profile Picture
    1,246 on at

    Hi @jshuang, you can do this by trying to look up the value from the collection and seeing if it's blank.

     

    If( 
     !IsBlank( 
     // Try to look up from collection 
     LookUp( 
     MyCollection,
    
     // Your dropdown is called Dropdown, and Selected.Text is the text displayed in it
     Material = Dropdown.Selected.Text
     )
     ),
    
     ... the item is duplicated ...
    
     ,
     ... this item is not duplicated ...
    )

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 549 Most Valuable Professional

#2
Kalathiya Profile Picture

Kalathiya 225 Super User 2026 Season 1

#3
Haque Profile Picture

Haque 224

Last 30 days Overall leaderboard