Validate to avoid duplicate

(0) Share

Report

Posted on by straiderox2

Good afternoon friends,

I am making an application to be used in my company's production process, and I need to validate two data.

I use a sharepoint list, so I have a column with serial number and status.

When someone makes a new form he informs the serial number and the status of the equipment. Let's say the number is 800800-9 and the status is "In progress"

So I want it not to be possible to open a new form for the serial number 800800-9 while the status is in progress, only if it has been completed.

Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Try
If(!IsBlank(LookUp(Datasource, 'Serial Number' = "800800-9" && (Status.Value= "Completed"))),
SubmitForm(Form2),
Notify("Number already exist or not complete) )
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
straiderox2 65 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @eka24
It worked friend, thank you very much.
But now I found another problem 😞
If it is a new item, the Status field is blank, as it does not yet exist, so I cannot submit the form.
I tried to add the number 800800-8 it appears the message of notify and not saved. is it possible to make a variable that accepts if the Status field is blank?

Was this reply helpful? Yes No
Al_10 1,691 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

If(!IsBlank(LookUp(Datasource, 'Serial Number' = "800800-9" && (Status.Value= "Completed" || IsBlank(Status.Value) ))),
SubmitForm(Form2),
Notify("Number already exist or not complete)
)

Was this reply helpful? Yes No
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

If(IsBlank(LookUp(Datasource, 'Serial Number' = "800800-9" && (Status.Value<> "Completed"))),
SubmitForm(Form2),
Notify("Number already exist or not complete) )
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi@straiderox2，
Could you please share a bit more about your scenario?
Do you want to avoid submitting duplicated record which has same Serial Numbers with "In Progress" status?
To achieve this, you need to validate that if the current serial number under creating has been in "In progress" status.
I have a test on my side, please take a try as below.
Set the OnSelect property of the Submit button as below

If( IsBlank( LookUp( ProductionProcess, 'SerialNumber' = DataCardValue5.Text && (Status.Value = "In progress") ) ), SubmitForm(EditForm1), Notify( "The same Serial Number has been submitted!", NotificationType.Error ) )

Note: The 'Serial Number' column is a Text column and the Status column is a Choice type column in your SP list. DataCardValue5 represents the corresponding control to the 'Serial Number' data card.
Please check the Gif as below.
Best Regards,
Qi

Was this reply helpful? Yes No
straiderox2 65 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks to everyone, take a little bit of each solution and implant it in the application.

Was this reply helpful? Yes No