Troubleshoot an error during form initialisation (SharePoint List)

(0) Share

Report

Posted on by Ivan_Wilson

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-jefferni Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @ivan_wilson ,

Please checking in below thread, see if it could help:

Solved: Embedded canvas app - JSON Parsing error, expected... - Power Platform Community (microsoft.com)

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,

Was this reply helpful? Yes No
Ivan_Wilson 85 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No