Problems submitting an edited record/item

(0) Share

Report

Posted on by Lefty

1,625

Hi everyone,

This is the first time, in my canvas app I'm allowing users to edit an already submitted request, as this was not a requirement is previous forms.

I'm unsure how I do this.

I have deep linking set up, allowing a user to navigate to there submitted record. ✔️
Created an edit button for the user to be able to edit the items, edit button on each screen becomes active using 1 variable ✔️
The form spans across 5-7 screens, so I assumed I had to use the same code I had on my new form but by doing so it created a new record in my SharePoint list ❌:

UpdateContext(
	{
	vPatchedRecord:
	Patch(
		List, Defaults(List),
		FormHome_2.Updates,
 FormPartB_1.Updates,
		'FormPartC/D_1'.Updates,
 'FormPartE/F_1'.Updates,
 FormPartFGH_1.Updates
 ) 
	}
);

What do I need to do to be able to edit and save to the same submitted record using the above forms please?

Categories:

Building Power Apps

All responses (24)

Answers (1)

Sort by

WarrenBelz 156,748 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Lefty ,
Defaults(List) will always create a new record. I cannot test this, but try the below.
UpdateContext( { vPatchedRecord: UpdateIf( List, ID=YourIDIdentifier, { FormHome_2.Updates, FormPartB_1.Updates, 'FormPartC/D_1'.Updates, 'FormPartE/F_1'.Updates, FormPartFGH_1.Updates } ) } )

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.
Lefty 1,625 on at

Like
a
(0)

Report
Copy link

Link copied!
HI @WarrenBelz

Thanks for your response, I have tried the following based on your suggestion, where vRecord is my submitted record, set on my gallery item:
UpdateContext( { vPatchedRecord: UpdateIf( List, ID=vRecord, { FormHome_2.Updates, FormPartB_1.Updates, 'FormPartC/D_1'.Updates, 'FormPartE/F_1'.Updates, FormPartFGH_1.Updates } ) } );
Hovering over UpdateIf - "The function UpdateIf has invalid arguments"
Hovering over the second form:
any ideas what I'm missing, or have i missed something you have already provided!
WarrenBelz 156,748 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Lefty ,
Danger of free-typing - curly brackets not needed for Updates
UpdateContext( { vPatchedRecord: UpdateIf( List, ID=vRecord, FormHome_2.Updates, FormPartB_1.Updates, 'FormPartC/D_1'.Updates, 'FormPartE/F_1'.Updates, FormPartFGH_1.Updates ) } )

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.
Lefty 1,625 on at

Like
a
(0)

Report
Copy link

Link copied!
@WarrenBelz
Sorry still cant get it to work

getting updateif function has invalid arguments:
UpdateContext( { vPatchedRecord: UpdateIf( List, ID=vRecord, FormHome_2.Updates, FormPartB_1.Updates, 'FormPartC/D_1'.Updates, 'FormPartE/F_1'.Updates, FormPartFGH_1.Updates ) } );
sorry, i cannot spot what it needs
WarrenBelz 156,748 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Lefty ,
Get rid of the UpdateContext for the moment, then add the Updates one at a time.
WarrenBelz 156,748 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
@Lefty,
Forget about that - I should test the whole thing together - you need
UpdateContext( { vPatchedRecord: Patch( List, {ID:vRecord}, FormHome_2.Updates, FormPartB_1.Updates, 'FormPartC/D_1'.Updates, 'FormPartE/F_1'.Updates, FormPartFGH_1.Updates ) } )

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.
Lefty 1,625 on at

Like
a
(0)

Report
Copy link

Link copied!
@WarrenBelz

Thanks
This is what I have done.
Removed:

/* UpdateContext( { vPatchedRecord:*/

UpdateIf( Covid, ID=VarID, //I've changed this as i think this needs to be VardID based on my app onstart code FormHome_2.Updates );

Keeping just this much and it doesnt complaint, tried clicking on the submit button, to see if it takes this 1 update, but clicking the button does not do anything, as my code is not OnSuccess, rather its on OnSelect

Sorry forgot to add, as soon as I add the second form in the code, it starts to complain
WarrenBelz 156,748 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

@Lefty ,
Please read my second post - like a lot of things I do not use a lot, the syntax is not obvious, UpdateIf will only take one FormUpdates, so go back to Patch (which has it s own issues in some cases).
WarrenBelz 156,748 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

@Lefty ,
I will be offline shortly due to time zone - I will pick up any responses in the morning.
Lefty 1,625 on at

Like
a
(0)

Report
Copy link

Link copied!
Thanks @WarrenBelz

Sorry, I think your code on this one is correct and the issue I am facing is it won't work for me, because of what I am trying to use in {ID:VarID} or if I use {ID:vRecord}
Neither work.
{ID:VarID} i get an error "The specified record was not found. Server Response List failed: Item not found"
This is what I have on my App OnStart
Set(VarID, Value(Param("Cov"))); If(VarID <> 0,Set(vRecord, LookUp(List,ID = VarID));Navigate(ViewScreen));
I'm not sure if you can help please?