The item has already been created on the server

[Gargoolgala]

Hi,

I have an app connecting to Sharepoint lists and I am gettign the error "The item has already been created on the server......." - see attached screenshot.

I do not get this when I run PA from the web page - only when I run it from my sharepoint - I have it embedded in an iFrame.

It is a random error - I only get it when I go into the main screen of my app which is loading a lot of Shaepoint data from a list, but not all the time - sometimes it is fine. I have a decent connection to the internet - approx 70mbs download but only 2mbs upload - not sure if that matters.

I am not saving a thing at this point - simply loading the forms - multiple forms based off the same list - yes I can have 2 forms being loaded with the same data from the same field.  Still not saving anything as far as I am aware.

Is there a way to troubleshoot this to find out what might be causing the conflict?  

Anyone seen this before?

[v-monli-msft]

Hi @Gargoolgala,

Do you have any other web parts in this page? I have never seen this error in my site. Please check if this is related to the other parts of your custom site.

Regards,

Mona

[Gargoolgala]

Mona,

if you mean web parts in my sharepoint site then no - I have no other web parts - it is the only one.

Is ther a way to debug - PA needs to help us help ourselves

[bdodu]

Are you updating the list with Patch ? May be on the OnChange event of one control?

[Gargoolgala]

I have many OnChange events in the form but I would hope that when simply opening a form it does not consider that to be a OnChange event.

[Gargoolgala]

What seesm to be happening is the OnChange event is causing this issue.  I have the following in my onChange:

If("Windows" in dcvServerOS.SelectedItems.Value,false,Patch('Secure Print Assessments',First(Filter('Secure Print Assessments', ID=SelectedCustomer.ID)),{ServerOS:dcvServerOS.SelectedItems,WindowsServerOS:lbEmptyMulti.SelectedItems.Value}));If("Windows" in dcvServerOS.SelectedItems.Value,false,Reset(dcvWindowsServerOS));If("Other" in dcvServerOS.SelectedItems.Value,false,Patch('Secure Print Assessments',First(Filter('Secure Print Assessments',ID=SelectedCustomer.ID)),{OtherServerOS:txtEmpty.Text}))

My goal here is that when I seelct certain values in a combobox I will either reset another field pending what my choice is - basically if I remove Windows as an entry then I want anohter field set to empty by patching it to a null value of an empty combobox.  I then reset the combobox which has been patched to null in my SP List.  I also have a similar rule based on Other.

If  I remove the onChange event I do not get the error.   What seems to be happening is the onChange event kicks in when I open a form for that record - I only want it to trigger when I actually change a value - not when I load the form.

Any ideas on how to avoid the OnChange event when the form loads a new record?  Or a better way to reset the combobox to a null value?

[bdodu · Accepted solution]

in your case OnChange executes multiple times and therefore you need to keep a hidden original value.

Before your patch check the old value to see if you really need to execute a patch. This way the onchange will not execute and you will get rid of the ugly error.

Write an IF in front,  something like if( <changed?>, <your_original_if>, false), where <changed> is the comparison with the hidden value.

[Gargoolgala · Accepted solution]

Bdodu,

yes - this is exactly what I was intending on doing(glad you are thinking the same way) - although I have also logged a support call as I do not think OnChange should be triggering just because of a new record.

I was hoping to avoid working around what seems to be a bad design - in my head at least 🙂

Do you know if OnChange is intended to trigger even if I am simply switching records?  BTW - If I open record 1 - get the error - then go back to home page - open record 1 again it gives no error - I assume as it is still on the same record and nothing has changed.

Thanks for the help -  I will let you know if it works.

[Gargoolgala]

I added a variable to check the onchange event and this method worked but it was not ideal.

After logging a support call with MS they did confirm that when a record changes it is considered a OnChange event.

In the end I removed my OnChange events completely and used a different method based on the data card being visible or not and setting the Update value based on the visibility e.g. If(datacardvalue.Visible=true, datacardvalue.Text,txtEmpty.Text) where txtEmpty.Text is a generic value I can work with e.g. N/A