How to stop user to submit form if nothing is been edited

[MIA27]

I am working on Power app for teams.

I have Tick mark icon under which on select property I am using the below code:

SubmitForm(SupportEditForm);ResetForm(SupportEditForm)

Some time user click even if he has done no changes on the edit form.

I want the code not to run , if there is no edit been done OR no changes has been done  on the edit form.

It should only only run if the form is new or available data has been edited

Please guide what additional collection of code to be done to achieve this.

[ANB · Accepted solution]

Hi @MIA27 , Basically you need to check whether the data which is available in source is not equal to data which is available on form, if this is true then the SubmitForm should be trigger.

Example:

1. I have form which is connected to SharePoint List.
2. The Form has lets say 2 fields. FirstName and LastName.
3. First declare variable which will have the record information which is on the Item property of your form. E.g. gblvar_Record

Then the onselect code should be this way:

If(
    Or(
       gblvar_Record.FirstName <> FirstNameControlName.Text, 
       gblvar_Record.LastName <> LastNameControlName.Text
      ), 
SubmitForm(SupportEditForm);
ResetForm(SupportEditForm)
)

NOTE: You need to check all the fields. In above example I have just show 2 field.  

-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

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.👍

Thanks,
ANB

[rubin_boer]

hi @MIA27 

As per @ANB method to check you can also store the record as when the form load/record selected and if the form fields do not differ from your stored record the submit button is disabled.

[MIA27]

sorry, it's not clear to me. 

I am new in coding and want to understand and then implement, so that  the code can be used at several screen's Edit form in the App

"First declare variable which will have the record information which is on the Item property of your form. E.g. gblvar_Record"

Your mean gblvar is a collection of the records?.

As the table on which Edit form is based is having more than 3200 records and growing around 15 records per day.

 A bit more details on the gblvar with an example will help me to understand.

[MIA27]

Its no getting clear to me. 

Your reply with an example of code will help me learn and apply.

As I have several Edit Form, on which I have to apply same method.

Kindly reply more in details to understand with code example

[ANB]

@MIA27 Please help me with screenshots of form and fields then I can try to explain you.The example that I gave you is generic one.

Thanks,

ANB

[MIA27]

Thank you for your time and advise.

In the Below Image - Left side is the Filtered gallery, on select the Edit form is connected: 

On Select  property of the Tick Icon

SubmitForm(SupportEditForm);ResetForm(SupportEditForm)

On display mode property on tick icon, I am using ,below code:

If(

IsBlank(DataCardValue18.Value) || IsBlank(DataCardValue22.Text),

DisplayMode.Disabled, DisplayMode.Edit)

Data source of the edit form: 

 As mentioned in my first post, that the new records - New form -  submit is ok.

My issue is that I want the user to stop on edit record from clicking and running the save if there is no field edited.

I have worked several years for MS Access programming and worked a lot on VBA.

In VBA there is an function Me.Dirty (it means if any old record is edited on the form then this get function can get trigger.

to explain you more below is the link:

https://learn.microsoft.com/en-us/office/vba/api/access.form.dirty(property)

Exactly that is my requirement here, tick mark not to work on old record if no edit has been done on the form.

Please guide

[ANB · Accepted solution]

Hi @MIA27 , I will try to answer this , however you need to change the control name as per your requirement because the screenshot that you have provided is blur for me.

Go to your left side Gallery and on the OnSelect property of gallery have this code:

Set(gblvar_Record, ThisItem)

Now, the OnSelect code of your ticket control will be this:

If(
    Or(
       gblvar_Record.Field1 <> Field1_ControlName.Text, 
       gblvar_Record.Field2 <> Field2_ontrolName.Text,
       gblvar_Record.Field3 <> Field3_ControlName.Text, 
       gblvar_Record.Field4 <> Field4_ControlName.SelectedDate,
       gblvar_Record.Field5 <> Field5_ControlName.Text, 
       gblvar_Record.Field6 <> Field6_ControlName.Text,
       gblvar_Record.Field7 <> Field7ControlName.Text, 
       gblvar_Record.Field8 <> Field8_ControlName.Text
      ), 
SubmitForm(SupportEditForm);
ResetForm(SupportEditForm)
)

Field1---Field8 are nothing but the fields from your Data source and Field1_ControlName----Field8_ControlName are control names from form. 

Please change the name accordingly.

With, SubmitForm will only trigger if there is any change made in these 8 controls which is not equal to data from data source.

-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

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.👍

Thanks,
ANB

[MIA27]

First of all thank you so much for your time and details explanation, not only several readers will be get learning with it.

Applied the code as you suggested in test form first , no error but yellow mark i am getting. When click no action - even If I change the data also, still it remain same, button code does submit the form.

If(

    Or(

       gblvar_Record.SerialNo <> DataCardValue1.Value, \\ its a text type field

       gblvar_Record.JobAmt <> DataCardValue2.Text,  \\ its currency type  field

       gblvar_Record.LineNo <> DataCardValue3.Text, \\ its  number type field

       gblvar_Record.Model <> DataCardValue4.Value, \\ its a text type field

      ),

SubmitForm(SupportEditForm);

ResetForm(SupportEditForm)

)

error screen image

please guide what changes to do to get the resutl

[ANB]

@MIA27 Try this

If(
    Or(
       gblvar_Record.SerialNo <> DataCardValue1.Value, \\ its a text type field
       gblvar_Record.JobAmt <> Value(DataCardValue2.Text),  \\ its currency type  field
       gblvar_Record.LineNo <> DataCardValue3.Text, \\ its  number type field
       gblvar_Record.Model <> DataCardValue4.Value \\ its a text type field
      ),
SubmitForm(SupportEditForm);
ResetForm(SupportEditForm)
)

Basically, use Value function as Value(DataCardValue2.Text) and remove the extra comma after DataCardValue4.Value

-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

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.👍

Thanks,
ANB