cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Super User
Super User

Data Source May Be Invalid?

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

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

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

image.png

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

image.png

 

Ideas?

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Data Source May Be Invalid?

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
  • 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"

View solution in original post

7 REPLIES 7
Super User
Super User

Re: Data Source May Be Invalid?

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.

Super User
Super User

Re: Data Source May Be Invalid?

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?

Super User
Super User

Re: Data Source May Be Invalid?

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? 

 

Super User
Super User

Re: Data Source May Be Invalid?

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

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

Super User
Super User

Re: Data Source May Be Invalid?

Hehe! Good luck Eric!

Super User
Super User

Re: Data Source May Be Invalid?

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
  • 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"

View solution in original post

Super User
Super User

Re: Data Source May Be Invalid?

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

Helpful resources

Announcements
thirdimage

Power Apps Super User Class of 2020

Check it out!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (5,636)