Skip to main content

Notifications

Power Apps - Microsoft Dataverse
Answered

Prevent related duplicate records

Posted on 4 Dec 2024 01:02:45 by 1,137
Hi,
 
I have Table A with a record say called A1
 
I also have Table B that has a 1 to many relationship that has say 4 records in it. Inside that table I have a whole number column called position.
 
So Table B has the following records
 
Name     TableARecord.    Position
B1          A1                      1
B2          A1                      2
B3          A1                      3
B4          A1                      4
B5          A1                      5
 
 
I need to make sure that position is only ever used once BUT only relating to the related record
 
So if I was to create another record in Table B against at A1 record with a position of 2, I would get a error message.
 
Hope this makes sense.
 
Wondering what best approach to solving this would be?
 
Thanks in advance
 
Todd
  • Verified answer
    ronaldwalcott Profile Picture
    ronaldwalcott 903 on 04 Dec 2024 at 01:15:14
    Prevent related duplicate records
    You could create a unique key using all the columns Name, Position and the TableARecord identifying column. 

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

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,297

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,890

Leaderboard

Featured topics