Answered

PowerApps customize form - unable to submit data to Sharepoint list: There was a problem saving your changes. Data source may be invalid

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I am a no voice in PowerApps and have been developing a custom form from the SharePoint list. I am unable to save the form data from SharePoint list through Powerapp form, I am able to save data from Powerapp tool to SharePoint list though.

I have tried refreshing the SP list, form by removing the powerapp form option in Form settings and adding back the powerapp form multiple times. Still no luck! Also verified if the list had any mandatory columns to be filled, but none.

Form's Item property is set to: If(IsBlank(SharePointIntegration.Selected) || IsEmpty(SharePointIntegration.Selected),First('Volunteer Tracker'),SharePointIntegration.Selected) by default.

Since I am unable to debug the Powerapp form, I do not understand the exact issue. Please help me with this. Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

v-xida-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @Anonymous ,

I have made a test on my side, and don't have the issue that you mentioned.

Please consider clear cache of your browser, then sign in your SP List again, then remove the previous custom form from your SP List, then re-create a new one using PowerApps for your SP List, check if the issue is solved.

In addition, as an alternative solution, please consider use Patch function to submit your form data into your SP List instead of using SubmitForm function. Within your custom form app, set the OnSave property of the SharePointIntegration control to following:

If( SharePointForm1.Mode = FormMode.New, Patch( 'YourSPList', Defaults('YourSPList'), SharePointForm1.Updates /* <-- SharePointForm1 represents the Edit form in your custom form app */ ), Patch( 'YourSPList', SharePointIntegration.Selected, SharePointForm1.Updates ) );
ResetForm(SharePointForm1);
RequestHide()

Please consider take a try with above solution, then check if the issue is solved.

Best regards,

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @v-xida-msft,

I tried your below Patch function and with that I was able to figure out the cause of the issue! There was a hyperlink column in my form which was returning Picture, as Format URL as option in SharePoint was selected to return Picture for that column. I guess PowerApps does not support hyperlink columns which return picture, so I had to change my column in SharePoint to return hyperlink as hyperlink.

Then, I was finally able to submit form to Sharepoint! Thanks a lot for the function that you provided which helped me identify the root cause. After fixing the issue, I replaced Patch function with SubmitForm again and it worked!

Was this reply helpful? Yes No