Patch error when resubmitting form with a single control - even though the control is in view mode if the user returns to the form

[KBeale]

I am setting a variable "varPrimaryThematicGoal" using the OnSelect property of a radio control: Set(varPrimaryThematicGoal,rdoPrimaryThematicGoal.Selected.Value). I use it to show/ hide cards on subsequent screens. I need to allow users to navigate back to the screen with the radio control, but to prevent them from changing the answer am using this formula on the radio control DisplayMode: If(varPrimaryThematicGoal<>Blank(),DisplayMode.View, DisplayMode.Edit). 

My problem is that when someone navigated back to the screen with the radio control and then to another screen, they see a patch error, even though they did not change the selection. 

I was getting the same error if they changed the selection and I was hoping that disabling the ability to do so would fix the issue, but no such luck. 

I also tried setting the variable when the form is submitted (rather than when the radio is selected) but still seeing the same issue. 

Can anyone advise me on what may be happening and how to prevent it? This has me stumped, but I'm a newbie so I must be missing something. Thanks in advance!!!!

[KeithAtherton]

Hi @KBeale,

How is the Patch() function called please?

---

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Follow me online.

[KBeale]

That’s the weird thing that I should have mentioned, I’m not using a patch function. The error is triggered just by resubmitting the form…

[KeithAtherton]

Thanks for the info. Try changing your code similar to the following - if the variable is not-blank, submit the form then reset the variable (to avoid the SubmitForm() function being called again after navigation):

If(!IsBlank(varPrimaryThematicGoal),
  SubmitForm(frmForm);
  Set(varPrimaryThematicGoal, Blank());
);

---

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Follow me online.

[KBeale]

I should use the formula you suggested on  OnSelect for the button to submit the form and leave OnSelect for the radio control as: Set(varPrimaryThematicGoal,rdoPrimaryThematicGoal.Selected.Value)? or use it on the OnSelect for the radio control and submit the form from the button using SubmitForm()? Sorry, I’ve tried so many variations I’m getting lost. Thank you so much for your help! I ran out to run an errand and I’ll try what you suggest as soon as I get back! 

[KeithAtherton]

Good question: Use my code snippet in the last message on your form submit button OnSelect property, and keep your rdoPrimaryThematicGoal OnSelect property code as-is (i.e. setting the varPrimaryThematicGoal variable).

The thinking behind this is that when you change the radio button selection, the variable is set (which you've done already). When you then submit the form, the variable has a value so the form is submitted then the variable is cleared so clicking the button again will not attempt to submit the form again (and, hopefully, avoid the Patch error).

---

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Follow me online.

[KBeale]

I tried your code and I was still getting the patch error  😞 I realized that maybe the variable I had set for the rdo value was competing with the global variable I have been using to view the same record across multiple forms (varRecord). I tried using varRecord.'Primary Thematic Goal'.Value="name of choice in rdo Primary Thematic Goal", but when I did, I noticed that value for that column was not updating in the variable when I submitted the form. I added a text label to show varRecord.'Primary Thematic Goal'.Value, and can see that it stays blank, despite the column in the list being updated. Do you have any insight on what could be going on? I am leaning towards just setting the visibilty of cards on subsequent screens with rdoPrimaryThematicGoal.Selected.Value="name of choice in rdo Primary Thematic Goal", but I'm worried it will slow things down pulling from a control a different screen.... And I'm just weirded out that the rdo control selection isn't updating my global variable! Could I be doing something wrong with the rdo control itself? Or could there be an issue with the column? I checked and I do not have column validation turned on, and the column is set to single select and radio buttons in SP. Thanks again for any insight! 

[KeithAtherton]

Out of interest, what is the patch error message?

Also, the radio control does have an OnChange action property - have you tried using code on this property instead of the OnSelect property?

Referencing a control on another screen isn't an ideal practice but worth a test to see if it helps.

---

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Follow me online.

[KBeale]

The error was saying a conflict with info on the server. When I select an option in the radio control I can still see that the variable is not updating (also when I hit save and submit the form)´. Referencing the control does seem to be working, but I am still stumped as to why the variable isn't updating, as I would prefer to use it. OnChange (and OnSelect) for the radio control are both currently empty (I was relying on adding the value and submitting the form - which IS updating the list). Is there something I shouldf try in OnChange to update update the column value in the varRecord variable (without causing errors ;)). Thanks again for your time! 

[KeithAtherton]

Try setting the radio control OnChange property to set varRecord (or another variable) to see if a variable is updated then the radio control value is changed.

Another test would be to call the Patch() function instead of the SubmitForm() function to see if it helps.

---

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Follow me online.