Data is not getting stored in my sharepoint list using patch function

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

My power app has a radio button 1 for copy record and 2 for creating record

for the first 1 button ,the user will be able to copy the record and submit

and for the 2 user has to manually enter the details to submit the form

I'm using label's for autopopulating the record from the sharepoint list for the first radio button

Label text property : LookUp(SUAD,'Employee Name'=ComboBox1.Selected.Result,Module)

when submitting the form I'm setting these labels as variable

on select of submit button : Set(var01,Label17.Text);Set(var02,Label15.Text);submitform(form1)

on success of my form : If(Radio1.Selected.Value="Role copy",Patch(SUAD,First(Filter(SUAD,ID=Form1.LastSubmit.ID)),{M1:var01},{R1:var02}));Notify("Your Submission has received",NotificationType.Success);ResetForm(Form1);NewForm(Form1)

The data is not getting recorded into my sharepoint list and the form isn't resetting after submission, it is shown as nothing to display

Could anyone help to figure out the exact issue

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

v-jefferni Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anonymous ,

I think this code causes the problem.

You could try the following code:

If(Radio1.Selected.Value="Role copy",Patch(SUAD,Defaults(SUAD),{M1:var01},{R1:var02}));Notify("Your Submission has received",NotificationType.Success);ResetForm(Form1))

Note: 1. NewForm will convert the form to New mode, which will include nothing in the form. 2. Patch to a specific record which defines in the second parameter will not generate another record, but just update the existing one.

Best regards,

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

HI,

The form is getting reset after submission but, the data is not getting stored in my share point list

Was this reply helpful? Yes No
Verified answer

WarrenBelz 156,454 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anonymous ,

Firstly, please get away from those calculated labels - they are not reliable in their refreshing sequence and set Variables directly on the relevant formulas (put the other formula in where I have it marked). Also capture everything before you submit the Form

UpdateContext( { varCopy: Radio1.Selected.Value, var01: LookUp( SUAD, 'Employee Name' = ComboBox1.Selected.Result ).Module, var02: YourLabel2FormulaHere } ); SubmitForm(Form1)

then OnSuccess (you do not need to reset the Form if you are going the change mode to New)

If( varCopy, Patch( SUAD, {ID: Self.LastSubmit.ID}, { M1:var01, R1:var02 } ) ); Notify( "Your Submission has received", NotificationType.Success ); NewForm(Form1)

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No