Skip to main content

Notifications

Community site session details

Community site session details

Session Id : QWNl+E2F4l9l5U+4cigIxF
Power Apps - Building Power Apps
Answered

SubmitForm function not working

Like (0) ShareShare
ReportReport
Posted on 15 Dec 2020 23:19:11 by 44

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.

  • LauraVG Profile Picture
    2 on 29 Apr 2024 at 08:37:16
    Re: SubmitForm function not working

    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.

     

    NewForm(Form3);;
    SubmitForm(Form3);;
  • BDB5013 Profile Picture
    30 on 14 Mar 2022 at 10:05:02
    Re: SubmitForm function not working

    You can enter the following code in the box OnFailure to help with troubleshooting:

    BDB5013_0-1647252259010.png

    Notify(
    Concat(Errors([@'AWP Required Pre-use Checks Sheet']), Column&": "&Message),
    NotificationType.Error
    )

  • Drrickryp Profile Picture
    Super User 2024 Season 1 on 01 Dec 2021 at 15:12:46
    Re: SubmitForm function not working

    @shavora 

    If you have an autonumber field, you can use that one. 

  • Gyllentid Profile Picture
    892 on 01 Dec 2021 at 14:43:26
    Re: SubmitForm function not working

    @Drrickryp Dataverse.

  • Drrickryp Profile Picture
    Super User 2024 Season 1 on 01 Dec 2021 at 14:33:51
    Re: SubmitForm function not working

    @shavora 

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

  • Gyllentid Profile Picture
    892 on 01 Dec 2021 at 14:24:32
    Re: SubmitForm function not working

    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. 

  • Verified answer
    tgarrity Profile Picture
    44 on 17 Dec 2020 at 14:37:12
    Re: SubmitForm function not working

    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.

  • tgarrity Profile Picture
    44 on 16 Dec 2020 at 21:05:02
    Re: SubmitForm function not working

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

  • tgarrity Profile Picture
    44 on 16 Dec 2020 at 16:23:59
    Re: SubmitForm function not working

    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.

  • tgarrity Profile Picture
    44 on 16 Dec 2020 at 15:48:31
    Re: SubmitForm function not working

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,769 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,091 Most Valuable Professional

Leaderboard