Duplicate Detection in Power Apps

(0) Share

Report

Posted on by Jaleelford_123

Hello Team,

Good Day!

I have a customized Power Apps, i have created a duplicate detection for two Datacards. 1. Document number and 2. Check Number. I used lookup formula when the Datacard is saved. On select option for the submit button the below formula used but it is showing a warning message. If(IsBlank(LookUp('Europe Manual Check Request',DataCardValue18.Text = 'Document number', LookUp('Europe Manual Check Request',DataCardValue11.Text = 'Check number')), SubmitForm(SharePointForm1), Set(showDialogue,true)))

Pls help me. Refer screenshot below -

Duplicate detection.JPG

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

WarrenBelz 156,425 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Jaleelford_123 ,

Is this the outcome you are expecting?

If( IsBlank( LookUp( 'Europe Manual Check Request', DataCardValue18.Text = 'Document number' && DataCardValue11.Text = 'Check number' ).'Document number' ), SubmitForm(SharePointForm1), Set(showDialogue,true) )

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Jaleelford_123 36 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for responding. Im expecting the same outcome.
Even after applying the condition you have given, error showing on the Submit button. Pls help me rectify the same. Pls refer screenshot for your reference.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 156,425 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Jaleelford_123 ,

What does the error say - I cannot see one marked in the code you posted (and the syntax is correct)

Was this reply helpful? Yes No