Unanswered

Finding Duplicate Value from SP List in customized form

(0) Share

Report

Posted on by Bharat0803

Hi everyone,

I Have to check for duplicate roll number and first name in a customized SharePoint form. I have to check duplicate for roll number and first name column of SharePoint list 'Student Info' and display message "value Already Exist" in form. I was able to come up with the logic of this task :

Same logic i have applied to Roll number and it is working for Roll number when I am entering a duplicate roll number but new name which doesn't exist in the list but when Iam entering duplicate first name and new roll number then it is giving "Value Already Exist" message for both the fields which shouldn't happen. Also, the "Value Already exist" should come after clicking submit.can any one help me out with this one.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

WarrenBelz 154,926 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Bharat0803 ,

You really need to test both fields (I am guessing the control name on last name as you have to displayed it) and you do not need If/true/false

!IsBlank( LookUp( 'Student Info', Firstname = DataCardValue7.Text && LastName = DataCardValue8.Text ).LastName )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Bharat0803 32 on at

Like (0)

Report
Copy link

Link copied!

Hello @WarrenBelz ,
Thanks for replying, no I need to test for first name and roll no not the last name. The image is for first name and I have put that formula in error message part of first name DataCard(in Visible Property)

Was this reply helpful? Yes No
WarrenBelz 154,926 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Bharat0803 ,

Then based on what I posted, can you attempt the required code please.

Was this reply helpful? Yes No
Bharat0803 32 on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz
It is working; however, it is saving duplicate first name to SharePoint list which should not happen if there is a duplicate then it should be saved only after removing or changing the first name to a name which doesn't exist in list in form.

Was this reply helpful? Yes No
WarrenBelz 154,926 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Bharat0803 ,

Firstly, please supply the code you are using (in Text) and then please tell me in as simple terms as possible exactly what result you want and what is happening now as this is getting more confusing to me as it progresses.

Was this reply helpful? Yes No