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.
I read your post because i was also experiencing problems with the SumbitForm function. Have you tried writing "NewForm(Form_name)" befoure the SumbitForm function? I was looking also to save new records in a Sharepoint list and this solved my problem.
You can enter the following code in the box OnFailure to help with troubleshooting:
Notify(
Concat(Errors([@'AWP Required Pre-use Checks Sheet']), Column&": "&Message),
NotificationType.Error
)
What is your datasource? SharePoint, dataverse, Sql, etc?
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.
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.
Turns out that the MSGraph custom connector is not at fault for the form submission failure. Back to square one.
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.
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.
WarrenBelz
146,769
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,091
Most Valuable Professional