Unanswered

How to submit a new form and edit form together?

(0) Share

Report

Posted on by ratas101

I have two forms (one is a new form and another is an edit form) and I want to submit the content of both forms together.

When I am using: Patch('Tracker',Defaults('Tracker'),Form1.Updates,Form2.Updates);Navigate('Success screen'), it is creating a new line item in the SharePoint. But I want the information to go in the same line item (basically update the line item in Sharepoint with new information).

How can I resolve this?

Categories:

General Questions

All responses (2)

Answers (0)

Suggested answer

Ammar Zaied 97 on at

Like (0)

Report
How to submit a new form and edit form together?

Hi,

Use a Variable to Store the Item ID:

// When navigating to the edit form Set(currentItemID, YourItemID); Navigate(EditScreen);

Patch Function Adjustment

If( Form1.Valid && Form2.Valid, // Check if both forms are valid Patch( Tracker, LookUp(Tracker, ID = currentItemID), // Find the existing item by ID Form1.Updates, Form2.Updates ); Navigate(SuccessScreen) // Navigate to the success screen only if Patch is successful )

Handling Errors

If( Form1.Valid && Form2.Valid, If( IsBlank(Patch( Tracker, LookUp(Tracker, ID = currentItemID), Form1.Updates, Form2.Updates )), Notify("Error updating item", NotificationType.Error), Navigate(SuccessScreen) ), Notify("Form validation failed", NotificationType.Error) )
Nirav (Akira28) 118 on at

Like (0)

Report

How to submit a new form and edit form together?

Hi ratas101 ,

May be you can try this one, if it works 🤞 (on Submit button)

If(
!IsBlank(Form1.LastSubmit),
Patch(
'Tracker',
Form1.LastSubmit,
Form1.Updates,
Form2.Updates
),
Notify("No existing record to update", NotificationType.Error)
);
Navigate('Success screen');

If this post solved your issue, clicking 'Does this answer your question' will help others discover the solution and close the topic. If you found it helpful, a Like would be awesome!

Regards,
Nirav J Raval (Akira28)