Data Source May Be Invalid?

[ericonline]

Anyone else getting errors when trying to submit a PowerApps Form to Sharepoint?

- Happens in BOTH PowerApps Studio and the Player

- Happens on BOTH laptop browser and iPhone player

- The only red "x" is on the SubmitForm() statement

- Red squiggles stat: "An unknown error occurred". 

Tried so far:

- Closing/reopening the app

- Removing/re-adding data source (Sharepoint list)

- Selecting a different Sharepoint Connection

- Checking all Sharepoint Connections in make.powerapps.com - Data - Connections. All showed "Connected"

- Checked https://powerapps.microsoft.com/en-us/support/, no issues

Ideas?

Thanks

[timl]

Hi @ericonline 

I've not seen this problem myself, but I noticed this post the other day that looks suspiciously similar.

https://powerusers.microsoft.com/t5/Building-PowerApps-Formerly/Error-submitting-a-form/m-p/382645#M...

I thought the fix might be a simple case of refreshing the datasource but from what you're seeing, perhaps there's a deeper problem in the PowerApps/SharePoint connector infrastructure.

[ericonline]

hm...

Appears to be an issue with the Form. 

Troubleshooting:

• Create a new blank screen
• Add an Edit Form Control
• Add all Fields to Form
• Add a Button Control to screen
• OnSelect: SubmitForm(formName)
• Submits without issue...

What are some things I could look at in regards to the Form?

[timl]

That sounds really strange, I'm not sure what to suggest.

Perhaps you could try copying and pasting the form that doesn't work into a new screen and seeing whether that works? If it does, perhaps that might suggest that the specific instance of the original form has somehow become corrupt? 

[ericonline]

Copyin the Form to blank screen and submitting results in same error.

Cover me... i'm goin in for some deep debugging now...

[timl]

Hehe! Good luck Eric!

[ericonline · Accepted solution]

Found it!
Had to delete a complete DataCard.

Details:

• Data Type: Sharepoint Person-type column
• Update: combobox.Selected  //AHA!
• Control Type: Combobox
• Items: Choices(SPListName.personTypeColumn)
• Default: <blank>
• DefaultSelectedItems: <blank>

Background:

• When Sharepoint list was created, the original Person-type column had "Select Multiple" toggled OFF
• The app was built and the Form connected to the List
• Later, it was deemed we needed Multi-select for this field
• "Select Multiple" toggled ON in the SP list
• "Allow multiple select" toggled ON in the app
• However, this field would NOT write multiple names to the Sharepoint list no matter what I did
  • https://powerusers.microsoft.com/t5/Building-PowerApps-Formerly/Combobox-Multiple-Select-in-Forms/m-...
• Today, I decided to add a NEW Person-type field to the SP list with "Select Multiple" toggled ON
  • Left the old Person-type field in place
• Added the new field to the Form and copied over all the styling
• Noticed TWO differences between this new Person-type column and the original
  • Items property is set to: Choices([@SPListName].personTypeColumn) by default!
    • Why disambiguation like this by default?
  • Update property is set to:  newCombobox.SelectedItems by default
• Last note: The old Person-type column WOULD NOT ACCEPT .Selected.Items. 
  • Errored out with "Expected a record"

[timl]

That's some good debugging - glad you found the cause of the problem. Very well done!