Skip to main content

Notifications

Power Apps - Building 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.

 

 

  • Chris-D Profile Picture
    Chris-D 1,246 on at
    Re: Powerapps - Duplicate checking in Collection

    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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,580

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,909

Leaderboard