Restrict Duplicate Entry for the End User Using form

(0) Share

Report

Posted on by akbarmahfuzalam

709

Hi Team,

Greeting for the Day!

I need help in building the formula. The ask is- How do I restrict the user for duplicate entry so that they won't be able to make the same information input on the form.

I have a Date and a couple of text fields.

DateFeild Name = DataCardValue25
Enterprise ID = DataCardValue26
LOB = DataCardValue27

These three Feild are my key for restricting the user for not giving me duplicate entry.

Some sorts of the pop-up and barring them for duplicate entry.

Categories:

Building Power Apps

I have the same question (0)

All responses (53)

Answers (3)

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report
@akbarmahfuzalam

Consider setting the DisplayMode property of your submit button...

If( CountRows(yourDataSource, DataField=DataCardValue25.Text && EnterpriseID=DataCardValue26.Text && DataField=DataCardValue25.Text ) > 0, Disabled, Edit )

I hope this is helpful for you.

Was this reply helpful? Yes No
akbarmahfuzalam 709 on at

Like (0)

Report

Hi Randy,
Thanks for your quick response. Getting one small error. If you could fix that, please

below are the key fields for restricting the user

1. Date Feild =  DataCardValue25
2. EnterpriseID =  DataCardValue26
3. LOB =  DataCardValue27

If(IsBlank((DataCardValue33.Text))|| IsBlank(DataCardValue25.SelectedDate),DisplayMode.Disabled,DisplayMode.Edit),
If(
CountRows(UtilizationException,
DataField=DataCardValue25.Text &&
EnterpriseID=DataCardValue26.Text &&
DataField=DataCardValue25.Text
) > 0,
Disabled,
Edit
)

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report
@akbarmahfuzalam

Your syntax is incorrect...should be this:

If( IsBlank(DataCardValue33.Text) || IsBlank(DataCardValue25.SelectedDate) || CountRows(yourDataSource, DataField=DataCardValue25.Text && EnterpriseID=DataCardValue26.Text && DataField=DataCardValue25.Text ) > 0, Disabled, Edit )

Was this reply helpful? Yes No
akbarmahfuzalam 709 on at

Like (0)

Report

Hi

Invalid number of arguments: received 2, expected 1.

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report
@akbarmahfuzalam

DUH....sorry, too many things going on and trying to respond to posts too today.

I left out an important part:

If( IsBlank(DataCardValue33.Text) || IsBlank(DataCardValue25.SelectedDate) || CountRows( Filter(UtilizationException, DataField=DataCardValue25.Text && EnterpriseID=DataCardValue26.Text && DataField=DataCardValue25.Text) ) > 0, Disabled, Edit )

Kind of helps to have the Filter statement in there 😉

Sorry about that!

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (1)

Report

@akbarmahfuzalam

Also...make sure you are adjusting the DataField, EnterpriseID and the other DataField names to correspond to your datasource column names.

Was this reply helpful? Yes No
akbarmahfuzalam 709 on at

Like (0)

Report

Hi Randy,

There is no error this time, however, I can see duplicate entry in the SharePoint and its the submit button is also not got greyed.

If(
IsBlank(DataCardValue33.Text) ||
IsBlank(DataCardValue25.SelectedDate) ||
CountRows(
Filter(UtilizationException,
DataField=DataCardValue25.Text &&
EnterpriseID=DataCardValue26.Text &&
DataField=DataCardValue27.Text)
) > 0,
Disabled,
Edit
)

Was this reply helpful? Yes No
akbarmahfuzalam 709 on at

Like (0)

Report

The Button is greyed out after the formula I put but the entry is still coming duplicate and it's allowing the user to get the entry into SharePoint.

If(
IsBlank(DataCardValue33.Text) ||
IsBlank(DataCardValue25.SelectedDate) ||
CountRows(
Filter(UtilizationException,
Shiftdate=DataCardValue25.SelectedDate &&
Enterprise_ID=DataCardValue26.Text &&
LOB=DataCardValue27.Text)
) > 0,
Disabled,
Edit
)

Whereas, it should stop the user by not allow the button to live. it should be greyed out.

Do we need to write few code OnSlected =Set(varRecord(lookup(UtilizationException,Shiftdate=DataCardValue25.SelectedDate &&
Enterprise_ID=DataCardValue26.Text &&
LOB=DataCardValue27.Text));
If(IsBlank(varRecord.ID),
Set(varShowSpinner,true);SubmitForm(Form1);Notify("Data Uploaded Successfully",NotificationType.Success,2000);ResetForm(Form1);Set(varShowSpinner,false)..

Just a thought.. I know there is some issue with the formula. it's not correctly formated.

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

Like (0)

Report

In addition to @RandyHayes you can try giving the user information On the OnSelect of the Submit Button:
If(IsBlank(LookUp(UtilizationException,Shiftdate= DataCardValue25.SelectedDate, DateField)), Notify("Date already exist"),
If(IsBlank(LookUp(UtilizationException,EnterpriseID= DataCardValue26.Text, EnterpriseID)), Notify("Enterprise ID Already Exist"),
If(IsBlank(LookUp(UtilizationException,LOB= DataCardValue27.Text,LOB)), Notify("LOB Already Exist"),
SubmitForm(Form1))))

------------
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
akbarmahfuzalam 709 on at

Like (0)

Report

Thanks for helping me..

Yes, I am using the Datapicker.

But every time i am pressing the button it giving me this info irrespective to what date I select or what person I select

The formula used OnSelected---------
If(IsBlank(LookUp(UtilizationException,Shiftdate = DataCardValue25.SelectedDate, Shiftdate)), Notify("Date already exist"),
If(IsBlank(LookUp(UtilizationException,Enterprise_ID= DataCardValue26.Text, Enterprise_ID)), Notify("Enterprise ID Already Exist"),
If(IsBlank(LookUp(UtilizationException,LOB= DataCardValue27.Text,LOB)), Notify("LOB Already Exist"),
SubmitForm(Form1))))

Was this reply helpful? Yes No