web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / PowerApp is only submi...
Power Apps
Answered

PowerApp is only submitting once to my list and then will not show submissions afterward.

(0) ShareShare
ReportReport
Posted on by 4

Good day,

 

I have created a multi-page power app connected to my data source (Request Form Test List on Microsoft Lists). The three forms I have are 'Requestor Info', 'Sample Info' and 'Analysis Info'. All forms are set to FormMode.new and are connected to the data source 'Request Form Test List'. I have the Item sections set to Defaults('Request Form Test List'). 

 

I have prepared a "Submit" button using the following code:

Patch('Request Form Test List',
Defaults('Request Form Test List'),
'Requestor Info'.Updates,'Sample Info'.Updates,'Analysis Info'.Updates);
NewForm('Requestor Info');
NewForm('Sample Info');
NewForm('Analysis Info');
Notify("Request Submitted",NotificationType.Success);
Navigate(SubmissionSuccess)

 

When I use the form for the first time, it submits to the connected list source perfectly. However, any subsequent entries to the form (after opening a new session, refreshing current session, etc.) do not successfully add entries to the list. The app still gives the success screen though after submission. Furthermore, if I delete the single generated entry on the source list, the form will submit successfully once again and then fail to afterward. I confirmed there are no filters on my list that would hide the other entries as well. 

 

I am hoping that someone can guide me in the direction of where my error may lay, I can provide any addition information needed too, of course. 

Categories:
I have the same question (0)
  • Verified answer
    RandyHayes Profile Picture
    76,299 Super User 2024 Season 1 on at

    @STRead2 

    First off, you should not be splitting your forms and using a Patch statement to submit them.  You are losing all the functionality of your forms by doing that and there is no need.

    To learn how to split a form properly and maintain all functionality, please take a look at this video on doing it.

     

    I mention this primarily because you are patching and then notifying and navigating all in the same action.  What happens if the patch does NOT submit successfully?  Your users will get a false impression.

     

    By maintaining the functionality of the form, you will have all the luxuries of the OnSuccess and OnFailure actions of the form and can catch those situations without additional work.

     

    As to your specific scenario, I would suspect that you are editing a record initially rather than creating.  Thus, at least one of your forms has a primary key in it.  Regardless of the fact that you are supplying a Defaults (which is not needed), the order of the patch would override the primary key with the existing key from any one of the forms.

     

    Patch (and the form as well) is smart enough to know that if a primary key exists, it will Update a record.  If not, it will create a record.

     

    I hope this is helpful for you.

  • STRead2 Profile Picture
    4 on at

    Thank you so much for your quick reply. I will review the video and your suggestions today and will be sure to accept as solution once I fix my issue. I really appreciate your time!

  • RandyHayes Profile Picture
    76,299 Super User 2024 Season 1 on at

    @STRead2 

    No problem.  Look it through and see what questions you might have then.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 358 Most Valuable Professional

#2
11manish Profile Picture

11manish 207 Super User 2026 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 150 Super User 2026 Season 2

Last 30 days Overall leaderboard