I have a SharePoint list that I've customized using Power Apps.
Recently, an error message has started showing up the first time the view or edit form is loaded after a page load:
JSON Parsing error, expected 'object' but got 'array'
I can't reproduce this error when I edit the form in Power Apps Studio. I've looked through the code and can't see any obvious cause. I've tried using the browser developer tools to pinpoint the cause, but with no luck.
The error doesn't appear to impact on the form's functionality, but it is frustrating end users.
Are there any suggestions on how I can troubleshoot this? The monitor tool looks useful, but I haven't figured out how to get this working with a custom SharePoint form.
Thanks @v-jefferni, you were right about a mismatch between the SharePoint list and and Power Apps form. Someone changed a lookup field in the SharePoint list, enabling the "allow multiple values". Disabling this option fixed the issue.
The clue was in the app checker panel. The field's data card controls on the Edit and View screens had errors for the Default property - "Expected Record value". Changing the field back to a single selection meant the existing default property doesn't throw an error.
Hi @ivan_wilson ,
Please checking in below thread, see if it could help:
If it doesn't help, you can try and delete the form in list settings and then create the custom form from blank. There is a chance that after the form is created, the list structure has been changed, caused a mismatch in connection/SharePointIntegration.
Best regards,
WarrenBelz
770
Most Valuable Professional
stampcoin
494
MS.Ragavendar
399