cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Applasaurus
Level: Powered On

Submit Form - New Claim to Sharepoint list

I've created a claim form for users to complete and submit. When they click the Submit button the completed form should be created in Claim_Entry sharepoint list with the StatusID set To PEN, but nothing is populating in the Sharepoint list (Help!)

 

Here is the code that OnSelect for Submit button:

 

SubmitForm(frmNewClaim);({StatusID: "PEN"});
Navigate(ScrSubmitSuccess);
ResetForm(frmNewClaim)

6 REPLIES 6
WarrenBelz
Level 8

Re: Submit Form - New Claim to Sharepoint list

Hi @Applasaurus ,

Why are you resetting the frmNewClaim after submitting?

Also what is the context variable {StatusID: "PEN"} doing?

Also you need to Refresh the data source before anything on ScrSubmitSuccess will reflect what you have just submitted.

To test your issue, try this on the OnSelect of the save button

SubmitForm(frmNewClaim);
Refresh(Claim_Entry);
Navigate(ScrSubmitSuccess)

and see if this solves your issue - we will deal with the Variable after this.

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Applasaurus
Level: Powered On

Re: Submit Form - New Claim to Sharepoint list

Hi @WarrenBelz 

 

Thanks for the code, I entered it in OnSelect but it didn't update the sharepoint List. 

 

I reset the form so that it's blank after submitting, do I not want to do this if the form is submitted?

 

Setting the status ID to PEN on submission is to update the status in Sharepoint, and the PEN status is a filter set when the line manager opens the app for their approval/rejection.

WarrenBelz
Level 8

Re: Submit Form - New Claim to Sharepoint list

Thanks @Applasaurus ,

We might try drilling down a bit further - what is the code opening the new form and where is it initiated from?

Also there is no need to reset a new form after submission if you are navigating away from it.

Applasaurus
Level: Powered On

Re: Submit Form - New Claim to Sharepoint list

The button on th main menu navigates to the new claim screen, DataSource for the form is Claim_Entry Sharepoint List and the Default Mode is NEW

WarrenBelz
Level 8

Re: Submit Form - New Claim to Sharepoint list

Ok thanks - just looking for unobvious issues - does the code say NewForm(FormName)?

WarrenBelz
Level 8

Re: Submit Form - New Claim to Sharepoint list

Also - just covering bases - have you also refreshed and checked the SharePoint list in SharePoint to check that the item is not there - I have had issues at times with PowerApps in development mode not refreshing properly.

Helpful resources

Announcements
thirdimage

Power Apps Super User Class of 2020

Check it out!

thirdimage

New Badges

Check it out!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors
Users online (5,330)