Unanswered

SubmitForm function not working

(0) Share

Report

Posted on by tgarrity

I am kind of new to Power Apps, but have a basic understanding of how things work. I have a canvas app that was generated from a SharePoint list. I modified the canvas app to meet business requirements, such as adding data validation. Also, a new label needed to be created in the form that calculates its text property based on other conditions in the form, or more specifically concatenates two values of text from the form together. The text property of the label needs to be fed back into the SharePoint list. I created the new column in the SharePoint list, and then added the related data card in the canvas app so that the data fields could be mapped appropriately.

When I fill in all of the fields on the form and select the submit (check) icon button in the top right of the screen, nothing happens. Power Apps has a couple dots scroll across the screen, but the two things that I would expect to occur are not occurring (the form would clear, and new record would be in SharePoint list). There are no errors shown during submission of the form, nor are there any errors in the canvas app designer, aside from accessibility warnings, which is not a business requirement to address yet.

For your reference, I have not modified the behavior of the SubmitForm () function, which is shown as below:

SubmitForm(AddUnifiedGroup_EditForm)

I've seen some related posts on this topic with some suggesting that a field may be required to be mandatory in the SharePoint list and not required in the canvas app, but that is a moot point since I've filled out all fields of the form. What would REALLY be helpful is seeing SOME sort of error to help me diagnose the problem. Since I have no error, I need someone's help on these forums.

Categories:

Building Power Apps

I have the same question (0)

All responses (13)

Answers (1)

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@tgarrity

Another reason for failure to submit the data in the form is if you modify the source in your galley where you choose the record to edit, you must have a specific way for your form to recognize the record. Make the Item property of the form something like: Lookup(datasource, ID= Gallery1.Selected.ID).

Does the form work to submit new data? Is the DataSource property of the form the actual list in SharePoint? You can put a function like Notify() in the OnSuccess and OnFailure properties of the form to troubleshoot; in OnSuccess: Notify( "It Worked!", NotificationType.Success); ResetForm(AddUnifiedGroup_EditForm)
OnFailure: Notify("Darn it failed",NotificationType.Error)

Was this reply helpful? Yes No
tgarrity 44 on at

Like (0)

Report

Unfortunately I did not understand the first paragraph. The (3rd) screen that I have the form on does not contain a gallery. I am not trying to modify any existing records in the gallery (SharePoint list). It's just a form. And I'm creating a new record when submitting the form. If I make a brand new canvas app from the same SharePoint list, without modifying the form, I am able to create a new record. The form submits as expected, and I see the new record show up in the SharePoint list.
The DataSource property is still the same as it was originally [@'Unified Group Provisioning'], which is the name of the SharePoint list.
I implemented the OnSuccess and OnFailure functions that you mentioned, which confirmed to me that the form failed to submit, but unfortunately I am no closer to actually diagnosing what is happening.

Was this reply helpful? Yes No
tgarrity 44 on at

Like (0)

Report
I just found this "Monitor" feature and started the app and attempted to submit it. I noticed I got a few of the errors with the custom connector that I created for querying Azure AD using the Microsoft Graph, which as you can tell I called MSGraph, and an operation called GetGroups, which gets all Azure AD group names. I assign the result of the GetGroups operation to a variable called AADGroups, and is triggered when a user clicks a button on the form called Preview_Button.
I first get this, which has a Success result (status: 200), and I replaced the data in the returned data with { --- }.
{ "status": 200, "duration": 218.94, "dataSource": "MSGraph", "responseSize": 7212, "controlName": "Preview_Button", "propertyName": "OnSelect", "nodeId": 55, "formulaData": { "script": "", "spanStart": null, "spanEnd": null }, "data": { --- } }
But immediately after that, I get 7 errors (status: null) stating the below
{ "status": null, "duration": null, "dataSource": null, "responseSize": null, "controlName": null, "propertyName": null, "nodeId": null, "formulaData": { "script": "", "spanStart": null, "spanEnd": null }, "data": { "property": "onPremisesSyncEnabled", "info": "JSON parsing error, expected 'string' but got 'boolean'.", "issue": "This is more likely due to mismatch between metadata and actual data received. Please ensure your metadata and server response match." } }
Could this be the reason why I am not able to submit the form? If so, I'm still not sure what it is I need to do to proceed in fixing this.

Was this reply helpful? Yes No
tgarrity 44 on at

Like (0)

Report
ok I may be getting somewhere. I went into the custom connector because I realized that the schema must have been misinterpreted when I provided what a response would look like. I turned on the swagger to look at the definition for onPremisesSyncEnabled property.
I'm getting this error when I test the operation
Structural error at paths./v1.0/groups.get.responses.default.schema.properties.value.items.properties.onPremisesSyncEnabled.format
should be string
Jump to line 50
And here's line 49-50

onPremisesSyncEnabled: {type: boolean, description: onPremisesSyncEnabled, title: '', format: null}

The error goes away if I take off

, format: null

But then I get this error when I perform a test operation
Property ".value.Item.onPremisesSyncEnabled" type mismatch, Expected: "boolean", Actual: "string".
All I am trying to run is this HTTP request with this operation.
https://graph.microsoft.com/v1.0/groups
I don't even care about the value for the property onPremisesSyncEnabled. I am only caring about the displayName property.

Was this reply helpful? Yes No
tgarrity 44 on at

Like (0)

Report

One other tidbit: the onPremisesSyncEnabled property can either be true or null. It is never false. Don't ask me why, I'm not the one who developed this attribute in the Microsoft Graph.

Was this reply helpful? Yes No
tgarrity 44 on at

Like (0)

Report

Turns out that the MSGraph custom connector is not at fault for the form submission failure. Back to square one.

Was this reply helpful? Yes No
Verified answer

tgarrity 44 on at

Like (1)

Report

I fixed the problem. turns out that I had renamed some columns in the SharePoint list because some had spaces in the name, which resulted in the column name field being shown as Group_x0020_Type. So I thought if I removed the space from the column name, that would remove the _0020_ from the field, and so therefore I had updated the app to remove that part of the data field name. Only after more closely looking at the Monitoring of the app did I realize that the SharePoint field name will never change, no matter how much you try to rename it, since renaming it is simply changing the display name of the field, and not the actual field name.
To easily revert my bad changes, I created a new canvas app from the SharePoint list, and copied over the values to the appropriate sections that I had modified in my original app. Problem solved.

Was this reply helpful? Yes No
Gyllentid 894 on at

Like (0)

Report
Hey @Drrickryp in
Lookup(datasource, ID= Gallery1.Selected.ID).
What is ID? I see it on multiple posts but when I use it it's not a name that is recognized.
In the Item property (the field called "Item". If I have a Datasource called 'Candidates' that I want to save this to...
I would write:
Lookup(Candidates, ID= Gallery1.Selected.ID).
Is ID the column within the datasource? But won't the whole form just be pointed to a specific column?

My gallery is using a datasource of a related datasource... it's items have for example ThisItem.ColumnName.Name to fetch the related records.

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@shavora

What is your datasource? SharePoint, dataverse, Sql, etc?

Was this reply helpful? Yes No
Gyllentid 894 on at

Like (0)

Report

@Drrickryp Dataverse.

Was this reply helpful? Yes No